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 Related reference
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