| Table Name: | MPEKVertraegeBelegeFreigabe |
| View Name: | MARIPurchaseProcessDocumentApproval |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Document Approval Employee Link |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPBelID | MARIDocID INT Primary |
MPEKVertraegeBelege.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 | Approver NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| Freigabe | ApprovalMode SMALLINT Index |
0=Pending, -1=Approved, 99=Rejected | |
| FreigegebenAm | ApprovedDate Datetime |
||
| FreigegebenID | ApprovedUser NVARCHAR (4) Index |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| FreigabeWartend | ApprovedPending SMALLINT |
-1 for the active employee in the chain | |
| Freigabetext | ApprovalText NTEXT |
Free approval text | |
| AnzahlFreigebender | NumberOfApprovers INT |
Only for type 7 n out of. Stores the max number | |
| UpdateStamp | UpdateStamp INT |