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 Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235257420 SUBORDER_ID+TAXCGRY_ID Primary Key
I0000802 TAXCGRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_814 SUBORDER_ID SUBORDERS SUBORDER_ID Cascade
F_815 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade
Related reference