WebSphere Commerce database table: ORDIADJUST

Each row in this table represents an OrderItemAdjustment.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
I0000177 ORDADJUST_ID+ORDERITEMS_ID Unique Index
SQL050212031244590 ORDIADJUST_ID Primary Key
I0000178 ORDERITEMS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_521 ORDADJUST_ID ORDADJUST ORDADJUST_ID Cascade
F_520 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Feedback