Database Table: ORDCALCD

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035016530 ORDCALCD_ID Primary Key
Constraints:
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

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