PX_DYNATTR

This table contains the details about any dynamic attributes that belong to promotion entities, such as promotion groups, promotion policies, and others.

Column Descriptions:

NameTypeDescription
PX_DYNATTR_IDINTEGER NOT NULLThe dynamic attribute ID. This is a primary key.
TYPENAMEVARCHAR (220) NOT NULLThe class name of the entity for which this dynamic attribute is defined.
ATTRNAMEVARCHAR (32) NOT NULLThe name of the dynamic attribute.
IMPLCLSVARCHAR (254) NOT NULLThe name of the class that implements the dynamic attribute.
XMLPARAMCLOB (1000000)The XML definition of this dynamic attribute.
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_DYNATTR_IDPrimary Key
I0000385TYPENAME+ATTRNAMEUnique Index