WebSphere Commerce database table: SUBORDTAX

Each row of this table specifies the tax amount of a particular TaxCategory for all the OrderItems with the same shipping address as the SubOrder.


Column Description(s):
Column NameColumn TypeDescription
SUBORDER_ID BIGINT NOT NULL The SubOrder.
TAXCGRY_ID INTEGER NOT NULL The TaxCategory.
TAXAMOUNT DECIMAL (20,5) NOT NULL The tax amount in the Currency of the SubOrder (see SUBORDERS.CURRENCY for details).
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031317250 SUBORDER_ID+TAXCGRY_ID Primary Key
I0000802 TAXCGRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_814 SUBORDER_ID SUBORDERS SUBORDER_ID Cascade
F_815 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade

Feedback