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 Column Description
ORDADJUST_ID BIGINT
NOT NULL
The OrderAdjustment.
SUBORDER_ID BIGINT
NOT NULL
The SubOrder, representing all OrderItems with a particular shipping address.
TOTALADJUSTMENT DECIMAL (20,5)
NULL, DEFAULT 0
The total of the OrderItemAdjustment amounts in the OrderAdjustment for all the OrderItems in the SubOrder.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035122110 SUBORDER_ID, ORDADJUST_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable