Delivery (v15)
One delivery (stop) of a delivery ride: which customer/address is served in which sequence, incl. packing box info and arrival prediction.
Change Note: adds distance: street meters from the stop before, as the tour optimisation planned them
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | internal dtour record id |
| 1 | cid | int | customer to deliver to |
| 2 | dadr | int | delivery address redirect reference; references an address record, -1 is a public depot itself |
| 3 | aname | string | address name replica (empty if unset) |
| 4 | orderidshop | int | shop-side order id delivered at this stop |
| 5 | todohint | string | hint to the driver when arrived |
| 6 | wayhint | string | hint for the driver to find the way |
| 7 | done | string | time of delivery if already delivered (falls back to the dtour_done record), empty otherwise |
| 8 | box_names | string | names of the packing boxes for this delivery (e.g. A123) |
| 9 | packstellen_id | int | packing station the boxes were handled at (-1 if unknown) |
| 10 | aid | int | address of the customer (-1 if unknown) |
| 11 | prediction | double | predicted arrival in minutes |
| 12 | box_count | int | number of packing boxes for this delivery |
| 13 | box_type | int | packing box type reference |
| 14 | box_last_used | datetime | when the packing box was last used |
| 15 | weight | double | calculated weight of this delivery (goods, boxes and packaging, refund) |
| 16 | wquality | int | quality indicator of the weight calculation (100% = best) |
| 17 | inx | int | sequence number within the delivery ride (sometimes used as label) |
| 18 | distance | int | street meters from the stop before (from the start for the first one), as the tour optimisation last planned this leg; 0 if unknown |