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 | Column Description |
---|---|---|
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.) |
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. |
CALPARMTYPE | INTEGER NOT NULL, DEFAULT 0 |
Indicates how CALPARMAMT is used: 0 = not used. 1 = fixed adjustment. 2 = percentage adjustment. 3 = fixed replacement. |
ORDCALCD_ID | BIGINT NOT NULL |
Generated unique key. |
ORDERS_ID | BIGINT NOT NULL |
The Order. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035016530 | ORDCALCD_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_494 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
F_495 | CALCODE_ID | CALCODE | CALCODE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|