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