ID | ID is unique for all orders ever uploaded for an organization. | Required, unique (String) | 60 | 123abc456 | |
First name | | Optional, depending on order type - first name of parcels' recipient (delivery)/sender (pickup) | 70 | John | |
Last name | | Required, depending on order type - last name of parcels' recipient (delivery)/sender (pickup) | 70 | Doe | |
Business name | The business sending or receiving the delivery or pickup. | Optional | 80 | My Business Name | |
c/o | ‘Care of’ contact name if relevant | Optional | 40 | Care of Name | |
Address line 1 | | Required | 250 | 10115 Berlin Invalidenstr. 116 | Format is zip state city (district) subDistrict block subBlock houseNumber. From the large to smaller separated by a space. |
Address line 2 | | Optional | 150 | | |
Latitude | | Optional | 90.0 to -90.0 | 52.12 | Automatically geocodes the address during upload if latitude is not specified |
Longitude | | Optional | 180.0 to -180.0 | 12.32 | Automatically geocodes the address during upload if longitude is not specified |
City | | Required | 40 | Berlin | |
Postcode | | Required | 40 | 10115 | |
Country code | 2 or 3 letter country code, following https://en.wikipedia.org/wiki/ISO_3166-1 (alpha-2 and alpha-3) | Required | 3 | DE | |
Phone | The end customer’s phone number | Optional | 40 | +01234567890 | |
Email | The end customer’s email address | Optional | 150 | john.doe@here.com | |
Customer notes | Description of the end customer and visible on the dashboard only, for example 'premium customer'. It is an internal record for HERE Last Mile customer operations. | Optional | 120 | Some Notes | |
Order notes | Description of the specific order task and intended to be visible on the dashboard and for the driver, for example 'fresh food' | Optional | 1000 | Some notes | |
Start time | The earliest time a pickup or delivery should happen. | Required. Format MM.DD.YY HH:mm | Validation of time format | 03.19.21 08:00 | Up to two time windows per task can be added in the Dashboard manually, in the CSV can be added as an addition raw with same data (id, address..) but different time windows. |
End time | The latest time a pickup or delivery should happen. | Required. Format MM.DD.YY HH:mm | Validation of time format | 03.19.21 18:00 | Up to two time windows per task can be added in the dashboard manually, in the CSV can be added as an addition raw with same data (id, address..) but different time windows. |
Service time (m or mm:ss) | The time for servicing the pickup or delivery, for example 3:30 for 3 ½ minutes | Required. Service time in minutes or mm:ss seconds format in range 0 min 0 sec to 99 min 59 sec. | 99:59 | 3:30 | 3 min 30 sec |
Job type | Part of an order | Required. Possible values are delivery, pickup | pickup or delivery | delivery | Also known as 'Task type'. For one order comprising a pickup & delivery, enter as separate lines on the CSV with the same ID. |
Demand | The physical size of the thing to be picked up or delivered. Unit is used/defined per organization per their business since only a number is entered. Should be positive value | Optional (integer only). If not added, Last Mile adds '1' by default. | | 10 | Use: determines if the order can fit in a particular vehicle. Examples 1. Capacity of vehicle is 1000kg; demand for an order 10kg OR 2. Capacity of a vehicle is 15 cubic metres; demand for an order is 1 cubic metre |
Depot | The name of the Depot executing the order. | Optional | | Berlin Depo | Use Depot name that exists in the org, otherwise an error occurs. |
Skills | Driver skills | Optional | | Not currently in use. |
Tag | Custom user Tag field, allows tagging and filtering the orders based on the customer tags. Enables batch planning of the orders based on areas. | Optional | 40 per tag, 10 tags | AML10, AML40, etc | Not case sensitive. |