MARIProject Database Structure

Table Name:MPPersonenVerrechnung
View Name:MARIEmployeeCostRates
Group:Group: EmployeeMaster
Description:Employee Master: Cost Rates

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

NVARCHAR (20) Primary

MPPersonenstamm.Personalnummer
GueltigAb ValidFrom

INT Primary

MPPerioden.PeriodeJahr
FuerGeschaeftsbereich ForBusinessUnit

SMALLINT Primary

MPSetupGeschaeftsbereich.GeschaeftsbereichID
WKZ Currency

NVARCHAR (3)

ISO Currency Code
VerSatzTag DailyRate

NUMERIC(19,6)

VerSatzStunde HourlyRate

NUMERIC(19,6)

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany