WebSphere Commerce database table: TXCDSCHEME

Each row in this table represents a TaxCodeScheme. A TaxCodeScheme is a set of TaxCodeClassifications of CalculationCodes of particular TaxTypes.

Column Descriptions
Column Name Column Type Description
TXCDSCHEME_ID INTEGER NOT NULL Generated unique key.
DESCRIPTION VARCHAR(254) A brief description of the TaxCodeScheme, suitable for display by a user interface that manages TaxCodeSchemes.
VENDOR VARCHAR(32) A string that, along with SOFTWARE, uniquely identifies this TaxCodeScheme.
SOFTWARE VARCHAR(32) A string that, along with VENDOR, uniquely identifies the TaxCodeScheme.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000259 VENDOR+SOFTWARE Unique Index
SQL060903235304770 TXCDSCHEME_ID Primary Key

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