Table:
TAX_RATE
|
Table Name
|
TAX_RATE |
| Table Description |
The TAX_RATE table stores all the tax rates. |
| Tablespace |
CATALOG_DATA |
| Database |
Core Database |
|
Columns
|
|
Columns of the Table
The TAX_RATE database table is defined by the following columns.
Column: CODE
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
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.
|
Column: LABEL
| Value Type |
VARCHAR(256) |
|
| Column Description |
The label of the tax. |
Column: RATE
| Value Type |
DECIMAL(28,6), NOT NULL |
|
| Column Description |
The rate of the tax. |
Column: TYPE
| Value Type |
DECIMAL(1) |
|
| Column Description |
The type of the tax.
Possible values are:
- 0: normal rate
- 1: intermediary rate
- 2: reducted rate
- 3: super-reducted rate
- 4: zero
- 5: special rate
|
Column: EFFECTIVE_DATE
| Value Type |
DATE, NOT NULL |
|
| Column Description |
The effective date of the tax. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.