Using POSper/Developer guide/Database-Table descriptions/posper ticketline
posper_ticketline
[edit | edit source]
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. |