MARIProject Database Structure

View Name:MARINewsletterMaster
Based on table:MPNewsletterMaster
Group:Group: NewsletterMaster
Description:Newsletter Design Template
ClassID: 560. See Overview of ClassIDs by table.

Field Table(Germ.field)/Type Description Related
NewsletterID NewsletterID

INT Primary

NewsletterMasterType NewsletterMasterType

INT

560 newsletter design, 582 notification design
NewsletterName NewsletterName

NVARCHAR (100) Index

NewsletterGroup NewsletterGroup

INT

MARIGroups.NewsletterGroup (WHERE GruppenArt=10660)
Responsible Responsible

NVARCHAR (20)

MARIEmployeeMaster.Responsible
LinkClassID LinkClassID

INT Index

ClassID
LinkClassKey LinkClassKey

NVARCHAR (20)

FilterSetID FilterSetID

INT Index

MARINewsletterFilterSet.FilterSetID
NotifTextID NotifTextID

INT

MARIClassNotificationText.NotifTextID
CustomerLanguageID CustomerLanguageID

INT

MARISysCustomerLanguages.CustomerLanguageID
StatusID StatusID

INT Index

NewsLetterDate NewsLetterDate

Datetime

Subject Subject

NVARCHAR (255)

Body Body

NTEXT

TemplateSource TemplateSource

NTEXT

Depending on the type, a link to MPDocument is the INT value MARIDocuments.TemplateSource
DefaultSalutation DefaultSalutation

NVARCHAR (50)

SendFrom SendFrom

NVARCHAR (255)

ReplyTo ReplyTo

NVARCHAR (255)

HTMLProcessing HTMLProcessing

INT

ImageHandling ImageHandling

INT

ICSHandling ICSHandling

INT

FirstSendAction FirstSendAction

Datetime

LastSendAction LastSendAction

Datetime

NewsletterConnectorID NewsletterConnectorID

INT

MARINewsletterConnector.NewsletterConnectorID
CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
Memo Memo

NTEXT

InActive InActive

SMALLINT (0=false,-1=true) Index

UpdateStamp UpdateStamp

INT


Linked by

Table Description
MARISupportProduct Support Module: Support Product: Master Data
MARIClassNotificationTextLang Event Management: Textdefinitions by language
MARINewsletterLog Log the sending action of a new newsletter
MARINewsletterCampaign Source data for a plain newsletter (one time user)


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany