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
MARIDocApprovalLink Special Approval Rules per contract
MARIDocApprovalRessources 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