tm.order
An order is a sales transaction and contains tickets bought by a contact.
Fields
FIELD | TYPE | 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), archived (21003) or draft (21004) |
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_