PX_PROMOAUDIT

This table contains obsolete promotion information for auditing purpose.

Column Descriptions:

NameTypeDescription
PX_PROMOTION_IDINTEGER NOT NULLForeign key to PX_PROMOTION table
VERSIONINTEGER NOT NULLThe version of this promotion.
REVISIONINTEGER NOT NULLThe revision of this promotion
XMLPARAMCLOB (3000000) NOT NULLThe promotion rule xml
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+VERSION+REVISIONPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3545PX_PROMOTION_IDPX_PROMOTIONPX_PROMOTION_IDCascade