MARIProject Database Structure

Table group of ProjectTimeKeepingLines
Table/View English Description
MARIProjectBookingErrors ProjectBookingErrors Time Keeping: Error log in the time keeping
MARIProjectBookingsFavorits ProjectBookingsFavorits Time Keeping: Favorits
MARIProjectItemBooking ProjectItemBooking Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf
MARIProjectItemBookingSerialNumbers ProjectItemBookingSerialNumbers Time Keeping: ProjectTimeKeepingItemsSeries: Serial numbers
MARIProjectTimeKeepingHeader ProjectTimeKeepingHeader Time Keeping: ProjectTimeKeepingHeader: One line per employee and period. This header table indicates the booking month of time sheet entries. (no project information is stored).
MARIProjectTimeKeepingLines ProjectTimeKeepingLines Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type
MARIProjectTimeKeepingLinesServices ProjectTimeKeepingLinesServices Time Keeping: ProjectTimeKeepingLinesServices: additional lines for the MPProjectBuchungserfassung for the project types: customer project and internal project with contract. This table stores the link to the contract and contract position
MARIProjectTimeKeepingReport ProjectTimeKeepingReport Time Keeping: Link Week Report of employee or for customer
MPProjektArtikelerfassung ProjectItemBooking Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf
MPProjektArtikelerfassungSerie ProjectItemBookingSerialNumbers Time Keeping: ProjectTimeKeepingItemsSeries: Serial numbers
MPProjektBuchungFavoriten ProjectBookingsFavorits Time Keeping: Favorits
MPProjektBuchungFehler ProjectBookingErrors Time Keeping: Error log in the time keeping
MPProjektBuchungserfassung ProjectTimeKeepingLines Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type
MPProjektBuchungserfassungBericht ProjectTimeKeepingReport Time Keeping: Link Week Report of employee or for customer
MPProjektBuchungskopf ProjectTimeKeepingHeader Time Keeping: ProjectTimeKeepingHeader: One line per employee and period. This header table indicates the booking month of time sheet entries. (no project information is stored).
MPProjektLeistungserfassung ProjectTimeKeepingLinesServices Time Keeping: ProjectTimeKeepingLinesServices: additional lines for the MPProjectBuchungserfassung for the project types: customer project and internal project with contract. This table stores the link to the contract and contract position

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany