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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031316950 SUBORDER_ID+ORDADJUST_ID Primary Key
I0000800 ORDADJUST_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_810 ORDADJUST_ID ORDADJUST ORDADJUST_ID Cascade
F_811 SUBORDER_ID SUBORDERS SUBORDER_ID Cascade

Feedback