TAX_RATE
Definition
The TAX_RATE table stores all the tax rates
Technical Data
Summary
The TAX_RATE table is defined by the
following columns.
See the column details for more information.
Column Details
CODE
| Definition |
The identifier of the tax. It identifies the zone of the tax and its type. Example:
US/CA/0 refers to the normal American tax applied in California
|
| Type |
NVARCHAR(256), NOT NULL |
LABEL
| Definition |
The label of the tax |
| Type |
NVARCHAR(256), NULL |
RATE
| Definition |
The rate of the tax |
| Type |
DECIMAL(28,6), NOT NULL |
TYPE
| Definition |
The type of the tax |
| Format |
The possible values are:
0: Normal rate
1: Intermediary rate
2: Reduced rate
3: Super-reduced rate
4: Zero
5: Special rate
|
| Type |
DECIMAL(1), NULL |
EFFECTIVE_DATE
| Definition |
The effective date of the tax |
| Type |
DATETIME, NOT NULL |
