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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031243300 | ORDADJUST_ID | Primary Key |
I0000171 | ORDERS_ID | Non-Unique Index |
I0000634 | CALUSAGE_ID | Non-Unique Index |
I0000635 | CALCODE_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 Name(s) | 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 |