MARIProject Database Structure

Table Name:MPPersonenFahrzeugarten
View Name:MARIEmployeesTravelMilage
Group:Group: EmployeeMaster
Description:Employee Master: Linked mileage allowances

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
Kostensatz Costs

NUMERIC(19,6)

WKZ Currency

NVARCHAR (3)

ISO Currency Code
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany