MARIProject Database Structure

Table Name:MPTmpRptProjektPhasenBericht
View Name:MARITempReportProjectPhase
Group:Group: TempReportDocumentHeader
Description:Reporting: Temporary Table: Project Phase Report

Field View(engl.field)/Type Description Related
ConnectionID ConnectionID

INT Primary

ZeilenID LineID

INT Primary

Projekt ProjectNumber

NVARCHAR (20)

MPProjektstamm.Projektnummer
Projektname ProjectName

NVARCHAR (100)

Phase PhaseID

INT

MPProjektPhasen.PhasenID
PhaseName PhaseName

NVARCHAR (150)

Kostentraeger ProjectCode

NVARCHAR (20)

OPRJ.PrjCode
Kostentraegername ProjectCodeName

NVARCHAR (100)

SaKto AcctCode

NVARCHAR (20)

Bezeichnung Description

NVARCHAR (100)

Periode Period

INT

MPPerioden.PeriodeJahr
Kontenart AccountType

NVARCHAR (2)

Position PositionID

INT

SollStunden TargetHours

NUMERIC(19,6)

SollKosten TargetCosts

NUMERIC(19,6)

IstStunden ActualHours

NUMERIC(19,6)

IstKosten ActualCosts

NUMERIC(19,6)

PictureImage PictureImage

Image




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany