MARIProject Database Structure

Table Name:MPPersonenReise2Fahrz
View Name:MARIEmployeesTrip2TravelMilage
Group:Group: EmployeeMaster
Description:Travel Expenses Module: Employee Mileage type (header)

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
Bezeichnung Description

NVARCHAR (50)

Firmenfahrzeug CompanyCarID

SMALLINT

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany