| Name | Description | Type | Additional information |
|---|---|---|---|
| WorkOrderID | integer |
None. |
|
| AgencyID | integer |
None. |
|
| WorkOrderNumber | string |
String length: inclusive between 0 and 50 |
|
| GTNum | string |
String length: inclusive between 0 and 50 |
|
| DateLastUpdated | date |
None. |
|
| DateCreated | date |
None. |
|
| InstallDate | date |
None. |
|
| CompleteDate | date |
None. |
|
| EstimatedShipDate | date |
None. |
|
| Description | string |
String length: inclusive between 0 and 255 |
|
| CustomerID | integer |
None. |
|
| ContactID | integer |
None. |
|
| LocationID | integer |
None. |
|
| IsInstallerToLocate | boolean |
None. |
|
| IsSiteLevel | boolean |
None. |
|
| IsSiteAccessible | boolean |
None. |
|
| IsInstallerToUnload | boolean |
None. |
|
| TrashRemovedBy | string |
String length: inclusive between 0 and 50 |
|
| TrashNotes | string |
String length: inclusive between 0 and 250 |
|
| SurfaceDepth | string |
String length: inclusive between 0 and 50 |
|
| IsDrawingAttached | boolean |
None. |
|
| DrawingNumber | string |
String length: inclusive between 0 and 50 |
|
| InternalComments | string |
None. |
|
| InstallerNotes | string |
None. |
|
| UserID | integer |
None. |
|
| Status | string |
String length: inclusive between 0 and 1 |
|
| OrderID | integer |
None. |
|
| OrderNumber | string |
String length: inclusive between 0 and 50 |
|
| InstallerID | integer |
None. |
|
| TotalCost | decimal number |
None. |
|
| ProNum | string |
String length: inclusive between 0 and 50 |
|
| EnteredBy | integer |
None. |
|
| InvoiceCustomerID | integer |
None. |
|
| InvoiceContactID | integer |
None. |
|
| InvoiceLocationID | integer |
None. |
|
| EndCustomerID | integer |
None. |
|
| EndContactID | integer |
None. |
|
| EndLocationID | integer |
None. |
|
| TopViewPDF | string |
String length: inclusive between 0 and 150 |
|
| InstallationCompletionDate | date |
None. |
|
| ActualCompletionDate | date |
None. |
|
| WasRCI | boolean |
None. |
|
| RCI_ID | integer |
None. |
|
| PremierID | integer |
None. |
|
| WestRecreationID | integer |
None. |
|
| NorCalID | integer |
None. |