| View Name: | MARINewsletterFilterSet |
| Based on table: | MPNewsletterFilterSet |
| Group: | Group: NewsletterMaster |
| Description: | Predefined filter on the E-Mail sources |
| ClassID: | 559. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| FilterSetID | FilterSetID INT Primary |
||
| FilterSetType | FilterSetType INT Index |
||
| FilterSetName | FilterSetName NVARCHAR (100) Index |
||
| FilterSetGroup | FilterSetGroup INT |
MARIGroups.FilterSetGroup (WHERE GruppenArt=10670) | |
| Responsible | Responsible NVARCHAR (20) |
MARIEmployeeMaster.Responsible | |
| CompanyID | CompanyID SMALLINT Index |
MARISysConnections.CompanyID (WHERE ConnectionType=6) | |
| SourceModeBP | SourceModeBP INT |
1=FilterSet with values, 2=SQL | |
| SourceValueBP | SourceValueBP NTEXT |
||
| SourceModeContact | SourceModeContact INT |
1=FilterSet with values, 2=SQL | |
| SourceValueContact | SourceValueContact NTEXT |
||
| SourceModeEmployee | SourceModeEmployee INT |
1=FilterSet with values, 2=SQL | |
| SourceValueEmployee | SourceValueEmployee NTEXT |
||
| SourceModeParticipant | SourceModeParticipant INT |
1=FilterSet with values, 2=SQL | |
| SourceValueRarticipant | SourceValueRarticipant NTEXT |
||
| SourceModeSupportProduct | SourceModeSupportProduct INT |
||
| SourceValueSupportProduct | SourceValueSupportProduct NTEXT |
||
| FilterSetRemark | FilterSetRemark NVARCHAR (255) |
||
| 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 |
| MARINewsletterMaster | Newsletter Design Template |
| MARINewsletterLog | Log the sending action of a new newsletter |
| MARINewsletterCampaign | Source data for a plain newsletter (one time user) |