Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDIADJUST
Each row in this table represents an OrderItemAdjustment.
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 SQL100520030402030 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
_vcc_freeselect_bottom_