tm.order
Fields
| Field | Description |
|---|---|
id int | ID |
createdts timestamp | Created timestamp |
lastupdatets timestamp | Last update timestamp |
contactid int | DEPRECATED, use customerid References: tm.contact |
customerid int | A link to the contact that is the customer for this order. |
status int | The status of the order: unconfirmed (21001), confirmed (21002) or archived (21003) |
saleschannelid int | The saleschannel this order was placed in References: tm.saleschannel |
amountpaid decimal | The total amount that was paid for this order |
totalamount decimal | The total amount for the order |
code int | Generated code that is random and unique for each order. An id can be enumerated, this code not. |
paymentscenarioid int | The selected payment scenario for the order References: tm.paymentscenario |
deliveryscenarioid int | The selected delivery scenario for the order References: tm.deliveryscenario |
paymentstatus int | Payment status for the order. Possible values ‘Fully paid’ (1), ‘Not fully paid’ (0), ‘Overpaid’ (2) |
deliverystatus int | Delivery status for the order. Links to systemtype category 26xx. Possible values Not delivered (2601) or Delivered (2602) References: tm.systemtype |
delivery_addressee string | If order is delivered by mail (post) this contains the delivery address. |
delivery_street1 string | If order is delivered by mail (post) this contains the delivery address. |
delivery_street2 string | If order is delivered by mail (post) this contains the delivery address. |
delivery_street3 string | If order is delivered by mail (post) this contains the delivery address. |
delivery_street4 string | If order is delivered by mail (post) this contains the delivery address. |
delivery_city string | If order is delivered by mail (post) this contains the delivery address. |
delivery_zip string | If order is delivered by mail (post) this contains the delivery address. |
delivery_countrycode string | If order is delivered by mail (post) this contains the delivery address. |
rappelts timestamp | Timestamp at which order will be overdue |
expiryts timestamp | Timestamp at which order will be expired |
deferredpaymentproperties text | Information about the deferred payment |
nbroftickets int | Number of tickets in the order |
tmuserid int | TM user who created this order |
referral string | Referral |
This table can also contain one or more customfields. Each customfield starts with c_