Using POSper/Developer guide/Database-Table descriptions/posper ticketline

posper_ticketline This table shows the information for a single line of a ticket. Column Name Data Type Null Allowed? Key? Comments id VARCHAR(255) No Primary UUID instead of int version INT(11) No This is used by hibernate to track table versions description VARCHAR(255) No This is used to describe the reason for applying a discount, if a discount is applied. amount DOUBLE No The number of units of the product being sold on this line priceSell DOUBLE No This is the price each unit is being sold at (discounts and stuff can come in to play to change it from the normal pricing). taxRate DOUBLE No This field allows for overriding the tax rate tax_id VARCHAR(255) No Foreign Key This points to the associated tax. product_id VARCHAR(255) Yes Foreign Key The product associated with this line item. Can be null if this is just a misc added surcharge. ticket_ticketline VARCHAR(255) Yes Foreign Key This is the ticket that this "ticket line" is part of line_index INT(11) Yes The position on the ticket.