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 Descriptions:

NameTypeDescription
CALCODE_IDINTEGER NOT NULLThe CalculationCode.
ORDICALCD_IDBIGINT NOT NULLGenerated unique key.
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem.
CALFLAGSINTEGER NOT NULL DEFAULT 0Contains 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.)
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>ORDICALCD_IDPrimary Key
I0000656ORDERITEMS_IDNon-Unique Index
I0000657CALCODE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_522CALCODE_IDCALCODECALCODE_IDCascade
F_523ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade