ORDIADJUST

Each row in this table represents an OrderItemAdjustment.

Column Descriptions:

NameTypeDescription
ORDIADJUST_IDBIGINT NOT NULLGenerated unique key.
ORDADJUST_IDBIGINT NOT NULLThe OrderAdjustment of which this OrderItemAdjustment is a part.
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem to which this OrderItemAdjustment applies.
AMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0The amount of the adjustment, in the currency of the OrderItem. A negative amount represents a discount. A positive amount represents a surcharge.
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>ORDIADJUST_IDPrimary Key
I0000177ORDADJUST_ID+ORDERITEMS_IDUnique Index
I0000178ORDERITEMS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_520ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_521ORDADJUST_IDORDADJUSTORDADJUST_IDCascade