MARIProject Database Structure

Table Name:MPReise2Grundprojekte
View Name:MARITravelTripProjectLink
Group:Group: TravelTrip
Description:Travel Expenses Module: Business Trip Project Link

Field View(engl.field)/Type Description Related
ReiseGrundprojektID TripBaseProjectID

INT Primary

ReiseID TripID

INT Index

MPReise2.ReiseID
Reihenfolge ProjectOrder

SMALLINT Index

Projektnummer ProjectNumber

NVARCHAR (20)

MPProjektstamm.Projektnummer
PhasenID PhaseID

INT

MPProjektPhasen.PhasenID
VertragsID ContractID

INT

MPVKVertraege.VertragsID
Prozent PercentValue

NUMERIC(19,6)

UpdateStamp UpdateStamp

INT


Linked by

Table Description
MPReise2ZeileProjekt Travel Expenses Module: Trip receipt project line for invoice


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany