MARIProject Database Structure

Table Name:MPDocValidation
View Name:MARIDocValidation
Group:Group: DocApproval
Description:Validation rule for A/P invoices based on the linked purchase order

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

INT Primary

ClassID ClassID

INT Index

ClassID
Matchcode Matchcode

NVARCHAR (50) Index

ModeCreatorNotFound ModeCreatorNotFound

INT

CurrencyCode CurrencyCode

NVARCHAR (3) Index

ValidationMemo ValidationMemo

NTEXT

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
MPDocValidationResource Validation rule details for A/P invoices based on the linked purchase order


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany