| Table Name: | MPReise2ZeitenPauschalen |
| View Name: | MARITravelTripTimeAllowancesLines |
| Group: | Group: TravelTrip |
| Description: | Travel Expenses Module: Employee trip days |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
MPPersonenstamm.Personalnummer | |
| ReiseTag | TripDate Datetime Primary |
||
| VerpflegungsTyp | MealAllowanceType SMALLINT Primary |
||
| VerpflegungsFlaggs | MealAllowanceFlag INT |
||
| ReiseZeilenReferenz | TripLineReference INT |
||
| Einheit | UoM NVARCHAR (20) |
||
| Stunden | Hours NUMERIC(19,6) |
||
| PauschaleSys | AllowanceValueSys NUMERIC(19,6) |
||
| PauschaleMA | AllowanceValueLoc NUMERIC(19,6) |
||
| PauschaleFW | AllowanceValueFc NUMERIC(19,6) |
||
| WKZSys | CurrencySys NVARCHAR (3) |
||
| WKZMa | CurrencyCompany NVARCHAR (3) |
||
| WKZBeleg | CurrencyForeign NVARCHAR (3) |
||
| WkzMaKurs | ExchangeRateCompany Float |
||
| WKzKursFw | ExchangeRateFC2Sys Float |
||
| UpdateStamp | UpdateStamp INT |