PX_GRPPOLICY

This table contains relationships between promotion groups and promotion policies.

Column Descriptions:

NameTypeDescription
PX_GROUP_IDINTEGER NOT NULLForeign key to PX_GROUP table.
PX_POLICY_IDINTEGER NOT NULLForeign key to PX_POLICY table.
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_GROUP_ID+PX_POLICY_IDPrimary Key
I0000396PX_GROUP_IDNon-Unique Index
I0000397PX_POLICY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1044PX_GROUP_IDPX_GROUPPX_GROUP_IDCascade
F_1045PX_POLICY_IDPX_POLICYPX_POLICY_IDCascade