| Table Name: | MPProjektBuchungserfassungBericht |
| View Name: | MARIProjectTimeKeepingReport |
| Group: | Group: ProjectTimeKeepingHeader |
| Description: | Time Keeping: Link Week Report of employee or for customer |
| ClassID: | 525. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ErfassungsBerichtID | TimeKeepingReportID INT Primary |
||
| ErfassungsBerichtsNummer | TimeKeepingReportNumber INT |
||
| Personalnummer | EmployeeNumber NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| ErfassungsBerichtsTyp | ReportType INT Index |
||
| Vorgesetzter | Superior NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| Kunde | Customer NVARCHAR (20) Index |
OCRD.CardCode | |
| Mandant | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| StartPeriode | StartPeriod INT |
MPPerioden.PeriodeJahr | |
| StartDate | StartDate Datetime |
||
| EndDate | EndDate Datetime |
||
| Gueltig | Valid SMALLINT |
||
| WorkflowID | WorkFlowID INT Index |
MPHotlineWorkFlow.WorkFlowID | |
| Freigebender | Approver NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| FreigegebenAm | ApprovedDate Datetime |
||
| FreigegebenID | ApprovedUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| FreigabeText | ApprovalText NTEXT |
||
| FreigabeUnterschriftBildID | ApprovalSignaturePicID INT |
MPBilder.BildID | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| DokumentID | DocumentID INT |
MPDokumente.DocID | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |