MARIProject Database Structure

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

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

NVARCHAR (20) Primary

MARIEmployeeMaster.EmployeeNumber
ValidFrom GueltigAb

INT Primary

MARIPeriods.ValidFrom
ProjectNumber Projektnummer

NVARCHAR (20) Primary

MARIProjectMaster.ProjectNumber
Currency WKZ

NVARCHAR (3)

ISO Currency Code
ISCRateDay VerSatzTag

NUMERIC(19,6)

ISCRateHour VerSatzStunde

NUMERIC(19,6)

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany