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:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	SUBORDER_ID+ORDADJUST_ID	Primary Key
I0000800	ORDADJUST_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_810	ORDADJUST_ID	ORDADJUST	ORDADJUST_ID	Cascade
F_811	SUBORDER_ID	SUBORDERS	SUBORDER_ID	Cascade

Related reference
Order adjustment data model
Suborders data model