| View Name: | MARIEmployeesTrip2TravelMilageSub |
| Based on table: | MPPersonenReise2FahrzSub |
| Group: | Group: EmployeeMaster |
| Description: | Travel Expenses Module: Employee Mileage type (sub) |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| EmployeeNumber | Personalnummer NVARCHAR (20) Primary |
MARIEmployeeMaster.EmployeeNumber | |
| ValidFrom | GueltigAb INT Primary |
MARIPeriods.ValidFrom | |
| VehicleType | Fahrzeugart INT Primary |
MARITravelMilageAllowanceHeader.VehicleType | |
| TravelExpensesRule | ReiseTemplate INT Primary |
MARITravelTemplate.TravelExpensesRule | |
| QuantityFrom | MengeAb INT Primary |
||
| StandardRate | StandardSatz NUMERIC(19,6) |
||
| StandardRateFc | StandardSatzFW NUMERIC(19,6) |
||
| Currency | WKZ NVARCHAR (3) |
ISO Currency Code | |
| UpdateStamp | UpdateStamp INT |