MKTEXPORTDEFINITION (4.0SP17)

ID

uniqueidentifier

PREVIEWDATALISTCATALOGID

uniqueidentifier

true

The datalist ID used for previewing the export definition.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

POSTALTEMPLATEID

uniqueidentifier

true

The postal template to use during a postal export of a marketing effort.

EXPORTDEFINITIONID

uniqueidentifier

true

The export definition to which these marketing-specific properties apply.

NAME

nvarchar(100)

false

A unique name for the export definition.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

POSTALEXPORT

bit

false

Whether or not to do a postal export using Satori.

MAILINGTYPECODE

tinyint

false

The marketing effort type with which this export definition is compatible.

NETCOMMUNITYDATASOURCEID

int

false

The ID Blackbaud Internet Solutions data source to which this export definition is tied.

CHANGEDBYCULTURE

nvarchar(30)

false

The culture that last saved the export definition.

ISSYSTEM

bit

false

Flag for hiding export definitions meant for system use only.

MAILINGTYPE

nvarchar(25) (Computed)

true

Provides a translation for the 'MAILINGTYPECODE' field.

IX_MKTEXPORTDEFINITION_DATEADDED

False

False

True

IX_MKTEXPORTDEFINITION_DATECHANGED

False

False

False

IX_MKTEXPORTDEFINITION_NETCOMMUNITYDATASOURCEID

False

False

False

IX_MKTEXPORTDEFINITION_POSTALTEMPLATEID

False

False

False

PK_MKTEXPORTDEFINITION

True

True

False

UC_MKTEXPORTDEFINITION_NAME

True

False

False

UIX_MKTEXPORTDEFINITION_EXPORTDEFINITIONID

True

False

False

UIX_MKTEXPORTDEFINITION_PREVIEWDATALISTCATALOGID

True

False

False

TR_MKTEXPORTDEFINITION_AUDIT_UPDATE

TR_MKTEXPORTDEFINITION_AUDIT_DELETE

MKTEXPORTDEFINITIONOUTPUTFIELD

EXPORTDEFINITIONID