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