| View Name: | MARIContractDocumentApproval |
| Based on table: | MPVKVertraegeBelegeFreigabe |
| Group: | Group: ContractDocument |
| Description: | Contract Management: Document Approval |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MARIDocID | MPBelID INT Primary |
MARIContractDocument.MARIDocID | |
| ApprovalStep | Schritt INT Primary |
||
| ApprovalType | FreigabeTyp INT |
See RuleTypes in MPDocApprovalRessource | |
| ApprovalSubType | FreigabeTypSub INT |
MARIDocApprovalRessources.ApprovalSubType | |
| ApprovalSubTypeClearer | FreigabeTypClearer INT |
0=undef, 1=Single, 4=Chain | |
| Approver1 | Freigebender NVARCHAR (20) Index |
MARIEmployeeMaster.Approver1 | |
| ApprovalMode | Freigabe SMALLINT Index |
||
| ApprovedDate | FreigegebenAm Datetime |
||
| ApprovedUser | FreigegebenID NVARCHAR (4) |
MARIUser.ApprovedUser (WHERE BenutzerTyp=1) | |
| ApprovedPending | FreigabeWartend SMALLINT |
-1 for the active employee in the chain | |
| ApprovalText | Freigabetext NTEXT |
||
| NumberOfApprovers | AnzahlFreigebender INT |
||
| UpdateStamp | UpdateStamp INT |