Calls - Main table giving an overview of the calls that have been logged.
| Column | Type | Notes |
|---|---|---|
| AppointmentDate | DATETIME | |
| AppointmentFromTime | TIME | |
| Area | TEXT | |
| CallCompleted_YN | TEXT | |
| CallNumber | WHOLE NUMBER | |
| CallStatus | TEXT | |
| CallType | TEXT | |
| Caller | TEXT | |
| Chargeable_YN | TEXT | |
| CompanyNumber | WHOLE NUMBER | |
| CompletedDate | DATETIME | |
| CompletedTime | TIME | |
| CompletionOperator | TEXT | |
| CustomerNo | TEXT | |
| CustomerReference | TEXT | |
| DeadlineDateTime | DATETIME | |
| DefaultResponseDeadLineDate | DATETIME | |
| DefaultResponseDeadLineTime | TIME | |
| DocketNumber | TEXT | |
| DocketStatus | TEXT | |
| EngineerAssignedDate | DATETIME | |
| EngineerAssignedTime | TIME | |
| Engineer | TEXT | |
| FirstTimeFix_YN | TEXT | |
| InvoiceDate | DATETIME | |
| InvoiceGoodsValue | DECIMAL NUMBER | |
| InvoiceNo | TEXT | |
| InvoiceVAT | DECIMAL NUMBER | |
| InvoiceValue | DECIMAL NUMBER | |
| InvoicedStatus | TEXT | |
| LastEditTime | TIME | |
| LoggedDate | DATETIME | |
| LoggedTime | TIME | |
| LoggingOperator | TEXT | |
| MinutesToAssignACall | DECIMAL NUMBER | |
| NoOfEngineersTechnicians | WHOLE NUMBER | |
| NoOfHours | WHOLE NUMBER | |
| NoOfMinutes | WHOLE NUMBER | |
| NumberOfActions | WHOLE NUMBER | |
| Priority | WHOLE NUMBER | |
| ReasonForCall | TEXT | |
| ResponseDeadlineDate | DATETIME | |
| ResponseDeadlineTime | TIME | |
| ResponseHours | WHOLE NUMBER | |
| ResponseMinutes | WHOLE NUMBER | |
| Route | TEXT | |
| Signal_YN | TEXT | |
| SiteID | TEXT | |
| SystemType | TEXT | |
| WaitingReason | TEXT | |
| Waiting_YN | TEXT | |
| LastEditDate | DATETIME | |
| Deleted | BINARY |