| 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 |
| 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) |