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
FIELD | TYPE | DESCRIPTION |
|---|---|---|
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) |