| Name | Description | Type | Additional information |
|---|---|---|---|
| DispatchId |
Sedona internal autonumber for the Dispatch record. This will not be unique becuase it's being pulled from two different tables (OE_JOb_Disaptch and SV_Service) |
integer |
None. |
| DispatchType |
Type of dispatch: TKT for service tickets, JOB for jobs. Text is not case sensitive. Use in conjunction with DispatchId to create a composite key or use RowGuid instead |
string |
None. |
| RowGuid |
Unique record identifier. The DispatchId is a combination of two tables (OE_JOb_Disaptch and SV_Service) and will not be unique. |
globally unique identifier |
None. |
| Reference |
Job_Code from OE_Job table and/or Ticket_Number for SV_Service_Ticket table |
string |
None. |
| Status |
Status of the dispatch |
string |
None. |
| Description |
Description |
string |
None. |
| ServiceTechCode |
Employee_Code from SY_Employee table; cannot change the Service Tech (must cancel and add new) |
string |
None. |
| ServiceTechId |
EmployeeId from SY_Employee table; cannot change the Service Tech (must cancel and add new) |
integer |
None. |
| CompanyCode | string |
None. |
|
| ScheduleTime | date |
None. |
|
| ScheduleTimeUtc |
Only used when useUtcOffset is set to "1" in the web.config file |
date |
None. |
| DispatchTime | date |
None. |
|
| DispatchTimeUtc |
Only used when useUtcOffset is set to "1" in the web.config file |
date |
None. |
| ArrivalTime | date |
None. |
|
| ArrivalTimeUtc |
Only used when useUtcOffset is set to "1" in the web.config file |
date |
None. |
| DepartureTime | date |
None. |
|
| DepartureTimeUtc |
Only used when useUtcOffset is set to "1" in the web.config file |
date |
None. |
| EstimatedLength | integer |
None. |
|
| SiteName | string |
None. |
|
| Address1 | string |
None. |
|
| Address2 | string |
None. |
|
| Address3 | string |
None. |
|
| City | string |
None. |
|
| State | string |
None. |
|
| ZipCode | string |
None. |
|
| JobTask | string |
None. |
|
| Complete | string |
None. |
|
| TicketPriority | string |
None. |
|
| TicketGoBack | string |
None. |
|
| ResolutionCode | string |
None. |
|
| ResolutionNote | string |
None. |