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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000258 | STOREENT_ID, NAME | Unique Index |
SQL030416035139570 | TXCDCLASS_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_153 | TXCDCLASS_ID | CALCODE | TXCDCLASS_ID | Cascade |