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