DMACTATTR

Attributes of a marketing activity.

Column Descriptions:

NameTypeDescription
DMACTIVITY_IDINTEGER NOT NULLThe unique identifier of the marketing activity.
STOREENT_IDINTEGER NOT NULL DEFAULT 0The identifier of the store.
PROCESSEDTIMESTAMPFor bulk e-mail activities, this is set to the time which the bulk e-mail was sent.
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>DMACTIVITY_ID+STOREENT_IDPrimary Key