| Name | Description | Type | Additional information |
|---|---|---|---|
| DiaryID |
Unique identifier for a appointment |
integer |
None. |
| EmployeeID |
Associated employee |
integer |
None. |
| AppointmentStatusID |
Current status of the appointment |
integer |
None. |
| WorkOrderID |
Unique identifier for a work order |
integer |
None. |
| WOStatusID |
Work order status |
integer |
None. |
| StartDateTime |
Start time of the appointment |
date |
None. |
| DiaryNotes |
Any notes added to the appointment |
string |
None. |
| Status |
Status label of the appointment |
string |
None. |
| WORef |
Reference of the work order |
string |
None. |
| WODescription |
Description of the work order |
string |
None. |
| WODetails |
Details of the work order |
string |
None. |
| WONotes |
Notes of the work order |
string |
None. |
| PeriodicalID |
Associated contract internal ID |
integer |
None. |
| TypeID |
The type id of work order |
integer |
None. |
| OrderNumber |
Associated order number against the work order |
string |
None. |
| WOtype |
The type of work order label |
string |
None. |
| PeriodicalRef |
Contract reference associated to the work order |
string |
None. |
| SiteName |
The site name associated to the work order |
string |
None. |
| SiteRef |
The site reference associated to the work order |
string |
None. |
| AddressLine1 |
Address line 1 of the associated site |
string |
None. |
| AddressLine2 |
Address line 2 of the associated site |
string |
None. |
| AddressLine3 |
Address line 3 of the associated site |
string |
None. |
| CityTown |
City / Town of the associated site |
string |
None. |
| County |
County of the associated site |
string |
None. |
| PostCode |
Postal code of the associated site |
string |
None. |
| SiteID |
Internal site ID of the associated work order |
integer |
None. |
| Contact1 |
Contact name of the associated site |
string |
None. |
| Phone1 |
Contact number of the associated site |
string |
None. |
|
Contact email of the associated site |
string |
None. |
|
| ClientID |
Internal client id of the associated work order |
integer |
None. |
| ClientName |
Client label of the associated work order |
string |
None. |
| ClientRef |
Client label of the associated work order |
string |
None. |
| SupplierName |
Supplier associated to the work order |
string |
None. |
| SLAhours |
SLA of the work order |
decimal number |
None. |
| WorkOrderDocs |
Documents associated to the work order |
string |
None. |