Each row of this table indicates to the CalculationCodeCombineMethod that a CalculationCode is directly attached to all OrderItems in an Order whose directCalculationCodeAttachment flag in ORDERITEMS.PREPAREFLAGS is 1.
Column Name | Column Type | Description |
---|---|---|
ORDCALCD_ID | BIGINT NOT NULL | Generated unique key. |
ORDERS_ID | BIGINT NOT NULL | The Order. |
CALCODE_ID | INTEGER NOT NULL | The CalculationCode. |
CALFLAGS | INTEGER NOT NULL DEFAULT 0 | Contains the following bit flag value: 1 = overrideIndirectAttachments - CalculationCodes indirectly attached to the OrderItem are not effective. (CalculationCodes can be indirectly attached in the CATENCALCD and CATGPCALCD tables.) |
CALPARMTYPE | INTEGER NOT NULL DEFAULT 0 | Indicates how CALPARMAMT is used: 0 = not used. 1 = fixed adjustment. 2 = percentage adjustment. 3 = fixed replacement. |
CALPARMAMT | DECIMAL (20,5) NOT NULL DEFAULT 0 | The amount of a fixed or percentage adjustment that can be applied to adjust or replace the results of the CalculationScales associated with the attached CalculationCode. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031243570 | ORDCALCD_ID | Primary Key |
I0000637 | CALCODE_ID | Non-Unique Index |
I0000638 | ORDERS_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_495 | CALCODE_ID | CALCODE | CALCODE_ID | Cascade |
F_494 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |