Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDADJUST
Each row of this table represents an OrderAdjustment.
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 SQL100520030359880 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
Referenced By 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
- Calculation usage data model
- Suborders data model
- Order adjustment data model
- Order management adjustment and tax data model
_vcc_freeselect_bottom_