tm.ticket

ticket contains all tickets defined for contingents at contingent creation time the required number of tickets are created immediately a ticket is added to an order by updating the field orderid fields field type description id int id tickettypeid int link to the contingent this ticket belongs to references tm tickettype seatzoneid int optional seatzone for the ticket seatzonename string zone name for the ticket (only for seated tickets) seatrownumber string row number for the ticket (only for seated tickets) seatseatnumber string seat number for the ticket (only for seated tickets) seatdescription mlstring the seat description for this ticket (only for seated tickets) seatcoordinatex int deprecated no longer in use seatcoordinatey int deprecated no longer in use seatpriority int number indicating the priority for this ticket for the best available algorithm tickets with a higher priority will be considered first when performing a best available allocation currentstatus int current status for the ticket null = available, 101 = reserved/sold, 103 = delivered, 104 = locked orderid int link to the order the ticket is contained in references tm order orderprice decimal deprecated use price instead orderfee decimal fee for the ticket in the order ordertickettypepriceid int deprecated use tickettypepriceid instead references tm tickettypeprice orderticketholderid int deprecated use ticketholderid instead references tm contact price decimal price for the ticket in the order (without fee) ticketname string optional name on the ticket ticketholderid int optional link to the contact that is the ticketholder for this ticket ticketholdername string deprecated use ticketholderid tickettypepriceid int link to the tickettypeprice that is assigned to this ticket for the order through the tickettypeprice you can retrieve the pricetype bundleid int link to the bundle (orderproduct) that this ticket belongs to vouchercodeid int link to the vouchercode that was used to reserve this ticket references tm vouchercode barcode string 12 digit unique code that is used for generating a barcode for the ticket locktypeid int link to the locktype used for locking the ticket (currentstatus will be 104) references tm locktype previouslocktypeid int link to the previous locktype accesscontrolstatus int the access control status for this ticket 0 means not scanned, 1 means succesful entry, 2 means succesful exit accesscontrollastenteredts timestamp the timestamp of the last succesful entry with this ticket accesscontrollastexitts timestamp the timestamp of the last succesful exit with this ticket accesscontrollastenteredscandeviceid int the id of the scanner used for the last succesful entry accesscontrollastexitscandeviceid int the id of the scanner used for the last succesful exit deliveredts timestamp the tmestamp of the last delivery of this ticket properties json string to string key value mapping of properties transferredto int link to the contact the ticket was transferred to ticket this table can also contain one or more customfields each customfield starts with c