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_{listid}_list tables in the marketing lists database contain mailing lists. The names of these tables are of the form mktg_lm_{listid}_list, where "{listid}" is replaced by a GUID without any hyphens.
Note
One such list table is pre-defined and serves as the global opt-out mailing list. The "{listid}" section of the name of this table consists of a GUID using only the letter "F", creating the following table name: mktg_lm_FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF_list
The following table describes the columns in the mktg_lm_{listid}_list tables.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
u_rcp_email |
nvarchar(256) |
no |
The recipient e-mail address. This is the primary key. |
u_rcp_id |
nvarchar(64) |
yes |
An identifier for the recipient. |
i_rcp_fmt |
int |
yes |
The mail format for this recipient. |
u_rcp_language |
nvarchar(20) |
yes |
The language for direct mail sent to this recipient. |
u_rcp_charset |
nvarchar(20) |
yes |
The character set for direct mail sent to this recipient. |
u_rcp_url |
nvarchar(2048) |
yes |
The URL from which to load the page. |