| View Name: | MARIProjectTimeKeepingHeader |
| Based on table: | MPProjektBuchungskopf |
| 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 | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| TimeKeepingHeaderID | BuchungsKopfID INT Unique |
||
| EmployeeNumber | Personalnummer NVARCHAR (20) Primary |
MARIEmployeeMaster.EmployeeNumber | |
| Period | Periode INT Primary |
MARIPeriods.Period | |
| ApprovalPeriod | FreigabePeriode SMALLINT (0=false,-1=true) |
||
| CreateDate | Erstanlage Datetime |
||
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Notes | Notizen NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIProjectItemBooking | 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 |
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MARIProjectTimeKeepingLinesServices | 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 |
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day |