MARIProject Database Structure

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

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

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
MARIDocValidationResource 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