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:

NameTypeDescription
SUBORDER_IDBIGINT NOT NULLThe SubOrder, representing all OrderItems with a particular shipping address.
ORDADJUST_IDBIGINT NOT NULLThe OrderAdjustment.
TOTALADJUSTMENTDECIMAL (20,5) DEFAULT 0The total of the OrderItemAdjustment amounts in the OrderAdjustment for all the OrderItems in the SubOrder.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SUBORDER_ID+ORDADJUST_IDPrimary Key
I0000800ORDADJUST_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_810ORDADJUST_IDORDADJUSTORDADJUST_IDCascade
F_811SUBORDER_IDSUBORDERSSUBORDER_IDCascade