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