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 Descriptions
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
SQL060903235257090 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