Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
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. |