tm.saleslogitem

A saleslogitem links an amount paid for an order to an individual item that was sold. Each saleslogitem belongs to a single saleslog

Fields

FieldDescription
id
int
ID
saleslogid
int
Link to the sales transaction

References: tm.saleslog

typeid
int
Type of the saleslog item. Possible values are: Ticket (1), Ticket fee (2), Order fee (5), Temp (0)
amount
int
Number of items
price
decimal
Unit price
totalvalue
decimal
Total value for this item
ticketid
int
Link to the ticket (if type = 1)

References: tm.ticket

tickettypepriceid
int
Link to the applied tickettypeprice (if type = 1)

References: tm.tickettypeprice

saleschannelid
int
Link to the saleschannel

References: tm.saleschannel

orderfeeid
int
Link to the order fee (if type = 5)

References: tm.orderfee

orderproductid
int
Link to the orderproduct (if type = 6)
productid
int
Link to the product (if type = 6)