MARIProject Database Structure

Table Name:MPPersonenZeitenRegelZulagen
View Name:MARIAttendanceRuleShifts
Group:Group: AttandenceRuleHead
Description:Attendance: Working Time rules (Night shift additionals)

Field View(engl.field)/Type Description Related
RuleID RuleNumber

INT Primary

MPPersonenZeitenRegel.Regel
DayTypeKey Code

SMALLINT Primary

Company Company

SMALLINT Primary

MPSysConnections.CompanyID (WHERE ConnectionType=6)
StartTime StartTime

Datetime

EndTime EndTime

Datetime

Surcharge SurchargeDiscount

NUMERIC(19,6)

PayrollType PayrollType

NVARCHAR (20)

MPLohnArten.LohnArt
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany