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