Database Table: ORDICALCD

Each row of this table indicates to the CalculationCodeCombineMethod that a CalculationCode is directly attached to an OrderItem. The attachment is not effective unless the 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:
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.
ORDERITEMS_ID BIGINT
NOT NULL
The OrderItem.
ORDICALCD_ID BIGINT
NOT NULL
Generated unique key.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035019090 ORDICALCD_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_522 CALCODE_ID CALCODE CALCODE_ID Cascade
F_523 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable