mktg_lm_master_operations Table
The mktg_lm_master_operations table in the marketing lists database contains information about direct mail operations in the Marketing System.
The following table describes the columns in the mktg_lm_master_operations table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
guid_op_id |
uniqueidentifier |
no |
A GUID that uniquely identifies a direct mail operation. This is the primary key. |
i_op_type |
int |
no |
The type of this operation, such as: union, subtract, export, and so on. |
guid_main_list_id |
uniqueidentifier |
no |
A GUID that uniquely identifies the main list associated with this operation. |
guid_second_list_id |
uniqueidentifier |
yes |
A GUID that uniquely identifies the secondary list associated with this operation. |
u_expression_body |
ntext |
yes |
The expression, if any, associated with this direct mail list operation. |
u_original_filename |
ntext |
yes |
The file name, if any, associated with this direct mail list operation. |
u_op_desc |
nvarchar(256) |
no |
A description of the operation. |
i_op_progress |
int |
no |
The percentage complete of this operation. |
i_op_status |
int |
no |
The status of this operation, such as: complete, in progress, and so on. |
dt_op_started |
datetime |
no |
The date and time at which this direct mail list operation was started. |
dt_op_ended |
datetime |
yes |
The date and time at which this direct mail list operation ended. |
u_op_username |
nvarchar(50) |
no |
The name of the user who initiated this direct mail list operation. |