Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: SUBORDADJ
Each row of this table represents a subtotal of all the OrderItemAdjustment amounts in an OrderAdjustment whose OrderItems have the same shipping address.
Column Name Column Type Description SUBORDER_ID BIGINT NOT NULL The SubOrder, representing all OrderItems with a particular shipping address. ORDADJUST_ID BIGINT NOT NULL The OrderAdjustment. TOTALADJUSTMENT DECIMAL (20,5) DEFAULT 0 The total of the OrderItemAdjustment amounts in the OrderAdjustment for all the OrderItems in the SubOrder. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030436080 SUBORDER_ID+ORDADJUST_ID Primary Key I0000800 ORDADJUST_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_810 ORDADJUST_ID ORDADJUST ORDADJUST_ID Cascade F_811 SUBORDER_ID SUBORDERS SUBORDER_ID Cascade
Related reference
_vcc_freeselect_bottom_