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