MARIProject Database Structure

View Name:MARITempReportTimeKeeping
Based on table:MPTmpRptStundenUeberblick
Group:Group: TempReportDocumentHeader
Description:Reporting: Temporary Table: Time Keeping

Field Table(Germ.field)/Type Description Related
ConnectionID ConnectionID

INT Primary

ValueType WertTyp

SMALLINT Primary

EmployeeNumber Personalnummer

NVARCHAR (20) Primary

MARIEmployeeMaster.EmployeeNumber
Matchcode Matchcode

NVARCHAR (100) Index

BaseQty GMenge

NUMERIC(19,6)

Period1 Periode1

NUMERIC(19,6)

Period2 Periode2

NUMERIC(19,6)

Period3 Periode3

NUMERIC(19,6)

Period4 Periode4

NUMERIC(19,6)

Period5 Periode5

NUMERIC(19,6)

Period6 Periode6

NUMERIC(19,6)

Period7 Periode7

NUMERIC(19,6)

Period8 Periode8

NUMERIC(19,6)

Period9 Periode9

NUMERIC(19,6)

Period10 Periode10

NUMERIC(19,6)

Period11 Periode11

NUMERIC(19,6)

Period12 Periode12

NUMERIC(19,6)

PeriodTextShort1 PeriodeBezKurz1

NVARCHAR (10)

PeriodTextShort2 PeriodeBezKurz2

NVARCHAR (10)

PeriodTextShort3 PeriodeBezKurz3

NVARCHAR (10)

PeriodTextShort4 PeriodeBezKurz4

NVARCHAR (10)

PeriodTextShort5 PeriodeBezKurz5

NVARCHAR (10)

PeriodTextShort6 PeriodeBezKurz6

NVARCHAR (10)

PeriodTextShort7 PeriodeBezKurz7

NVARCHAR (10)

PeriodTextShort8 PeriodeBezKurz8

NVARCHAR (10)

PeriodTextShort9 PeriodeBezKurz9

NVARCHAR (10)

PeriodTextShort10 PeriodeBezKurz10

NVARCHAR (10)

PeriodTextShort11 PeriodeBezKurz11

NVARCHAR (10)

PeriodTextShort12 PeriodeBezKurz12

NVARCHAR (10)

PictureImage PictureImage

Image




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany