tm.saleslogitem

a saleslogitem links an amount paid for an order to an individual item that was sold each saleslogitem belongs to a single tm saleslog docid\ lqr90y r48izmxxvaugm fields field type description id int id saleslogid int link to the sales transaction references tm saleslog docid\ lqr90y r48izmxxvaugm 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 docid\ ng g3imt5nlu1ch0cq7bg tickettypepriceid int link to the applied tickettypeprice (if type = 1) references tm tickettypeprice docid\ rsax5ugwv3f7ijegsonor saleschannelid int link to the saleschannel references tm saleschannel docid\ puqmzwy lt3yr5ougfneo orderfeeid int link to the order fee (if type = 5) references tm orderfee docid 8qxtshzzxdgvk1ag5jdzi orderproductid int link to the orderproduct (if type = 6) productid int link to the product (if type = 6)