ORDIADJUST

Each row in this table represents an OrderItemAdjustment.

Column Descriptions:

Name	Type	Description
ORDIADJUST_ID	BIGINT NOT NULL	Generated unique key.
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.
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.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ORDIADJUST_ID	Primary Key
I0000177	ORDADJUST_ID+ORDERITEMS_ID	Unique Index
I0000178	ORDERITEMS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_520	ORDERITEMS_ID	ORDERITEMS	ORDERITEMS_ID	Cascade
F_521	ORDADJUST_ID	ORDADJUST	ORDADJUST_ID	Cascade