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_