MARIProject Database Structure

Table Name:MPDocApproval
View Name:MARIDocApproval
Group:Group: DocApproval
Description:Approval Process Definition
ClassID: 192. See Overview of ClassIDs by table.

Field View(engl.field)/Type Description Related
DocApprovalID DocApprovalID

INT Primary

ClassID ClassID

INT Index

ClassID
Matchcode Matchcode

NVARCHAR (50) Index

ModeCreatorNotFound ModeCreatorNotFound

INT

ProcessDocument = 1, BlockDocument = 2
ModeApproverNotFound ModeApproverNotFound

INT

ProcessDocument = 1, BlockDocument = 2
ApprovalMemo ApprovalMemo

NTEXT

CurrencyCode CurrencyCode

NVARCHAR (3)

Erstanlage CreateDate

Datetime

ErstanlageID CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung ChangeDate

Datetime

AenderungID ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MPDocApprovalLink Special Approval Rules per contract
MPDocApprovalRessource Steps in the approval process. Rule Lines (Steps) for each approval prioritry. The rules are used from top (Priority=0) to button.


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany