TXCDCLASS

Each row in this table represents a TaxClassification. A TaxClassification is a group of Tax CalculationCodes.

Column Descriptions:

NameTypeDescription
TXCDCLASS_IDINTEGER NOT NULLGenerated unique key.
NAMEVARCHAR (64)A name that, along with the StoreEntity, uniquely identifies this TaxClassification.
TXCDSCHEME_IDINTEGERThe TaxCodeScheme, if any, this TaxClassification is part of.
DESCRIPTIONVARCHAR (254)A brief description of the TaxClassification, suitable for display in a user interface that manages TaxClassifications.
STOREENT_IDINTEGER NOT NULLThe StoreEntity this TaxClassification is part of.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>TXCDCLASS_IDPrimary Key
I0000258STOREENT_ID+NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_885STOREENT_IDSTOREENTSTOREENT_IDCascade
F_886TXCDSCHEME_IDTXCDSCHEMETXCDSCHEME_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_153TXCDCLASS_IDCALCODETXCDCLASS_IDCascade