WebSphere Commerce database table: TAXCGRY

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.

Indexes
Index Name Indexed Column Names Index Type
I0000244 NAME+STOREENT_ID Unique Index
SQL060903235258020 TAXCGRY_ID Primary Key
I0000803 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_816 STOREENT_ID STOREENT STOREENT_ID Cascade
F_817 TAXTYPE_ID TAXTYPE TAXTYPE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_162 TAXCGRY_ID CALCODTXEX TAXCGRY_ID Cascade
F_170 TAXCGRY_ID CALRULE TAXCGRY_ID Cascade
F_489 TAXCGRY_ID ORDADJTXEX TAXCGRY_ID Cascade
F_529 TAXCGRY_ID ORDITAX TAXCGRY_ID Cascade
F_552 TAXCGRY_ID ORDTAX TAXCGRY_ID Cascade
F_717 TAXCGRY_ID RMATAX TAXCGRY_ID Cascade
F_815 TAXCGRY_ID SUBORDTAX TAXCGRY_ID Cascade
F_818 TAXCGRY_ID TAXCGRYDS TAXCGRY_ID Cascade