| Id |
Primary key the unique identification of a row in the table. |
| IdParentOrganisation |
Foreign key to the table: Organisation Builds the structure of the organization. |
| Barcode |
Barcode used to identify organizations to the scanner-application. |
| Name |
A descriptive text identifying the instance to the user in the application user interface |
| IdDeletedRow |
Foreign key to the table: Deletedrow Reference to further information for the logically deleted row |
| IsDeleted |
Indication of whether the row is logically deleted |
| Fullname |
The name of the organisation prefixed with the names of all the parent organisations seperated by a "\". |
| IdPrimaryUser |
Foreign key to the table: User The user that is notified when the Active Directory integration make changes to organization or user. The user can belong to any organization. |
| ADGUID |
Reference to the organization in Microsofts Active Directory |
| IdAddress |
Foreign key to the table: Address |
| PhoneNumber |
Phonenumber |
| FaxNumber |
Fax number |
| Email |
E-mail address |
| WebSite |
Link to the organizations web-site |
| Description |
A detailed description of the instance to the user. |
| NotificationEmail |
Holds the email address for which to send notifications about organisational changes |
| ADWhenChanged |
Time when relation was last changed in AD. |