TAXCGRY

Each row in this table represents a TaxCategory.

Column Descriptions:

NameTypeDescription
TAXCGRY_IDINTEGER NOT NULLGenerated primary key.
TAXTYPE_IDINTEGER NOT NULLThe TaxType of this Taxcategory.
STOREENT_IDINTEGER NOT NULLThe StoreEntity of which this TaxCategory is a part.
NAMECHAR (15)A name that, along with the StoreEntity, uniquely identifies this TaxCategory.
CALCULATIONSEQDOUBLE NOT NULL DEFAULT 0Tax amounts are calculated in ascending order of CALCULATIONSEQ.
DISPLAYSEQDOUBLE NOT NULL DEFAULT 0A user interface can use this field to control the sequence of tax amounts displayed for an Order.
DISPLAYUSAGEINTEGER NOT NULL DEFAULT 0Specifies 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.
FIELD1DECIMAL (20,5)Customizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TAXCGRY_IDPrimary Key
I0000244NAME+STOREENT_IDUnique Index
I0000803STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_816STOREENT_IDSTOREENTSTOREENT_IDCascade
F_817TAXTYPE_IDTAXTYPETAXTYPE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_162TAXCGRY_IDCALCODTXEXTAXCGRY_IDCascade
F_170TAXCGRY_IDCALRULETAXCGRY_IDCascade
F_489TAXCGRY_IDORDADJTXEXTAXCGRY_IDCascade
F_529TAXCGRY_IDORDITAXTAXCGRY_IDCascade
F_552TAXCGRY_IDORDTAXTAXCGRY_IDCascade
F_717TAXCGRY_IDRMATAXTAXCGRY_IDCascade
F_815TAXCGRY_IDSUBORDTAXTAXCGRY_IDCascade
F_818TAXCGRY_IDTAXCGRYDSTAXCGRY_IDCascade