Routes
Optimized delivery routes in DeTrack. Date filter is required for all queries.
Columns
| Name | Type | References | |
| Id [KEY] | String | ||
| Name | String | ||
| Status | String | ||
| Type | String |
The allowed values are balanced, short, less_maneuvers. | |
| Mode | String |
The allowed values are drive, light_truck, medium_truck, truck, heavy_truck. | |
| UpdatedAt | Datetime | ||
| CompletedJobs | String | ||
| CompletionTime | String | ||
| CreatedBy | String | ||
| CustomStartLocation | String | ||
| Date | Date | ||
| DepotLocation | String | ||
| EndDepotLocation | String | ||
| Error | String | ||
| IsAvoidToll | Boolean | ||
| IsManualServiceTime | Boolean | ||
| JobIds | String | ||
| MaxSpeed | Double | ||
| Message | String | ||
| PlannedJobs | String | ||
| ServiceTime | Integer | ||
| StartTime | String | ||
| TimeWindowFrom | String | ||
| TimeWindowTo | String | ||
| TotalDistance | Integer | ||
| TotalPlannedJobs | Integer | ||
| TotalTime | Double | ||
| TotalUnplannedJobs | Integer | ||
| IsTraffic | Boolean | ||
| UnplannedJobs | String | ||
| UpdatedBy | String | ||
| Vehicle | String | ||
| VrpId | String |