| Name | Description | Type | Additional information |
|---|---|---|---|
| JOBID | integer |
None. |
|
| QUOTEID | integer |
None. |
|
| SortOrder | integer |
None. |
|
| ID | integer |
None. |
|
| OrderTakenBy | string |
None. |
|
| Status | string |
None. |
|
| Datex | string |
None. |
|
| EnquiryDate | string |
None. |
|
| EnquiryTime | string |
None. |
|
| OrderDate | string |
None. |
|
| OrderTime | string |
None. |
|
| RequiredDate | string |
None. |
|
| AllocatedDate | string |
None. |
|
| CompletionDate | string |
None. |
|
| InvoiceDate | string |
None. |
|
| JobNumber | string |
None. |
|
| OrderNumber | string |
None. |
|
| OrderID | integer |
None. |
|
| AssetNumber | string |
None. |
|
| Engineer | string |
None. |
|
| EngineerListed | boolean |
None. |
|
| EngineersNotes | string |
None. |
|
| Premises | string |
None. |
|
| Address1 | string |
None. |
|
| Address2 | string |
None. |
|
| Address3 | string |
None. |
|
| PremisesPostCode | string |
None. |
|
| Telephone | string |
None. |
|
| ContactName | string |
None. |
|
| Response | string |
None. |
|
| Appliance | string |
None. |
|
| HomeEmail | string |
None. |
|
| Fault | string |
None. |
|
| QuoteNumber | string |
None. |
|
| QuoteAcc | string |
None. |
|
| ModelofAppliance | string |
None. |
|
| Labour | integer |
None. |
|
| Remarks | string |
None. |
|
| Notes | string |
None. |
|
| FFNUMBER | integer |
None. |
|
| EnqDate | string |
None. |
|
| SheetDate | string |
None. |
|
| ChargeableStatus | string |
None. |
|
| ChargedUnder | integer |
None. |
|
| ApplianceID | integer |
None. |
|
| PremisesID | integer |
None. |
|
| CSVfile | string |
None. |
|
| BatchID | integer |
None. |
|
| JJNUMBER | integer |
None. |
|
| RecallFlag | boolean |
None. |
|
| RecallNote | string |
None. |
|
| VatRate | decimal number |
None. |
|
| AccountCode | string |
None. |
|
| QuoteDays | integer |
None. |
|
| Type | string |
None. |
|
| QuoteVatRate | decimal number |
None. |
|
| RecallCount | integer |
None. |
|
| QuoteDate | string |
None. |
|
| StaffID | integer |
None. |
|
| IssueStatus | string |
None. |
|
| ServiceType | string |
None. |
|
| RequestID | integer |
None. |
|
| Quantity | integer |
None. |
|
| Recieved | integer |
None. |
|
| Awaiting | integer |
None. |
|
| Name | string |
None. |
|
| Phone | string |
None. |
|
| Address | string |
None. |
|
| CID | integer |
None. |
|
| Id | string |
None. |
|
| Value | string |
None. |
|
| Latitude_Value | string |
None. |
|
| Longitude_Value | string |
None. |