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. |