COMMUNICATIONLETTER (4.0SP17)

ID

uniqueidentifier

SEGMENTATIONID

uniqueidentifier

true

FK to MKTSEGMENTATION

MKTASKLADDERID

uniqueidentifier

true

FK to MKTASKLADDER

MAILPACKAGEID

uniqueidentifier

true

FK to MKTPACKAGE

EMAILPACKAGEID

uniqueidentifier

true

FK to MKTPACKAGE

MAILSEGMENTID

uniqueidentifier

true

FK to MKTSEGMENT

EMAILSEGMENTID

uniqueidentifier

true

FK to MKTSEGMENT

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

EMAILSTATUSID

uniqueidentifier

true

FK to EMAILSTATUSGENERALPURPOSE

COMMUNICATIONTYPECODE

tinyint

false

0=Marketing effort, 1=Appeal mailing, 2=Event invitation, 3=Acknowledgement, 4=Reminder

SEQUENCE

int

false

The sequence in which this letter will be processed.

NAME

nvarchar(100)

false

CHANNELCODE

tinyint

false

0=Mail, 1=Email, 2=Mail and Email

CHANNEL

nvarchar(14) (Computed)

true

Provides a translation for the 'CHANNELCODE' field.

CHANNELPREFERENCECODE

tinyint

false

0=Email, 1=Mail

CHANNELPREFERENCE

nvarchar(5) (Computed)

true

Provides a translation for the 'CHANNELPREFERENCECODE' field.

MAILCONTENTHTML

nvarchar(max)

false

EMAILCONTENTHTML

nvarchar(max)

false

EMAILSUBJECT

nvarchar(255)

false

EMAILFROMDISPLAYNAME

nvarchar(255)

false

EMAILFROMADDRESS

UDT_EMAILADDRESS

false

MARGINTOP

decimal(20, 4)

false

MARGINBOTTOM

decimal(20, 4)

false

MARGINLEFT

decimal(20, 4)

false

MARGINRIGHT

decimal(20, 4)

false

PAPERSIZECODE

tinyint

false

0=Letter, 1=A4

PAPERSIZE

nvarchar(6) (Computed)

true

Provides a translation for the 'PAPERSIZECODE' field.

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.

INCLUDEINACTIVE

bit

false

EMAILREPLYTOADDRESS

UDT_EMAILADDRESS

false

COMMUNICATIONTYPE

nvarchar(16) (Computed)

true

Provides a translation for the 'COMMUNICATIONTYPECODE' field.

OUTPUTTYPECODE

tinyint

false

OUTPUTTYPE

nvarchar(5) (Computed)

true

RUNSCHEDULED

bit

false

RUNNOW

bit

false

IX_COMMUNICATIONLETTER_DATEADDED

False

False

True

IX_COMMUNICATIONLETTER_DATECHANGED

False

False

False

IX_COMMUNICATIONLETTER_EMAILPACKAGEID

False

False

False

IX_COMMUNICATIONLETTER_EMAILSEGMENTID

False

False

False

IX_COMMUNICATIONLETTER_MAILPACKAGEID

False

False

False

IX_COMMUNICATIONLETTER_MAILSEGMENTID

False

False

False

IX_COMMUNICATIONLETTER_MKTASKLADDERID

False

False

False

PK_COMMUNICATIONLETTER

True

True

False

UIX_COMMUNICATIONLETTER_SEGMENTATIONID_NAME

True

False

False

TR_COMMUNICATIONLETTER_AUDIT_UPDATE

TR_COMMUNICATIONLETTER_AUDIT_DELETE

COMMUNICATIONLETTERACTIVITYEXCLUSIONS

COMMUNICATIONLETTERID

COMMUNICATIONLETTEREXCLUDEDSOLICITCODE

COMMUNICATIONLETTERID

COMMUNICATIONLETTERSELECTION

COMMUNICATIONLETTERID