CLCDPROMO

This table stores information about the relationship between the Calculation Framework and the promotion standalone infrastructure. Each calculation code matches one promotion in the PX_PROMOTION table.

Column Descriptions:

NameTypeDescription
PX_PROMOTION_IDINTEGER NOT NULLForeign key to the PX_PROMOTION table. This is the promotion specific object.
CALCODE_IDINTEGER NOT NULLForeign key to reference the CALCODE table. This identifies the associated calculation framework object.
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>PX_PROMOTION_ID+CALCODE_IDPrimary Key
I0000410PX_PROMOTION_IDNon-Unique Index
I0000411CALCODE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1058PX_PROMOTION_IDPX_PROMOTIONPX_PROMOTION_IDCascade
F_1059CALCODE_IDCALCODECALCODE_IDCascade