MARIProject Database Structure

View Name:MARISysMessages
Based on table:MPSysMessages
Group:Group: SysMessages
Description:System: eMail System (Header)
ClassID: 194. See Overview of ClassIDs by table.

Field Table(Germ.field)/Type Description Related
ActionID ActionID

INT Primary

ClassID ClassID

INT Index

ClassID
KeyReference KeyReference

NVARCHAR (20)

MethodMode Method

INT

ScheduledTime ScheduledTime

Datetime Index

CreationTime CreationTime

Datetime

Done Done

SMALLINT (0=false,-1=true) Index

UserFrom UserFrom

NVARCHAR (4)

MARIUser.UserFrom (WHERE BenutzerTyp=1)
UserToEmployeeNumber UserToEmployeeNumber

NVARCHAR (255)

MARIEmployeeMaster.UserToEmployeeNumber
UserTo UserTo

NVARCHAR (4)

MARIUser.UserTo (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

MARIDocuments.DocumentID
EventID EventID

INT Index

Active Active

SMALLINT (0=false,-1=true) Index

UpdateStamp UpdateStamp

INT


Linked by

Table Description
MARIPurchaseProcessDocumentPrint Purchase Process: Print history
MARISysMessagesAttachment System: eMail System (Attachments)
MARIContractDocumentPrintHistory Contract Management: Print History
MARIReminder System: Reminder


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany