ORDCALCD

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:

NameTypeDescription
ORDCALCD_IDBIGINT NOT NULLGenerated unique key.
ORDERS_IDBIGINT NOT NULLThe Order.
CALCODE_IDINTEGER NOT NULLThe CalculationCode.
CALFLAGSINTEGER NOT NULL DEFAULT 0Contains 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.)
CALPARMTYPEINTEGER NOT NULL DEFAULT 0Indicates how CALPARMAMT is used: 0 = not used. 1 = fixed adjustment. 2 = percentage adjustment. 3 = fixed replacement.
CALPARMAMTDECIMAL (20,5) NOT NULL DEFAULT 0The 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDCALCD_IDPrimary Key
I0000637CALCODE_IDNon-Unique Index
I0000638ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_494ORDERS_IDORDERSORDERS_IDCascade
F_495CALCODE_IDCALCODECALCODE_IDCascade