MARIProject Database Structure

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

Field Table(Germ.field)/Type Description Related
DocumentRecipientID BelegempfaengerID

INT Primary

LinkClassID LinkClassID

INT Index

ClassID
LinkClassKey LinkClassKey

NVARCHAR (20) Index

SortOrder Reihenfolge

INT

DocumentGroupMode BelegArtMode

INT

DocumentTypeID Belegart

INT

RecipientClassID EmpfaengerClassID

INT

Company Mandant

SMALLINT

MARISysConnections.Company (WHERE ConnectionType=6)
CardCode CardCode

NVARCHAR (20)

OCRD.CardCode
ContactPerson Ansprechpartner

INT

OCPR.CntctCode
EmployeeNumber Mitarbeiter

NVARCHAR (20)

MARIEmployeeMaster.EmployeeNumber
CCMode CCMode

INT

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
CreateDate Erstanlage

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany