Database Table: TXCDSCHEME

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000259 VENDOR, SOFTWARE Unique Index
SQL030416035139920 TXCDSCHEME_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
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