mktg_lm_{listid}_list Table

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.

See Also

Other Resources

Marketing Lists Database Tables

Marketing Database Tables