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