| Name | Description | Type | Additional information |
|---|---|---|---|
| RowGuid | globally unique identifier |
None. |
|
| DispatchType |
Type of dispatch: TKT for service tickets, JOB for jobs. Text is not case sensitive. |
string |
None. |
| Status |
Status of either the Job or the Service Ticket the dispatch is associated with |
string |
None. |
| DispatchStatus |
Status of the dispatch related to the dispatch, arrival, and departure times. Possible values are: undispatched, dispatched, arrived, and departed |
string |
None. |
| ServiceTechId |
Service_Tech_Id from SV_Service_Tech table |
integer |
None. |
| EmployeeId |
Foreign Key Employee_Id from SY_Employee table |
integer |
None. |
| ServiceTechCode |
Employee_Code from SY_Employee table |
string |
None. |
| StartTime |
Starting schedule time (dates without a specific time will use 12:00 AM for the time) |
date |
None. |
| EndTime |
Ending schedule time (dates without a specific time will use 12:00 AM for the time) |
date |
None. |