TAX_RATE
Definition
The TAX_RATE table stores all the tax rates
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
CATALOG_DATA |
| Partitioned |
No |
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 |
VARCHAR2(256 CHAR), NOT NULL |
LABEL
| Definition |
The label of the tax |
| Type |
VARCHAR2(256 CHAR), 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 |
DATE, NOT NULL |
