Database Table: TAXCGRY

Each row in this table represents a TaxCategory.

Column Name Column Type Column Description
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)
NULL
Customizable.
FIELD2 DECIMAL (20,5)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
NAME CHARACTER (15)
NULL
A name that, along with the StoreEntity, uniquely identifies this TaxCategory.
STOREENT_ID INTEGER
NOT NULL
The StoreEntity of which this TaxCategory is a part.
TAXCGRY_ID INTEGER
NOT NULL
Generated primary key.
TAXTYPE_ID INTEGER
NOT NULL
The TaxType of this Taxcategory.
Indexes:
Index Name Indexed Column Names Index Type
I0000244 NAME, STOREENT_ID Unique Index
SQL030416035124290 TAXCGRY_ID Primary Key
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