PX_PROMOPOLICY

This is table is intended for customization, which contains the relationship between a promotion policy with a promotion. This table is not used with default implementation.

Column Descriptions:

NameTypeDescription
PX_PROMOTION_IDINTEGER NOT NULLForeign key to PX_PROMOTION table.
PX_POLICY_IDINTEGER NOT NULLForeign key to PX_PPOLICY table.
RELATIONSMALLINT NOT NULL DEFAULT 0The type of relationships between promotions and policies. Possible values include: 0: applicable 1: exempted The default value is 0.
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
I0000402PX_PROMOTION_IDNon-Unique Index
I0000403PX_POLICY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1049PX_PROMOTION_IDPX_PROMOTIONPX_PROMOTION_IDCascade
F_1050PX_POLICY_IDPX_POLICYPX_POLICY_IDCascade