Reference > Database > WebSphere Commerce database tables > S
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 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 SQL100520030436590 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
_vcc_freeselect_bottom_