WebSphere Commerce database table: ORDIADJUST

WebSphere Commerce database table: ORDIADJUST

Each row in this table represents an OrderItemAdjustment.
Column Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000177 ORDADJUST_ID+ORDERITEMS_ID Unique Index
SQL060903235220480 ORDIADJUST_ID Primary Key
I0000178 ORDERITEMS_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_521 ORDADJUST_ID ORDADJUST ORDADJUST_ID Cascade
F_520 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
Related reference

Order adjustment data model

Column Name	Column 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	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
I0000177	ORDADJUST_ID+ORDERITEMS_ID	Unique Index
SQL060903235220480	ORDIADJUST_ID	Primary Key
I0000178	ORDERITEMS_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_521	ORDADJUST_ID	ORDADJUST	ORDADJUST_ID	Cascade
F_520	ORDERITEMS_ID	ORDERITEMS	ORDERITEMS_ID	Cascade