Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TAXCGRY
Each row in this table represents a TaxCategory.
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...
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 SQL100520030437170 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
Referenced By 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
Related reference
- Calculation rule - tax data model
- Calculation rule - discount data model
- Suborders data model
- Tax type and category data model
- Order tax data model
- Order data model
- Order adjustment data model
- Order management adjustment and tax data model
- Calculation rule data model
_vcc_freeselect_bottom_