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 docid\ ufix35lrtf5e4t erzomr 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 docid\ puqmzwy lt3yr5ougfneo 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 docid 7dbvctoqsvqfzhsuczp m deliveryscenarioid int the selected delivery scenario for the order references tm deliveryscenario docid 9q6uc00pw dlu mznibxv 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 docid\ yvf7oq iruf6npuohg2xq 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