Each row in this table represents a TaxCategory.
Column Descriptions
Column Name
| Column Type
| Description |
TAXCGRY_ID
| INTEGER NOT NULL
| Generated primary key.
|
TAXTYPE_ID
| INTEGER NOT NULL
| The TaxType of this Taxcategory.
|
STOREENT_ID
| INTEGER NOT NULL
| The StoreEntity of which this TaxCategory is a part.
|
NAME
| CHAR(15)
| A name that, along with the StoreEntity, uniquely identifies this TaxCategory.
|
CALCULATIONSEQ
| DOUBLE NOT NULL DEFAULT 0
| Tax amounts are calculated in ascending order of CALCULATIONSEQ.
|
DISPLAYSEQ
| DOUBLE NOT NULL DEFAULT 0
| A user interface can use this field to control the sequence of tax amounts displayed for an Order.
|
DISPLAYUSAGE
| INTEGER NOT NULL DEFAULT 0
| Specifies that this tax category in relation to the PriceDataBean as follows:
0 = is not calculated,
1 = is calculated.
The PriceDataBean can be used to obtain tax amounts that should be shown along with the product price.
|
FIELD1
| DECIMAL (20,5)
| Customizable.
|
FIELD2
| DECIMAL (20,5)
| Customizable.
|
FIELD3
| VARCHAR(254)
| Customizable.
|
MARKFORDELETE
| INTEGER NOT NULL DEFAULT 0
| Reserved for IBM internal use.
|
OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|