This table stores e-mail message templates. Each row corresponds to an e-mail message template which can be used within an e-mail activity.
Column Descriptions
| Column Name
| Column Type
| Description
|
| EMLMSG_ID
| INTEGER NOT NULL
| The primary key.
|
| JSPPATH
| VARCHAR(254)
| The absolute URL used to find e-mail message content.
|
| PROPERTYFILE
| VARCHAR(254) NOT NULL
| Reserved for IBM internal use.
|
| NAME
| VARCHAR(254) NOT NULL
| The name of the e-mail activity template.
|
| DESCRIPTION
| VARCHAR(254)
| A description of the e-mail activity template.
|
| STOREENT_ID
| INTEGER NOT NULL
| The store to which the e-mail activity template is registered.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| STATUS
| SMALLINT NOT NULL DEFAULT 1
| Represents the current state of the e-mail template. Possible values include:
0 - Deleted
1 - Active
|
| EMLBODYTYPE
| SMALLINT NOT NULL DEFAULT 0
| The type of the e-mail body. Possible values include:
0-HTML
1-Plain text
|