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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000259 VENDOR+SOFTWARE Unique Index
SQL050212031324470 TXCDSCHEME_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_824 TXCDSCHEME_ID TAXTYPE TXCDSCHEME_ID Cascade
F_886 TXCDSCHEME_ID TXCDCLASS TXCDSCHEME_ID Cascade

Feedback