Database Table: ORDADJUST

Each row of this table represents an OrderAdjustment.

Column Name Column Type Column Description
AMOUNT DECIMAL (20,5)
NULL, DEFAULT 0
The amount of the OrderAdjustment, in the currency of the order (ORDERS.CURRENCY). This is the sum of its related OrderItemAdjustments.
CALCODE_ID INTEGER
NULL
The CalculationCode, if any, and if it still exists, that was used to create the OrderAdjustment.
CALUSAGE_ID INTEGER
NULL
The CalculationUsage, if any, and if it still exists, of the CalculationCode that was used to create the OrderAdjustment.
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.
ORDADJUST_ID BIGINT
NOT NULL
Generated unique key.
ORDERS_ID BIGINT
NOT NULL
The Order the OrderAdjustment is part of.
Indexes:
Index Name Indexed Column Names Index Type
I0000171 ORDERS_ID Non-Unique Index
SQL030416035015850 ORDADJUST_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_490 ORDERS_ID ORDERS ORDERS_ID Cascade
F_491 CALCODE_ID CALCODE CALCODE_ID Cascade
F_492 CALUSAGE_ID CALUSAGE CALUSAGE_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