| **NAME**
| **TYPE**
| **DESCRIPTION**
|
| Timestamp
| Datetime
| Webhook timestamp
|
| Webhook
| Varchar(12)
| Type of webhook: STATUS or GEOLOC
|
| MissionNumber
| Int
| Number of the delivery, this number is the key to interact with our courier or the customer service.
|
| Ref1
| Varchar(50)
| Customer internal id for the mission, posted during the order api call
|
| PickupStart
| Datetime
| start of pickup window
|
| PickupEnd
| Datetime
| end of pickup window
|
| PickupStartEstimate
| Datetime
| start of the refined window of the date of removal
|
| PickupEndEstimate
| Datetime
| end of the refined window of the date of removal
|
| PickupDate
| Datetime
| Effective date of removal
|
| DeliveryStart
| Datetime
| start of delivery window
|
| DeliveryEnd
| Datetime
| end of delivery window
|
| DeliveryStartEstimate
| Datetime
| start of the refined window of the date of shipping
|
| DeliveryEndEstimate
| Datetime
| end of the refined window of the date of removal
|
| DeliveryDate
| Datetime
| Effective date of shipping
|
| State
| Varchar(50)
| Status of the mission :
- Not assigned
- Assigned
- Arrived at pick up location
- Picked up
- Arrived at delivery location
- Delivered
- Cancelled
- Delivery failed
- On hold
- To be invoiced
|
| Description
| Varchar(1024)
| Detail of the event (delivery failed reason....)
|
| WorkerShortCode
| Varchar(5)
| Autentication code of the driver
|
| WorkerSurname
| Varchar(100)
| Surname of driver
|
| Picture
| Varchar(100)
| Url of the driver picture
|
| ProofOfDelivery
| Varchar(100)
| Url of the signature picture
|
| DeliverySignee
| Varchar(30)
| Name of the signer
|
| | |
| Price
| Decimal(6,2)
| Price (sent when the mission has been done)
|
| WorkerLatitude | Decimal(9,7)
| Current Latitude of the courrier
|
| WorkerLongitude
| Decimal(9,7)
| Current Longitude of the courrier
|