Jump to content

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

From Wikibooks, open books for an open world

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