WebSphere Commerce database table: TAXCGRY

Each row in this table represents a TaxCategory.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000244 NAME+STOREENT_ID Unique Index
SQL050212031317870 TAXCGRY_ID Primary Key
I0000803 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_816 STOREENT_ID STOREENT STOREENT_ID Cascade
F_817 TAXTYPE_ID TAXTYPE TAXTYPE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback