MARIProject Database Structure

Table Name:MPBelegeEmpfaenger
View Name:MARIDocumentRecipient
Group:Group: SupportIssue
Description:Definition of eMail Recipients for documents out of a contract.

Field View(engl.field)/Type Description Related
BelegempfaengerID DocumentRecipientID

INT Primary

LinkClassID LinkClassID

INT Index

ClassID
LinkClassKey LinkClassKey

NVARCHAR (20) Index

Reihenfolge SortOrder

INT

BelegArtMode DocumentGroupMode

INT

Belegart DocumentTypeID

INT

EmpfaengerClassID RecipientClassID

INT

Mandant Company

SMALLINT

MPSysConnections.CompanyID (WHERE ConnectionType=6)
CardCode CardCode

NVARCHAR (20)

OCRD.CardCode
Ansprechpartner ContactPerson

INT

OCPR.CntctCode
Mitarbeiter EmployeeNumber

NVARCHAR (20)

MPPersonenstamm.Personalnummer
CCMode CCMode

INT

ErstanlageID CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Erstanlage CreateDate

Datetime

AenderungID ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung ChangeDate

Datetime




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany