DMACTTYPE

Types of marketing activities. These include web, e-mail, dialog, search, and pageLayout.

Column Descriptions:

NameTypeDescription
DMACTTYPE_IDSMALLINT NOT NULLThe unique identifier of the type of a marketing activity. Valid values include: 0 = web, 1 = dialog, 2 = e-mail, 3 = search, 4 = layoutAssociation (deprecated), 5 = pageLayout (used by Commerce Composer)
TYPEVARCHAR (64) NOT NULLThe type of the marketing activity template.
DESCRIPTIONVARCHAR (254)The description of the type of marketing activity.
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>DMACTTYPE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3524DMACTTYPE_IDDMACTIVITYDMACTTYPE_IDCascade