Types of marketing activities. These include web,
e-mail, dialog, search, and pageLayout.
Column Descriptions:
| Name | Type | Description |
| DMACTTYPE_ID | SMALLINT NOT NULL | The 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) |
| TYPE | VARCHAR (64) NOT NULL | The type of the marketing activity template. |
| DESCRIPTION | VARCHAR (254) | The description of the type of marketing
activity. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | DMACTTYPE_ID | Primary Key |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3524 | DMACTTYPE_ID | DMACTIVITY | DMACTTYPE_ID | Cascade |