mktg_dm_item Table
The mktg_dm_item table in the marketing database contains information about direct mailer items.
The following table describes the columns in the mktg_dm_item table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_dmitem_id |
int |
no |
The ID of this driect mailer item. This is the primary key. It is used internally by the Marketing System and is not used to retrieve direct mail. Direct mail is retrieved using the associated campaign item ID. |
i_campitem_id |
int |
no |
The ID of the campaign item associated with this direct mailer item. This is a foreign key into the mktg_campaign_item table. This ID is used to uniquely identify this direct mail in the Marketing System. |
g_dmitem_listid |
uniqueidentifier |
no |
A GUID that uniquely identifies the corresponding mailing list in the marketing list database. |
g_dmitem_optout |
uniqueidentifier |
yes |
A GUID that uniquely identifies the corresponding opt-out list, if any, in the marketing list database. |
g_dmitem_testlistid |
uniqueidentifier |
yes |
A GUID that uniquely identifies the corresponding test list, if any, in the marketing list database. |
u_dmitem_from |
nvarchar(256) |
no |
A string that is used in the "From" field in the direct mail header. |
u_dmitem_replyto |
nvarchar(256) |
no |
A string that is used in the "ReplyTo" field in the direct mail header. |
u_dmitem_source |
nvarchar(1024) |
no |
A string that is used as the body of the direct mail. |
b_dmitem_personalized |
bit |
no |
A Boolean value that indicates whether the direct mail content is personalized. |
b_dmitem_ignore_global_optout |
bit |
no |
A Boolean value that indicates whether to ignore the global opt-out list. |
i_dmitem_defformat |
smallint |
no |
A value that indicated the default format for the direct mail. |
u_dmitem_defcharset |
nvarchar(20) |
no |
A string that indicates the default character set. |
u_dmitem_deflanguage |
nvarchar(20) |
no |
A string that indicates the default language. |
i_dmitem_type |
int |
no |
A value that indicates whether this direct mail will be sent more than one time, and if so, how frequently. |
i_dmitem_daily_interval |
int |
yes |
A value that indicates the number of days between mailings. |
i_dmitem_weekly_interval |
int |
yes |
A value that indicates the number of weeks between mailings. |
i_dm_item_days_of_week |
int |
yes |
A bit field that indicates one or more days of the week on which this direct mail will be sent. |
i_dmitem_day_of_month |
int |
yes |
A value that indicates a particular day of the month on which this direct mail will be sent. |
i_dmitem_months |
int |
yes |
A bit field that indicates one or more months during which this direct mail will be sent. |
i_dmitem_week |
int |
yes |
A value that indicates a week of the month on which this direct mail will be sent. |