MARIProject Database Structure

Table Name:MPSetupVacationType
View Name:MARISetupVacationType
Group:
Description:Master Data: Setting for different vacation types

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

INT Primary

VacationTypeName VacationTypeName

NVARCHAR (100)

SystemType SystemType

INT

ProjectType ProjectType

INT

DefaultProject DefaultProject

NVARCHAR (50)

BudgetMode BudgetMode

INT

ApplicationMode ApplicationMode

INT

PreviousYearHandling PreviousYearHandling

INT

Lohnkategorie PayrollTypeGroup

NVARCHAR (50)

Description Description

NTEXT

CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Memo Memo

NTEXT

InActive InActive

SMALLINT

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany