Share via


mktg_lm_master Table

The mktg_lm_master table in the marketing lists database contains information about the direct mail lists in the Marketing System.

The following table describes the columns in the mktg_lm_master table.

Column name

Type

Allow null

Description

guid_list_id

uniqueidentifier

no

A GUID that uniquely identifies this direct mail list.

This is the primary key.

u_list_name

nvarchar(100)

no

The name of this direct mail list.

u_list_description

nvarchar(200)

yes

A description of this direct mail list.

i_list_flags

int

no

A bit field that contains information about the purpose and use of the direct mail list.

i_expr_id

int

yes

The ID of the expression associated with this list, if any.

i_list_size

int

no

The number of entries in this list.

guid_op_id

uniqueidentifier

yes

A GUID that uniquely identifies the last operation on this direct mail list.

This is a foreign key into the mktg_lm_master_operations table.

dt_list_created

datetime

no

The date and time at which this direct mail list was created.

dt_list_modified

datetime

no

The date and time at which this direct mail list was last modified.

i_list_status

int

no

The status of this direct mail list, such as available, read-locked, write-locked, and so on.

i_list_type

int

no

The type of this direct mail list.

See Also

Other Resources

Marketing Lists Database Tables

Marketing Database Tables

mktg_lm_master_operations Table