CallActions - Details of actions that have been taken been taken on a specific call. Child table of Calls table
| Column | Type | Notes |
|---|---|---|
| CK_CallNo | TEXT | Tugger created column combining: CallNo, CallActionNumber |
| CallActionNumber | WHOLE NUMBER | |
| CallNumber | WHOLE NUMBER | |
| EngineerHours | DECIMAL NUMBER | |
| Engineer | TEXT | |
| FinishedDateTime | DATETIME | |
| FinishedDate | DATETIME | |
| FinishedTime | TIME | |
| HoursOnSite | WHOLE NUMBER | |
| MinutesOnSite | WHOLE NUMBER | |
| StartedDate | DATETIME | |
| StartedTime | TIME | |
| TravelTime | TIME | |
| LastEditDate | DATETIME | |
| Deleted | BINARY |