| View Name: | MARIPeriods |
| Based on table: | MPPerioden |
| 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 | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PeriodYear | Jahr SMALLINT |
||
| PeriodMonth | Periode SMALLINT Index |
||
| Period | PeriodeJahr INT Primary |
||
| DescriptionPeriod | BezeichnungPeriode NVARCHAR (40) |
||
| DescriptionPeriodLangID | BezeichnungPeriodeID INT |
||
| DescriptionYear | BezeichnungJahr NVARCHAR (7) |
||
| DescriptionShort | BezeichnungKurz NVARCHAR (5) |
||
| DescriptionShortLangID | BezeichnungKurzID INT |
||
| PeriodStart | Beginn Datetime |
||
| PeriodEnd | Ende Datetime |
||
| Blocked | Gesperrt SMALLINT |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIInfoScreenManagementBreakEvenCollection | Info Screen Management: Breakeven Analysis (Export Header) |
| MARIPurchaseImportDocument | Purchase Order: Import external documents (Header) |
| MARIPurchaseProcess | Purchase Process: Header |
| MARIPurchaseProcessDocument | Purchase Process: Purchase Document (Header) |
| MARIPurchaseProcessPositionAccounting | Purchase Process: Accounting lines (due date, phase ...) |
| MARIPurchaseProcessPaymentPlan | Purchase Process: Payment plan (not used in PO) |
| MARIWorkInProgress | Work In Progress: Header (one line per project and month) |
| MARIWorkInProgressLines | Work In Progress: calculated lines |
| MARIJournalEntryImportStack | Journal Entry Import Flaggs |
| MARIJournalEntryExport | Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress) |
| MARIJournalEntryExportCancel | Journal Entries Canceled Records (Travel Expenses, Internal Service Charges, Work in Progress) |
| MARICalendarPeriod | Calendar Management: Calendar Month (Period) |
| MARICalendarDays | Calendar Management: Calendar Day Definition |
| MARIPayrollStack | Payroll Interface: Export Header |
| MARIPayrollLine | Payroll Interface: Export Lines |
| MARIPeriodsExchangeRates | Calendar Management: Monthly currency exchange rates |
| MARIEmployeesTravelMilage | Employee Master: Linked mileage allowances |
| MARIEmployeesOrganisation | Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period |
| MARIEmployeesPeriod | Employee Master: One line per employee and valid from period and business unit |
| MARIEmployeesPool | Employee Master: Employee Pool link |
| MARIEmployeesTrip2TravelMilage | Travel Expenses Module: Employee Mileage type (header) |
| MARIEmployeesTrip2TravelMilageSub | Travel Expenses Module: Employee Mileage type (sub) |
| MARIEmployeeVacationRequest | Vacation Management: Vacation Request and Approval |
| MARIEmployeeAnnualVacation | Employee Master: Vacation Management Annual Vacation |
| MARIEmployeeCostRates | Employee Master: Cost Rates |
| MARIEmployeeCostRatesProject | Employee Master: Cost Rates per project for freelancers |
| MARIAttendanceRule | Attendance: Working Time rules (Header valid from) |
| MARIAttendanceRuleDays | Attandence: Actions "in the door" (Day header) |
| MARIPriceIndexHeader | Maintenance: Price Index Protocol of wizard (Header) |
| MARIPriceIndexPeriod | Maintenance: Price Index per month |
| MARIProjectItemBooking | 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 |
| MARIProjectBookingErrors | Time Keeping: Error log in the time keeping |
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MARIProjectTimeKeepingHeader | 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). |
| MARIProjectPhaseEmployeeFeedback | Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion |
| MARIProjectPlanningVersions | Project Master: Planning versions linked to a project |
| MARIProjectPlanningLines | Planning: Master Planning lines |
| MARIProjectStatus | Project Master: status history |
| MARITravelTrip | Travel Expenses Module: Business Trip Master |
| MARITravelPostingDocument | Travel Expenses Module: Posting document |
| MARITravelAccountingHeader | Travel Expenses Module: Accounting Header |
| MARITravelTemplateVersion | Travel Expenses Module: Template by "period from" |
| MARITravelTripLine | Travel Expenses Module: Trip receipt line |
| MARIResourcePoolCostRates | Resource Pool: Cost Rates |
| MARISettingsBusinessUnitAccountingVersion | Internal Service Changes: Setting of type BU vs. BU |
| MARISettingsBusinessUnitMatrix | Master Data: Settings by business unit in matrix |
| MARISettingsCompanyMatrix | Master Data: Settings by company in matrix |
| MARISimulation | Plannings Simulator: Master Table |
| MARISimulationData | Plannings Simulator: Data of dimensions |
| MARISimulationDataHistory | Plannings Simulator: Data of old simulations |
| MARITempReportCalendar | Reporting: Temporary Table: Calendar |
| MARITempReportProjectPhaseService | Reporting: Temporary Table: Project Phase Service |
| MARITempReportProjectPhase | Reporting: Temporary Table: Project Phase Report |
| MARIContract | Contract Management: Contract Master Data + Service Master Data |
| MARIContractDocument | Contract Management: Sales Documents |
| MARIContractPositionPayment | Contract Management: Contract positions accounting lines (due date, phase ...) |
| MARIContractInstallmentPlan | Contract Management: Contract Invoicing plan |
| MARIPurchaseProcessDocumentISCHead | Purchase Process: Document Internal Service Change Head |
| MARIContractDocumentISCHead | Contract Management: Document Internal Service Charges Head |
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MARIProjectMasterWorkInProgess | Project Master: Save degree of compleation for each month |
| MARIPeriodsCalendarWeeks | Calendar Management: CalendarWeeks by ISO |
| MARIWorkInProgressValues | Work In Progress: Store Column Values |
| MARIDocumentDraftHead | Header for the draft document |
| MARICommissionAccrual | Commission: Stores the Accrual on Sales Invoicing Time (Project related) |
| MARICommissionAccrualSBO | Commission: Stores the Accrual on Sales Invoicing Time (None Project related) |
| MARIProjectTimeKeepingReport | Time Keeping: Link Week Report of employee or for customer |
| MARIProjectPlanningLinesLog | Planning: Master Planning lines History |
| MARIProjectTimeKeepingLinesAddOnCategory | Time Keeping: AddOnCategoryDetails |
| MARICommissionAccrualPeriods | Commission: Monthly values for employee commission |
| MARIEmployeesCommissionSettings | Employee Master: Standard Settings for Commission by Employee |
| MARIChefInfoDashboard | Project Dash Board Settings |
| MARIPayrollLineAttachment | Payroll Interface: Export Lines Source Details |
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day |
| MARIJournalEntryExportDocument | Journal Entries Export Document Head |
| MARIResourcePoolBPTeamCostRates | Cost rates for external resource team |