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