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