MARIProject Database Structure

View Name:MARITravelTripTimeAllowances
Based on table:MPReise2ZeitenPauschalenZeilen
Group:Group: TravelTrip
Description:Travel Expenses Module: Employee trip days allowance link

Field Table(Germ.field)/Type Description Related
EmployeeNumber Personalnummer

NVARCHAR (20) Primary

MARIEmployeeMaster.EmployeeNumber
TripDate ReiseTag

Datetime Primary

MealAllowanceType VerpflegungsTyp

SMALLINT Primary

TripLine ReiseZeile

INT Primary

TripID ReiseID

INT Index

MARITravelTrip.TripID
PercentValue Prozent

NUMERIC(19,6)

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany