Database Table: ORDIADJUST

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.
Indexes:
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
Constraints:
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

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