This table stores e-mail activities. Each row corresponds to an e-mail activity which is sent to a given customer profile.
Column Descriptions
| Column Name
| Column Type
| Description
|
| EMLPROMO_ID
| INTEGER NOT NULL
| The primary key.
|
| STATUS
| INTEGER NOT NULL DEFAULT 0
| Represents the current state of the e-mail activity. Possible values include:
0 - unsent
1 - sent
2 - deleted
|
| MODIFIEDBY
| VARCHAR(254)
| The logon ID of the person who last modified the e-mail activity.
|
| MODDATE
| TIMESTAMP
| The date on which the last modification was performed.
|
| DESCRIPTION
| VARCHAR(254)
| The description of the e-mail activity.
|
| NAME
| VARCHAR(254) NOT NULL
| The name given to the e-mail activity.
|
| EMLMSG_ID
| INTEGER NOT NULL
| The e-mail message template to send to the target customer segment.
|
| STOREENT_ID
| INTEGER NOT NULL
| The ID of the store with which the e-mail activity is associated.
|
| SCCJOBREFNUM
| BIGINT NOT NULL
| Foreign key to SCHCONFIG table.
|
| REPLYTO
| VARCHAR(256)
| The reply-to e-mail address for the e-mail activity.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|