| Table Name: | MPProjektBuchungskopf |
| View Name: | MARIProjectTimeKeepingHeader |
| Group: | Group: ProjectTimeKeepingHeader |
| Description: | 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). |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| BuchungsKopfID | TimeKeepingHeaderID INT Unique |
||
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
MPPersonenstamm.Personalnummer | |
| Periode | Period INT Primary |
MPPerioden.PeriodeJahr | |
| FreigabePeriode | ApprovalPeriod SMALLINT (0=false,-1=true) |
||
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Notizen | Notes NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPProjektArbeitspaketerfassung | Work Packages progress reporting by day |
| MPProjektArtikelerfassung | 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 |
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MPProjektLeistungserfassung | 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 |