Using POSper/Developer guide/Database-Table descriptions/posper tax
posper_tax
edit
This table lists the taxes that can be applied to products. Combinative taxes are currently not supported so to bundle two or more taxes together you have to create a new entry with the rate being the sum of all the taxes.
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 | |
visibleId | INT(11) | Yes | Uni | This is the user visible (user-friendly) Id |
rate | DOUBLE | No | This is the percentage rate of the tax | |
tax_name | VARCHAR(255) | No | name of the tax |