WebSphere Commerce database table: ORDADJUST

Each row of this table represents an OrderAdjustment.

Column Descriptions
Column Name Column Type Description
ORDADJUST_ID BIGINT NOT NULL Generated unique key.
ORDERS_ID BIGINT NOT NULL The Order the OrderAdjustment is part of.
CALCODE_ID INTEGER The CalculationCode, if any, and if it still exists, that was used to create the OrderAdjustment.
CALUSAGE_ID INTEGER The CalculationUsage, if any, and if it still exists, of the CalculationCode that was used to create the OrderAdjustment.
AMOUNT DECIMAL (20,5) DEFAULT 0 The amount of the OrderAdjustment, in the currency of the order (ORDERS.CURRENCY). This is the sum of its related OrderItemAdjustments.
DISPLAYLEVEL INTEGER NOT NULL DEFAULT 0 The values for this OrderAdjustment should be displayed with each:
0 = OrderItem
1 = Order
2 = product
3 = item
4 = contract
This value is usually copied from CALCODE.DISPLAYLEVEL.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235218430 ORDADJUST_ID Primary Key
I0000171 ORDERS_ID Non-Unique Index
I0000634 CALUSAGE_ID Non-Unique Index
I0000635 CALCODE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_491 CALCODE_ID CALCODE CALCODE_ID Cascade
F_492 CALUSAGE_ID CALUSAGE CALUSAGE_ID Cascade
F_490 ORDERS_ID ORDERS ORDERS_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_486 ORDADJUST_ID ORDADJDSC ORDADJUST_ID Cascade
F_488 ORDADJUST_ID ORDADJTXEX ORDADJUST_ID Cascade
F_521 ORDADJUST_ID ORDIADJUST ORDADJUST_ID Cascade
F_704 ORDADJUST_ID RMAIADJCRD ORDADJUST_ID Cascade
F_810 ORDADJUST_ID SUBORDADJ ORDADJUST_ID Cascade
Related reference