| Schema Version | 5.0.6 | |
| Partitioned | No | |
The TAX_RATE table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| CODE |
|
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 | ||||
| LABEL |
|
The label of the tax | ||||
| RATE |
|
The rate of the tax | ||||
| TYPE |
|
The type of the tax | ||||
| EFFECTIVE_DATE |
|
The effective date of the tax |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| 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 |
| Definition | The label of the tax |
| Type | NVARCHAR(256), NULL |
| Definition | The rate of the tax |
| Type | DECIMAL(28,6), NOT NULL |
| Definition | The type of the tax |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
| Definition | The effective date of the tax |
| Type | DATETIME, NOT NULL |
