Database Table: TXCDCLASS

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

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
A brief description of the TaxClassification, suitable for display in a user interface that manages TaxClassifications.
NAME VARCHAR (64)
NULL
A name that, along with the StoreEntity, uniquely identifies this TaxClassification.
STOREENT_ID INTEGER
NOT NULL
The StoreEntity this TaxClassification is part of.
TXCDCLASS_ID INTEGER
NOT NULL
Generated unique key.
TXCDSCHEME_ID INTEGER
NULL
The TaxCodeScheme, if any, this TaxClassification is part of.
Indexes:
Index Name Indexed Column Names Index Type
I0000258 STOREENT_ID, NAME Unique Index
SQL030416035139570 TXCDCLASS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_885 STOREENT_ID STOREENT STOREENT_ID Cascade
F_886 TXCDSCHEME_ID TXCDSCHEME TXCDSCHEME_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_153 TXCDCLASS_ID CALCODE TXCDCLASS_ID Cascade