| View Name: | MARITempReportProjectPhaseService |
| Based on table: | MPTmpRptProjektPhaseLeistung |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: Temporary Table: Project Phase Service |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ConnectionID | ConnectionID INT Primary |
||
| LineID | ZeilenID INT Primary |
||
| TimeSheetEntryID | BuchungsErfassungID INT |
||
| LineType | nKnzLeistungArtikel SMALLINT |
||
| AddOnItems | ZusatzArtikel SMALLINT (0=false,-1=true) |
||
| ItemPosition | ArtikelPosition INT |
||
| TimeKeepingHeaderID | BuchungsKopfID INT |
||
| ProjectNumber | Projektnummer NVARCHAR (20) |
MARIProjectMaster.ProjectNumber | |
| ProjectMatchcode | ProjektMatchcode NVARCHAR (100) |
||
| Matchcode | Matchcode NVARCHAR (100) |
||
| ProjectBusinessUnit | ProjektGB INT |
||
| ProjectCO | ProjektKT NVARCHAR (50) |
||
| ProjectType | ProjektTyp SMALLINT |
||
| ProjectTypeName | ProjektTypBezeichnung NVARCHAR (100) |
||
| EmployeeNumber | Personalnummer NVARCHAR (50) |
MARIEmployeeMaster.EmployeeNumber | |
| EmployeeMatchcode | PersonMatchcode NVARCHAR (50) |
||
| EmployeeProfitCenter | PersonKT NVARCHAR (20) |
||
| EmployeeProfitCenterName | PersonKTBezeichnung NVARCHAR (50) |
||
| EmployeeProjectCode | PersonKS NVARCHAR (20) |
||
| EmployeeProjectCodeName | PersonKSBezeichnung NVARCHAR (50) |
||
| EmployeeBusinessUnit | PersonGB INT |
||
| EmployeeBusinessUnitMatchcode | PersonGBBezeichnung NVARCHAR (50) |
||
| EmployeeType | PersonTyp SMALLINT |
||
| Quantity | Menge NUMERIC(19,6) |
||
| InvQty | MengeFAK NUMERIC(19,6) |
||
| TimeStart | UhrzeitBeginn Datetime |
||
| TimeEnd | UhrzeitEnde Datetime |
||
| TimeBreak | UhrzeitPause Datetime |
||
| SalesPrice | VKPreis NUMERIC(19,6) |
||
| ServiceOrItemNumber | Leistungsnummer_KHKArtikel NVARCHAR (50) |
||
| ServiceMatchcode | LMatchcode NVARCHAR (200) |
||
| PhaseID | PhasenID INT |
MARIProjectPhases.PhaseID | |
| PhaseName | Phase NVARCHAR (100) |
MARIProjectPhases.PhaseName | |
| Period | Periode INT |
MARIPeriods.Period | |
| PeriodText | PeriodeText NVARCHAR (50) |
||
| EntryDate | ErfassungsDatum Datetime |
||
| InvoiceID | FakturaID INT |
||
| ContractID | VertragsID INT |
MARIContract.ContractID | |
| ContractName | VertragsBezeichnung NVARCHAR (200) |
||
| ContractPositionID | Vertragsposition INT |
MARIContractPositions.ContractPositionID | |
| ActivityText | Aktivitaet NVARCHAR (100) |
||
| ApprovalMode | Freigabe SMALLINT |
||
| AccountingDate | AbrechnungTag SMALLINT (0=false,-1=true) |
||
| UoM | MengenEinheit NVARCHAR (10) |
||
| BookingMemo | BuchungsMemo NTEXT |
||
| Header | KopfText NVARCHAR (255) |
||
| ServiceTimeStart | LBegin Datetime |
||
| ServiceTimeEnd | LEnde Datetime |
||
| Customer | KHKKunde NVARCHAR (50) |
||
| Company | KHKMandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| CustomerName | KundeMatchcode NVARCHAR (100) |
||
| PlannedWorkingTime | Sollarbeitszeit NUMERIC(19,6) |
||
| OverTimeActual | UeberstundenAktuell NUMERIC(19,6) |
||
| PictureImage | PictureImage Image |
||
| SourceType | QuellTyp INT |
||
| SourceTypeText | QuellTypText NVARCHAR (255) |
||
| SourceReference | QuellReferenz INT |
||
| SourceReferenceDocNum | QuellReferenzDocNum INT Index |
||
| SourceReferencePos | QuellReferenzPos INT |
| Table | Description |
|---|---|
| MARITempTimeBookingAddOn | Reporting: Temporary Table: Time Booking Add On |