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