Order (v10)
A customer order with delivery and status information
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | unique order id |
| 1 | ddate | date | delivery date |
| 2 | stateid | int | order state (-2=changed+cancelled, 0=new/pending, >0=assigned state) |
| 3 | tourid | int | assigned tour id |
| 4 | cnote | string | customer note |
| 5 | rnote | string | internal response note |
| 6 | orderOSH | datetime | last order change time (from delivery date) |
| 7 | last_changed | datetime | last modification timestamp |
| 8 | usedPaypal | int | 1 if order was paid via PayPal |
| 9 | dcost | double | delivery cost (-1 if not set) |
| 10 | hasAlcohol | int | 1 if order contains alcohol. For warning display in carts or as driver information |
| 11 | adrid | int | delivery address id from the customer |
| 12 | cid | int | customer id |
| 13 | shipcode | string | shipping/tracking code if any. May have been provided by the shipping interface of a fulfillment provider |