| Table Name: | MPPerioden |
| View Name: | MARIPeriods |
| Group: | Group: Periods |
| Description: | Calendar Management: Periods in the project management solution: They can vary from SBO periods, because the project management tool needs more periods in the future |
| ClassID: | 31. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Jahr | PeriodYear SMALLINT |
||
| Periode | PeriodMonth SMALLINT Index |
||
| PeriodeJahr | Period INT Primary |
||
| BezeichnungPeriode | DescriptionPeriod NVARCHAR (40) |
||
| BezeichnungPeriodeID | DescriptionPeriodLangID INT |
||
| BezeichnungJahr | DescriptionYear NVARCHAR (7) |
||
| BezeichnungKurz | DescriptionShort NVARCHAR (5) |
||
| BezeichnungKurzID | DescriptionShortLangID INT |
||
| Beginn | PeriodStart Datetime |
||
| Ende | PeriodEnd Datetime |
||
| Gesperrt | Blocked SMALLINT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| InAktiv | Inactive SMALLINT (0=false,-1=true) |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPChefInfoDashboard | Project Dash Board Settings |
| MPCommissionAccrual | Commission: Stores the Accrual on Sales Invoicing Time (Project related) |
| MPCommissionAccrualPeriods | Commission: Monthly values for employee commission |
| MPCommissionAccrualSBO | Commission: Stores the Accrual on Sales Invoicing Time (None Project related) |
| MPDBCollection | Info Screen Management: Breakeven Analysis (Export Header) |
| MPDocumentDraftHead | Header for the draft document |
| MPEKFremdBelegErfassung | Purchase Order: Import external documents (Header) |
| MPEKVertraege | Purchase Process: Header |
| MPEKVertraegeBelege | Purchase Process: Purchase Document (Header) |
| MPEKVertraegeBelegeILVKopf | Purchase Process: Document Internal Service Change Head |
| MPEKVertraegePositionenAkd | Purchase Process: Accounting lines (due date, phase ...) |
| MPEKVertraegeZahlungsplan | Purchase Process: Payment plan (not used in PO) |
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPFiBuBewertungen | Work In Progress: Header (one line per project and month) |
| MPFiBuBewertungenWerte | Work In Progress: Store Column Values |
| MPFiBuBewertungenZeilen | Work In Progress: calculated lines |
| MPFibuImportStapel | Journal Entry Import Flaggs |
| MPFiBuPositionen | Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress) |
| MPFibuPositionenBeleg | Journal Entries Export Document Head |
| MPFiBuPositionenStorno | Journal Entries Canceled Records (Travel Expenses, Internal Service Charges, Work in Progress) |
| MPKalenderPeriode | Calendar Management: Calendar Month (Period) |
| MPKalenderTage | Calendar Management: Calendar Day Definition |
| MPLohnStapel | Payroll Interface: Export Header |
| MPLohnZeile | Payroll Interface: Export Lines |
| MPLohnZeileAnhang | Payroll Interface: Export Lines Source Details |
| MPPeriodenKurse | Calendar Management: Monthly currency exchange rates |
| MPPeriodenKW | Calendar Management: CalendarWeeks by ISO |
| MPPersonenFahrzeugarten | Employee Master: Linked mileage allowances |
| MPPersonenOrganisation | Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period |
| MPPersonenPeriode | Employee Master: One line per employee and valid from period and business unit |
| MPPersonenPool | Employee Master: Employee Pool link |
| MPPersonenProvisionsEinstellungen | Employee Master: Standard Settings for Commission by Employee |
| MPPersonenReise2Fahrz | Travel Expenses Module: Employee Mileage type (header) |
| MPPersonenReise2FahrzSub | Travel Expenses Module: Employee Mileage type (sub) |
| MPPersonenUrlaubsAntrag | Vacation Management: Vacation Request and Approval |
| MPPersonenUrlaubsplan | Employee Master: Vacation Management Annual Vacation |
| MPPersonenVerrechnung | Employee Master: Cost Rates |
| MPPersonenVerrechnungProjekt | Employee Master: Cost Rates per project for freelancers |
| MPPersonenZeitenRegel | Attendance: Working Time rules (Header valid from) |
| MPPersonenZeitenTage | Attandence: Actions "in the door" (Day header) |
| MPPreisIndexLauf | Maintenance: Price Index Protocol of wizard (Header) |
| MPPreisIndexPeriode | Maintenance: Price Index per month |
| MPProjektArbeitspaketerfassung | Work Packages progress reporting by day |
| MPProjektArtikelerfassung | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf |
| MPProjektBuchungFehler | Time Keeping: Error log in the time keeping |
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MPProjektBuchungserfassungBericht | Time Keeping: Link Week Report of employee or for customer |
| MPProjektBuchungserfassungZuschlaege | Time Keeping: AddOnCategoryDetails |
| MPProjektBuchungskopf | Time Keeping: ProjectTimeKeepingHeader: One line per employee and period. This header table indicates the booking month of time sheet entries. (no project information is stored). |
| MPProjektPhasenMeldung | Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion |
| MPProjektPlanungsversion | Project Master: Planning versions linked to a project |
| MPProjektPlanungsZeilen | Planning: Master Planning lines |
| MPProjektPlanungsZeilenLog | Planning: Master Planning lines History |
| MPProjektstammWIP | Project Master: Save degree of compleation for each month |
| MPProjektstatus | Project Master: status history |
| MPReise2 | Travel Expenses Module: Business Trip Master |
| MPReise2BuchungBeleg | Travel Expenses Module: Posting document |
| MPReise2BuchungKopf | Travel Expenses Module: Accounting Header |
| MPReise2TemplateVersion | Travel Expenses Module: Template by "period from" |
| MPReise2Zeile | Travel Expenses Module: Trip receipt line |
| MPRessourcenGPTeamKostensaetze | Cost rates for external resource team |
| MPRessourcenPoolKostensaetze | Resource Pool: Cost Rates |
| MPSetupGBSettingsBuchungsVariante | Internal Service Changes: Setting of type BU vs. BU |
| MPSetupGBSettingsMatrix | Master Data: Settings by business unit in matrix |
| MPSetupMandantSettingsMatrix | Master Data: Settings by company in matrix |
| MPSimulation | Plannings Simulator: Master Table |
| MPSimulationDaten | Plannings Simulator: Data of dimensions |
| MPSimulationDatenHistory | Plannings Simulator: Data of old simulations |
| MPTmpRptKalender | Reporting: Temporary Table: Calendar |
| MPTmpRptProjektPhaseLeistung | Reporting: Temporary Table: Project Phase Service |
| MPTmpRptProjektPhasenBericht | Reporting: Temporary Table: Project Phase Report |
| MPVKVertraege | Contract Management: Contract Master Data + Service Master Data |
| MPVKVertraegeBelege | Contract Management: Sales Documents |
| MPVKVertraegeBelegeILVKopf | Contract Management: Document Internal Service Charges Head |
| MPVKVertraegePositionenAkd | Contract Management: Contract positions accounting lines (due date, phase ...) |
| MPVKVertraegeZahlungsplan | Contract Management: Contract Invoicing plan |