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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000171 | ORDERS_ID | Non-Unique Index |
SQL030416035015850 | ORDADJUST_ID | Primary Key |
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 |
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 |