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