| Table Name: | MPNewsletterCampaign |
| View Name: | MARINewsletterCampaign |
| Group: | Group: NewsletterMaster |
| Description: | Source data for a plain newsletter (one time user) |
| ClassID: | 580. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| NewsletterCampaignID | NewsletterCampaignID INT Primary |
||
| NewsletterID | NewsletterID INT |
MPNewsletterMaster.NewsletterID | |
| FilterSetID | FilterSetID INT |
MPNewsletterFilterSet.FilterSetID | |
| CampaignName | CampaignName NVARCHAR (100) Index |
||
| CampaignSubject | CampaignSubject NVARCHAR (255) |
||
| CampaignBody | CampaignBody NTEXT |
||
| CampaignDate | CampaignDate Datetime |
||
| CampaignStatus | CampaignStatus INT |
||
| CampaignGroup | CampaignGroup INT |
MPGruppen.GruppenID (WHERE GruppenTyp=10671) | |
| CustomerLanguageID | CustomerLanguageID INT |
MPSysKundenSprachen.CustomerLanguageID | |
| Responsible | Responsible NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| MsgCountTotal | MsgCountTotal INT |
||
| MsgCountDone | MsgCountDone INT |
||
| MsgCountFail | MsgCountFail INT |
||
| ErrorMessages | ErrorMessages NTEXT |
||
| 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 |