Each row in this table represents an OrderItemAdjustment.
Column Name | Column Type | Column Description |
---|---|---|
AMOUNT | DECIMAL (20,5) NOT NULL, DEFAULT 0 |
The amount of the adjustment, in the currency of the OrderItem. A negative amount represents a discount. A positive amount represents a surcharge. |
ORDADJUST_ID | BIGINT NOT NULL |
The OrderAdjustment of which this OrderItemAdjustment is a part. |
ORDERITEMS_ID | BIGINT NOT NULL |
The OrderItem to which this OrderItemAdjustment applies. |
ORDIADJUST_ID | BIGINT NOT NULL |
Generated unique key. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000177 | ORDADJUST_ID, ORDERITEMS_ID | Unique Index |
I0000178 | ORDERITEMS_ID | Non-Unique Index |
SQL030416035018780 | ORDIADJUST_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_520 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_521 | ORDADJUST_ID | ORDADJUST | ORDADJUST_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|