MARIProject Database Structure

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

Field Table(Germ.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)

CreateDate Erstanlage

Datetime

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT


Linked by

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


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany