TAXCGRY

Each row in this table represents a TaxCategory.

Column Descriptions:

Name	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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	TAXCGRY_ID	Primary Key
I0000244	NAME+STOREENT_ID	Unique Index
I0000803	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_816	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_817	TAXTYPE_ID	TAXTYPE	TAXTYPE_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	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