MARIProject Database Structure

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

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

NVARCHAR (50)

CompanyCarID Firmenfahrzeug

SMALLINT

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany