MARIProject Database Structure

View Name:MARIDocApprovalLink
Based on table:MPDocApprovalLink
Group:Group: DocApproval
Description:Special Approval Rules per contract

Field Table(Germ.field)/Type Description Related
DocAppovalLinkID DocAppovalLinkID

INT Primary

DocApprovalID DocApprovalID

INT Index

Link to approval definition MARIDocApproval.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 MARIDocValidation.DocValidationID
CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany