| Table Name: | MPProjektBuchungserfassung |
| View Name: | MARIProjectTimeKeepingLines |
| Group: | Group: ProjectTimeKeepingHeader |
| Description: | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| ClassID: | 58. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| BuchungsKopf | TimeKeepingHeaderID INT Index |
(Since V6.6 optional) Link to employee monthly header | MPProjektBuchungskopf.BuchungsKopfID |
| BuchungsErfassungID | TimeSheetEntryID INT Primary |
Internal unique key | |
| Personalnummer | EmployeeNumber NVARCHAR (20) Index |
Employee who served | MPPersonenstamm.Personalnummer |
| Periode | Period INT Index |
Month of the time booking | MPPerioden.PeriodeJahr |
| PersonalTyp | EmployeeStatus INT |
Employee type (free, regular) in the period | MPSetupTypen.TypID (WHERE TypTyp=2) |
| Geschaeftsbereich | BusinessUnitID INT |
BU employee is linked to in the period. (freelancer, BU of project) | MPSetupGeschaeftsbereich.GeschaeftsbereichID |
| LeistungsTag | ServiceDate Datetime Index |
Day of the service | |
| KW | CalendarWeek INT |
Calendar Week of the service (ISO) | MPPeriodenKW.KW |
| BuchungsTyp | EntryType TINYINT |
Linked to project type | |
| ErfassungsTyp | EntryCategory SMALLINT |
Category: 0:without service, 1:With service, 2=System booking based on revenue return account, purchase document, sales document import | |
| Projektnummer | ProjectNumber NVARCHAR (20) Index |
Link to project | MPProjektstamm.Projektnummer |
| PhasenID | PhaseID INT Index |
(Optional) Phase of planning version 3 | MPProjektPhasen.PhasenID |
| Aktivitaet | ActivityText NVARCHAR (100) |
Free activity text | |
| ProduktZusatz | ProductAddOn NVARCHAR (20) |
||
| Menge | Quantity NUMERIC(19,6) |
Quantity used in the project | |
| MengeTage | WorkingDays NUMERIC(19,6) |
Days used in the project (check rounding settings) | |
| MengeFAK | InvQty NUMERIC(19,6) |
Invoicable quantity for the project | |
| MengeTageFAK | QtyDaysInv NUMERIC(19,6) |
Invoicable days for the project | |
| MengeUeb | Overtime NUMERIC(19,6) |
Overtime hours for that day | |
| Kosten | Costs NUMERIC(19,6) |
Cost in total in system currency | |
| KostenLoc | CostLoc NUMERIC(19,6) |
||
| KostenLocWKZ | CostLocCurr NVARCHAR (3) |
||
| KostenFw | CostFC NUMERIC(19,6) |
||
| KostenFwWKZ | CostFCCurr NVARCHAR (3) |
||
| Erloese | TargetedRevenues NUMERIC(19,6) |
calculative revenue based on the sales price | |
| ErloeseMALoc | TargetedRevenuesEmployeeLoc NUMERIC(19,6) |
||
| ErloeseVertragLoc | TargetedRevenuesContractLoc NUMERIC(19,6) |
||
| ErloeseVertragLocWKZ | TargetedRevenuesContractLocCurr NVARCHAR (3) |
||
| ErloeseVertragFW | TargetedRevenuesContractFC NUMERIC(19,6) |
||
| ErloeseVertragFWWKZ | TargetedRevenuesContractFCCurr NVARCHAR (3) |
||
| EKPreisFreieMa | POPriceFreelancer NUMERIC(19,6) |
purchase price for freelancers | |
| EKPreisFreieMALoc | POPriceFreelancerLoc NUMERIC(19,6) |
||
| EKPreisFreieMAFw | POPriceFreelancerFC NUMERIC(19,6) |
||
| EinzelPreisManuell | POPriceManual SMALLINT (0=false,-1=true) |
purchase price set manual flag | |
| Beginn | TimeStart Datetime |
Start Time (only time from date relevant) | |
| Ende | TimeEnd Datetime |
End Time (only time from date relevant) | |
| BeginnFak | TimeStartInv Datetime |
Invoicable Start Time (only time from date relevant) | |
| EndeFak | TimeEndInv Datetime |
Invoicable end Time (only time from date relevant) | |
| RestStunden | RemainingHours NUMERIC(19,6) |
Remaining hours | |
| TAN | TAN INT Index |
-1=Error, >0 Link to MPFiBuPositionen | MPFiBuPositionen.TAN |
| TANUeb | TANOverTime INT |
Booking for overtime allocation | MPFiBuPositionen.TAN |
| LieferscheinID | DeliveryNoteID INT Index |
Linked sales delivery note position id | MPVKVertraegeBelegePositionen.MPBelPosID |
| FakturaID | InvoiceID INT Index |
Linked sales invoice position id | MPVKVertraegeBelegePositionen.MPBelPosID |
| EKLieferscheinID | PODeliveryNoteID INT Index |
Linked goods receipt PO position id | MPEKVertraegeBelegePositionen.MPBelPosID |
| EKFakturaID | POInvoiceID INT Index |
Linked A/P invoice position id | MPEKVertraegeBelegePositionen.MPBelPosID |
| Freigabe | ApprovalMode SMALLINT (0=false,-1=true) |
0=Entry,-1=Approved, 2=Draft,3=Cancled | |
| FreigegebenAm | ApprovedDate Datetime |
Approval Date | |
| FreigegebenID | ApprovedUser NVARCHAR (4) Index |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| FreigabeText | ApprovalText NTEXT |
||
| VorgesetztFreigabeAm | SuperiorApprovedDate Datetime |
||
| VorgesetztFreigabeID | SuperiorApprovedUser NVARCHAR (4) Index |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| VorgesetztFreigabeText | SuperiorApprovalText NTEXT |
||
| QuellTyp | SourceType INT |
Source 0:Standard, 1=MARIInterface, 2=Support Module, 3=Vacation Approval, 4=TimeTouch, 5=WorkItem | clsImportItemBooking_eSourceType |
| QuellReferenz | SourceReference INT |
Reference ID baed on the SourceType | |
| QuellReferenzPos | SourceReferencePos INT |
Detailed reference, when SourceReference is pointing to a header | |
| ArbeitspaketerfassungsID | WorkPackageEntryID INT Index |
MPProjektArbeitspaketerfassung.ArbeitspaketerfassungsID | |
| ErfassungsBerichtMA | TimeKeepingReportEmployee INT |
MPProjektBuchungserfassungBericht.ErfassungsBerichtID | |
| ErfassungsBerichtKunde | TimeKeepingReportCustomer INT |
MPProjektBuchungserfassungBericht.ErfassungsBerichtID | |
| WorkflowID | WorkFlowID INT Index |
MPHotlineWorkFlow.WorkFlowID | |
| CostAddOnCategory | CostAddOnCategory INT |
MPTimeBookingAddOnCategory.AddOnCategory | |
| ReiseAnfang | TravelStart Datetime |
||
| ReiseEnde | TravelEnd Datetime |
||
| ReiseZeit | TravelTime NUMERIC(19,6) |
||
| ReiseAnfangFak | TravelStartInv Datetime |
||
| ReiseEndeFak | TravelEndInv Datetime |
||
| ReiseZeitFak | TravelTimeInv NUMERIC(19,6) |
||
| ReiseZeitKostenFaktor | TravelTimeCostFactor NUMERIC(19,6) |
||
| UeberstundenZuschlag | OvertimeExtraHours NUMERIC(19,6) |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) Index |
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 Index |
MPDokumente.DocID | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPPersonenZeitenAktionen | Attendance: Actions "in the door" (Lines per day) |
| MPPersonenZeitenAktionenArchiv | Attendance: Actions "in the door" (Lines per day) History |
| MPProjektLeistungserfassung | 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 |