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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035122110 | SUBORDER_ID, ORDADJUST_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|