| DMACTIVITY_ID | INTEGER NOT NULL | The unique identifier of a marketing
activity. |
| STOREENT_ID | INTEGER NOT NULL | The unique identifier of the store in which the
marketing activity was created. |
| NAME | VARCHAR (64) NOT NULL | The name of the marketing activity. |
| VERSION | INTEGER NOT NULL DEFAULT 1 | The current version number of the marketing
activity. If changes are made to the content of the marketing
activity, then the version number will be incremented. The default
value is 1. |
| PUBLISHED | INTEGER NOT NULL DEFAULT 0 | The published version number of the marketing
activity. This is the version running on the storefront. The
default value is 0. |
| STATE | SMALLINT NOT NULL DEFAULT 0 | The current state of the marketing activity.
Valid values include: 0 = inactive, 1 = active, 2 = archived. The
default value is 0. |
| STARTDATE | TIMESTAMP | The start time for the marketing activity. If the
start time is null, then the marketing activity can start
immediately. |
| ENDDATE | TIMESTAMP | The end time for the marketing activity. If the
end time is null, then the marketing activity will run
indefinitely. |
| PRIORITY | SMALLINT NOT NULL DEFAULT 0 | The priority of the marketing activity. The
default value is 0. |
| DMCAMPAIGN_ID | INTEGER | The campaign associated with the marketing
activity. |
| DMACTTYPE_ID | SMALLINT NOT NULL DEFAULT 0 | The type of the marketing activity. Possible
types are web, dialog, e-mail, search, and pageLayout. The default
value is 0 (web). |
| DMTEMPLATETYPE_ID | SMALLINT | The type of this marketing activity template. If
this value is not null, then this activity is a template marketing
activity used as a starting point for creating activities. |
| DMEXPTYPE_ID | SMALLINT | The type of this marketing activity experiment.
If this value is not null, then this activity is an
experiment. |
| REPEATABLE | SMALLINT NOT NULL DEFAULT 1 | This activity is repeatable by customers. |
| CREATED | TIMESTAMP | The time when the marketing activity was
created. |
| LASTUPDATE | TIMESTAMP | The time when the marketing activity was last
updated. |
| LASTUPDATEDBY | VARCHAR (254) | The information about the individual who last
updated the marketing activity. |
| DESCRIPTION | VARCHAR (254) | The description of the marketing activity. |
| FLOWXML | CLOB (1000000) | The XML defintion of the flow associated with the
marketing activity. This column is deprecated and is no longer
used. |
| FIELD1 | INTEGER | Customizable field. |
| FIELD2 | BIGINT | Customizable field. |
| FIELD3 | DECIMAL (20,5) | Customizable field. |
| FIELD4 | VARCHAR (254) | Customizable field. |
| UP_NAME | VARCHAR (64) | The equivalent value of the NAME column in upper
case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
| UP_DESCRIPTION | VARCHAR (254) | The equivalent value of the DESCRIPTION column in
upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
| BEHAVIOR | SMALLINT NOT NULL DEFAULT 1 | If this web activity displays the same results to
all customers, then set this value to 0. If this web activity has
dynamic behavior that can display different results, then set this
value to 1. The associated e-Marketing Spot can use this setting to
determine how to cache the e-Marketing Spot results. |
| UIDISPLAYABLE | SMALLINT | Indicates if this element should be displayed in
CMC. Null/1: means Yes. 0: means No. |
| MANAGINGTOOL | SMALLINT | Indicates what tools manages that element.
Null/0: means Marketing tool. 1: means Page Layout. |
| 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. |