MARIProject Database Structure

Table Name:MPPersonenVerrechnungProjekt
View Name:MARIEmployeeCostRatesProject
Group:Group: EmployeeMaster
Description:Employee Master: Cost Rates per project for freelancers

Field View(engl.field)/Type Description Related
Personalnummer EmployeeNumber

NVARCHAR (20) Primary

MPPersonenstamm.Personalnummer
GueltigAb ValidFrom

INT Primary

MPPerioden.PeriodeJahr
Projektnummer ProjectNumber

NVARCHAR (20) Primary

MPProjektstamm.Projektnummer
WKZ Currency

NVARCHAR (3)

ISO Currency Code
VerSatzTag ISCRateDay

NUMERIC(19,6)

VerSatzStunde ISCRateHour

NUMERIC(19,6)

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany