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