| Table Name: | MPReise2Freigabe |
| View Name: | MARITravelAccountingApproval |
| Group: | Group: TravelTrip |
| Description: | Travel Expenses Module: Approval for travel requests |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ReiseID | TripID INT Primary |
||
| 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 |
||
| 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 |