Each row of this table indicates to the CalculationCodeCombineMethod that a CalculationCode is directly attached to all OrderItems in an Order. The order directCalculationCodeAttachment flag in ORDERITEMS.PREPAREFLAGS is 1.
Column Descriptions
| 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. It can be applied to adjust or replace the results of the CalculationScales associated with the attached CalculationCode.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|