| Table Name: | MPNewsletterMaster |
| View Name: | MARINewsletterMaster |
| Group: | Group: NewsletterMaster |
| Description: | Newsletter Design Template |
| ClassID: | 560. See Overview of ClassIDs by table. |
| Field | View(engl.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 |
MPGruppen.GruppenID (WHERE GruppenArt=10660) | |
| Responsible | Responsible NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| LinkClassID | LinkClassID INT Index |
ClassID | |
| LinkClassKey | LinkClassKey NVARCHAR (20) |
||
| FilterSetID | FilterSetID INT Index |
MPNewsletterFilterSet.FilterSetID | |
| NotifTextID | NotifTextID INT |
MPSysClassNotificationText.NotifTextID | |
| CustomerLanguageID | CustomerLanguageID INT |
MPSysKundenSprachen.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 | MPDokumente.DocID |
| 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 |
MPNewsletterConnector.NewsletterConnectorID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| InActive | InActive SMALLINT (0=false,-1=true) Index |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPHotlineProdukt | Support Module: Support Product: Master Data |
| MPNewsletterCampaign | Source data for a plain newsletter (one time user) |
| MPNewsletterLog | Log the sending action of a new newsletter |
| MPSysClassNotificationTextLang | Event Management: Textdefinitions by language |