Each row in this table represents a TaxCodeScheme. A TaxCodeScheme is a set of TaxCodeClassifications of CalculationCodes of particular TaxTypes.
Column Name | Column Type | Column Description |
---|---|---|
DESCRIPTION | VARCHAR (254) NULL |
A brief description of the TaxCodeScheme, suitable for display by a user interface that manages TaxCodeSchemes. |
SOFTWARE | VARCHAR (32) NULL |
A string that, along with VENDOR, uniquely identifies the TaxCodeScheme. |
TXCDSCHEME_ID | INTEGER NOT NULL |
Generated unique key. |
VENDOR | VARCHAR (32) NULL |
A string that, along with SOFTWARE, uniquely identifies this TaxCodeScheme. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000259 | VENDOR, SOFTWARE | Unique Index |
SQL030416035139920 | TXCDSCHEME_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_824 | TXCDSCHEME_ID | TAXTYPE | TXCDSCHEME_ID | Cascade |
F_886 | TXCDSCHEME_ID | TXCDCLASS | TXCDSCHEME_ID | Cascade |