| Table Name: | MPReise2Zeiten |
| View Name: | MARITravelTripTime |
| Group: | Group: TravelTrip |
| Description: | Travel Expenses Module: Trip day lines |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
MPPersonenstamm.Personalnummer | |
| ReiseTag | TripDate Datetime Primary |
||
| ReiseID | TripID INT Primary |
MPReise2.ReiseID | |
| UhrzeitAnfang | HourStart Datetime Primary |
||
| UhrzeitEnde | HourEnd Datetime |
||
| Stunden | HoursQty NUMERIC(19,6) |
||
| TagesText | DayText NVARCHAR (50) |
||
| ReiseLand | CountryDestination INT |
||
| OptionMode | OptionMode INT |
||
| UpdateStamp | UpdateStamp INT |