MARIProject Database Structure

View Name:MARIProjectPhaseDegreeOfCompletion
Based on table:MPProjektPhasenFertigstellungsgrad
Group:Group: ProjectPhases
Description:Project Phases Master: Degree OF Completion History

Field Table(Germ.field)/Type Description Related
PhaseDoCID PhaseFGID

INT Primary

PhaseID PhasenID

INT Index

0=Project DegreeOfCompletion MARIProjectPhases.PhaseID
ProjectNumber Projektnummer

NVARCHAR (20) Index

MARIProjectMaster.ProjectNumber
PlanningVersion PlanungsVersion

INT Index

MARIProjectPlanningVersions.PlanningVersion
DegreeOfCompletion FertigStellungsGrad

NUMERIC(19,6)

in % 100%=1
EvaluationDate AuswertungsDatum

Datetime

Date of the value for the x-axis in the chart
Remark Anmerkung

NTEXT

CreateDate Erstanlage

Datetime

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany