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.

See Also

Other Resources

Marketing Database Tables

Marketing Lists Database Tables

mktg_campaign_item Table