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

FieldDescription
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<langcode>
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

This table can also contain one or more customfields. Each customfield starts with c_