mktg_lm_{jobmlistid}_list Table
The mktg_lm_{jobmlistid}_list table in the DirectMailer database contains information about the registered users to whom a direct mail e-mail message will be sent.
The following table describes the columns in the mktg_lm_{jobmlistid}_list table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
rcp_guid |
nvarchar(64) |
yes |
The unique identifier of the user's profile. |
rcp_email |
nvarchar(256) |
no |
The e-mail address of the user. This is a primary key. |
rcp_fmt |
int |
yes |
The format in which a message should be sent to this user. |
rcp_url |
nvarchar(2048) |
yes |
The URL of the page that contains the personalized message for this user. |
rcp_status |
int |
no |
Whether this message was sent successfully. |
rcp_process_date |
datetime |
yes |
The date on which the message was sent. |
rcp_charset |
nvarchar(20) |
yes |
The character set to use in a message to this user. |
rcp_language |
nvarchar(20) |
yes |
The language to use in a message to this user. |
rcp_sequence |
int |
no |
The sequence number of this message. For example, if the value is 2, this is the second user to whom this message is being sent. |