| Table Name: | MPSysMessages |
| View Name: | MARISysMessages |
| Group: | Group: SysMessages |
| Description: | System: eMail System (Header) |
| ClassID: | 194. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ActionID | ActionID INT Primary |
||
| ClassID | ClassID INT Index |
ClassID | |
| KeyReference | KeyReference NVARCHAR (20) |
||
| Method | MethodMode INT |
||
| ScheduledTime | ScheduledTime Datetime Index |
||
| CreationTime | CreationTime Datetime |
||
| Done | Done SMALLINT (0=false,-1=true) Index |
||
| UserFrom | UserFrom NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UserToEmployeeNumber | UserToEmployeeNumber NVARCHAR (255) |
MPPersonenstamm.Personalnummer | |
| UserTo | UserTo NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| MsgFrom | MsgFrom NVARCHAR (255) |
||
| MsgReplyTo | MsgReplyTo NVARCHAR (255) |
||
| MsgTo | MsgTo NVARCHAR (255) |
||
| MsgToCC | MsgToCC NVARCHAR (255) |
||
| MsgToBCC | MsgToBCC NVARCHAR (255) |
||
| MsgHead | MsgHead NVARCHAR (255) |
||
| MsgBody | MsgBody NTEXT |
||
| MsgID | MsgID NVARCHAR (200) Index |
||
| DocumentID | DocumentID INT Index |
MPDokumente.DocID | |
| EventID | EventID INT Index |
||
| Active | Active SMALLINT (0=false,-1=true) Index |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPEKVertraegeBelegeDruck | Purchase Process: Print history |
| MPSysMessagesAttachment | System: eMail System (Attachments) |
| MPVKVertraegeBelegeDruck | Contract Management: Print History |
| MPWiedervorlagen | System: Reminder |