| Table Name: | MPPersonenReise2FahrzSub |
| View Name: | MARIEmployeesTrip2TravelMilageSub |
| Group: | Group: EmployeeMaster |
| Description: | Travel Expenses Module: Employee Mileage type (sub) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
MPPersonenstamm.Personalnummer | |
| GueltigAb | ValidFrom INT Primary |
MPPerioden.PeriodeJahr | |
| Fahrzeugart | VehicleType INT Primary |
MPReise2KostenFahrzeugarten.Fahrzeugart | |
| ReiseTemplate | TravelExpensesRule INT Primary |
MPReise2Template.Reisetemplate | |
| MengeAb | QuantityFrom INT Primary |
||
| StandardSatz | StandardRate NUMERIC(19,6) |
||
| StandardSatzFW | StandardRateFc NUMERIC(19,6) |
||
| WKZ | Currency NVARCHAR (3) |
ISO Currency Code | |
| UpdateStamp | UpdateStamp INT |