MARIProject Database Structure

Table Name:MPDocApprovalLink
View Name:MARIDocApprovalLink
Group:Group: DocApproval
Description:Special Approval Rules per contract

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

INT Primary

DocApprovalID DocApprovalID

INT Index

Link to approval definition MPDocApproval.DocApprovalID
ClassID ClassID

INT Index

Master Data Dimesion ClassID
ClassKey ClassKey

NVARCHAR (20) Index

Master Data Key
ClassSubType ClassSubType

INT Index

ApprovalLinkMode ApprovalLinkMode

INT

DocValidationID DocValidationID

INT Index

Optential overwrite for A&P Invoices MPDocValidation.DocValidationID
CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany