| id |
string |
Unique identifier hash for each record |
| ClientName |
string |
Full name of the client/recipient |
| Address |
string |
Physical delivery address |
| OrderDate |
date |
Date when order was placed (YYYY-MM-DD) |
| DeliveryDate |
date |
Scheduled delivery date (YYYY-MM-DD) |
| From |
time |
Start of delivery time window (HH:MM) |
| To |
time |
End of delivery time window (HH:MM) |
| phone |
string |
Contact phone number |
| email |
string |
Contact email address |
| OrderID |
string |
Unique order identification code |
| ServiceType |
string |
Type of delivery service (e.g., "parcel") |
| TotalVolume |
integer |
Total volume of items |
| TotalWeight |
integer |
Total weight in grams |
| itemsQty |
integer |
Number of items in the order |
| MarketPlaceCode |
string |
Marketplace identifier ("ctt") |
| Lot |
string |
Lot number or batch identifier |
| lat |
float |
Latitude coordinate of delivery address |
| lon |
float |
Longitude coordinate of delivery address |
| googleAddress |
string |
Formatted address from Google Maps |
| PostCode |
string |
Postal code of delivery address |
| only_bike |
boolean |
Flag for bike-only deliveries (empty) |
| error |
boolean |
Error flag (=FALSE() in all records) |
| error_cause |
string |
Description of error (empty) |
| error_level |
integer |
Error severity level (0 in all records) |
| distanceToDepot |
float |
Distance to depot in meters |