|
Information about external organisations are stored here. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the organisation code. This code is the same as the reference number. It is also the primary key for the Organisation table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Shows the name of the organisation. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the reference number for the organisation. This number is the same as the organisation code. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Shows the URL of the organisation. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
First line of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
Second line of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
Third line of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores the country of the person's / organisation's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores the city of the person's / organisation's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores the state of the person's / organisation's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores the postal code of the organisation's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores the contact number. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores a second contact number. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Stores the email address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores the fax number. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the organisation is a medical vendor, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the organisation is a training organiser, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the organisation offers membership, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the organisation is a contractor, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the organisation is a supplier, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Displays the contractor code. |
|
|
|