MARIProject Database Structure


Table English Description
MPAccoutingProfitCenterPlanningLine AccountingProfitCenterPlanningLine Store the financial planning on profit center level per month
MPAccoutingProfitCenterPlanningYear AccountingProfitCenterPlanningYear Store the financial planning on profit center level per year
MPAdressen Addresses Business Partner: Used only for synchronization with other databases
MPAdressenKennzeichen AddressProperties Additional Data for OCRD
MPAnsprechpartner ContactPerson Contact Person: Used only for synchronization with other databases
MPArbeitspaket WorkPackage

Workpackages desribe combinations of time an material, invoice do the customer in qm, cubic meter

The table MPVKVertrage with VertragsArt=22 will be used to store the company link

The table MPVKVertragePositionen will be used to store the itemcodes/Services and detailed settings
MPArtikelGruppenKennzeichen ItemGroupProperties Item Groups: Additional fields for maintenance and purchase order
MPArtikelKennzeichen ItemProperties Item Master: Additional fields for maintenance and purchase order
MPAuswertungEigenschaften InfoSimulationSettings Plannings Simulator: Settings
MPAuswertungGeschaeftsbereiche InfoSimulationBusinessUnits Plannings Simulator: Dimension Business Unit
MPAuswertungGeschaeftsbereicheMA InfoSimulationBusinessUnitsEmployees Plannings Simulator: Dimension Business Unit / Employees
MPAuswertungGruppen InfoSimulationGroups Plannings Simulator: Dimension Groups
MPAuswertungKopf InfoSimulationHead Plannings Simulator: Header
MPAuswertungProjekte InfoSimulationProjects Plannings Simulator: Dimension Projects
MPAuswertungProjekteMA InfoSimulationProjectEmployees Plannings Simulator: Dimension Projects/Employees
MPAuswertungRessourcen InfoSimulationResources Plannings Simulator: Dimension Resources
MPAuswertungRessourcenMA InfoSimulationResourcesEmpoyees Plannings Simulator: Dimension Resources/Employees
MPBankverbindungen BankAccounts Bank Accounts: Used only for synchronization with other databases
MPBelegeEmpfaenger DocumentRecipient Definition of eMail Recipients for documents out of a contract.
MPBenutzer User ProjectManagement User + Customer Portal User
MPBenutzerERP UserCompanyLogin ProjectManagement User Link to SBO Users
MPBenutzerGeschaeftsbereiche UserBusinessUnits ProjectManagement User Athorization to Business Units
MPBenutzergruppen UserGroups ProjectManagement: User Groups
MPBenutzerLog UserLog User Log for each login and logoff
MPBenutzerMandantenSicht UserCompanyVisibility User Company Visibility
MPBenutzerScanLog UserBarCodeScanLog User Barcode Scan Log for all single scans
MPBerechtigungen FormAuthorization Authorization for each form and report
MPBilder Pictures Images linked to support issues, employees...
MPBilderVersionen PicturesVersions Revisions of the pirctures
MPBuch Book Project Dokumentation: Book Header
MPBuchArchiv BookArchive Project Dokumentation: Archived Book Content
MPBuchdruck BookPrint Project Dokumentation: Print Defnition Head
MPBuchdruckAnhaenge BookPrintAttachments Project Dokumentation: Print Defnition AttachementSelection
MPBuchdruckInhalt BookPrintSequence Project Dokumentation: Print Action Head
MPBuchdruckInhaltSeitenElemente BookPrintSequenceElements Project Dokumentation: Print Action PageElementPrintLines
MPBuchdruckInhaltsVerzeichnis BookPrintTableOfContent Project Dokumentation: Print Action Table of Content
MPBuchdruckMappen BookPrintFolder Project Dokumentation: Print Defnition Linked Folder Documents
MPBuchdruckSeiten BookPrintPages Project Dokumentation: Print Defnition Book pages
MPBuchEigenschaften BookProperties Project Dokumentation: Book Properties
MPBuchEigenschaftenArchiv BookPropertiesArchive Project Dokumentation: Book Archived Properties
MPBuchEigenschaftenUser BookPropertiesUser Project Dokumentation: Book User Properties
MPBuchLayout BookLayout Project Dokumentation: Layout Definition of a content element
MPBuchLink BookLink Project Dokumentation: externale links to pages
MPBuchLinkArchiv BookLinkArchive Project Dokumentation: externale link archive
MPBuchSeite BookPage Project Dokumentation: Book Page (Left hierarchy)
MPBuchSeitenArchiv BookPageArchive Project Dokumentation: Book Page Archive (Left hierarchy)
MPBuchSeitenElement BookPageElements Project Dokumentation: Book Page Content Element
MPBuchSeitenElementArchiv BookPageElementArchive Project Dokumentation: Book Page Content Element Archive
MPBuchSeitenFreigabe BookPageApproval Project Dokumentation: Book Page Approval Flow
MPBuchSeitenInhalt BookPageContent Project Dokumentation: Book Page Content Data
MPBuchSeitenInhaltArchiv BookPageContentArchive Project Dokumentation: Book Page Content Data Archive
MPChefInfoAuswertungenData InfoScreenManagementData Info Screen Management: Export Data
MPChefInfoAuswertungenKey InfoScreenManagementKey Info Screen Management: Export Keys
MPChefInfoAuswertungenKopf InfoScreenManagementHead Info Screen Management: Export Header
MPChefInfoAuswertungenMA InfoScreenManagementEmployee Info Screen Management: Export Employees
MPChefInfoAuswertungenPool InfoScreenManagementPool Info Screen Management: Export Pools
MPChefInfoAuswertungenProjekt InfoScreenManagementProject Info Screen Management: Export Projects
MPChefInfoCashFlowRun ChefInfoCashFlowRun Info Screen Management: Daily cash flow run
MPChefInfoCashFlowRunLine ChefInfoCashFlowRunLine Info Screen Management: Stored line data per run
MPChefInfoCashFlowRunProject ChefInfoCashFlowRunProject Info Screen Management: Status of a project
MPChefInfoChart ChefInfoChart Info Screen Management: Status Settings for chart design
MPChefInfoChartCol ChefInfoChartCol Info Screen Management: Status Settings for chart design Columns and data sources
MPChefInfoDashboard ChefInfoDashboard Project Dash Board Settings
MPChefInfoDashboardTiles ChefInfoDashboardTiles Project Dash Board Settings Tiles
MPChefInfoUserColumn InfoScreenManagementUserColumn Info Screen Management: User-defined column settings
MPChefInfoUserColumns InfoScreenManagementUserColumns Info Screen Management: User-defined columns
MPChefInfoUserStore InfoScreenManagementUserStore Info Screen Management: Store filter settings (Header)
MPChefInfoUserStoreOptions InfoScreenManagementUserStoreOptions Info Screen Management: Store filter settings (Line)
MPChefInfoUserTree InfoScreenManagementUserTree Info Screen Management: Store tree selection
MPChefInfoUserView InfoScreenManagementUserView Info Screen Management: Store selected analysis
MPCommissionAccrual CommissionAccrual Commission: Stores the Accrual on Sales Invoicing Time (Project related)
MPCommissionAccrualPeriods CommissionAccrualPeriods Commission: Monthly values for employee commission
MPCommissionAccrualSBO CommissionAccrualSBO Commission: Stores the Accrual on Sales Invoicing Time (None Project related)
MPCommissionDocumentPositions CommissionDocumentPositions Commission: Sales Rep A/P Invoice Position Link
MPCommissionDocuments CommissionDocuments Commission: Sales Rep A/P Invoice Link
MPCommissionTypeRules CommissionTypesRules Commission: Percentage Definition
MPCommissionTypes CommissionTypes Commission: Basic Settings for different Types
MPCommissionWizardLog CommissionWizardLog Commission: Log of the usage
MPContractCalculation ContractCalculation Cotnract Sales Prices Calculation Method Head
MPContractCalculationFields ContractCalculationFields Cotnract Sales Prices Calculation Method Fields
MPCreditCardMapping CreditCardMapping Stores Credit Card Information to Business Partner and Employees for CreditCard Import
MPCustomerEquipmentCard CustomerServiceObject Advanced table to sbo standard customer equipment card
MPCustomerEquipmentCardCategory CustomerServiceObjectCategory Group to manage properties by group
MPCustomerEquipmentLocation CustomerServiceObjectLocation Current location of a CSO at the client/Project
MPCustomerLocationTree CustomerLocationTree Name of the location tree
MPCustomerLocationTreeElement CustomerLocationTreeElement Tree elements to manage levels, rooms of the customer
MPCustomerLocationTreeLink CustomerLocationTreeLink Link of a customer and a user to a tree or an element of the tree
MPDBAuswertungen InfoScreenManagementBreakEven Info Screen Management: Breakeven Analysis (Header)
MPDBAuswertungenPos InfoScreenManagementBreakEvenPos Info Screen Management: Breakeven Analysis (Lines)
MPDBAuswertungenPosKto InfoScreenManagementBreakEvenAccounts Info Screen Management: Breakeven Analysis (Accounts)
MPDBAuswertungenSettings InfoScreenManagementBreakEvenSettings Info Screen Management: Breakeven Analysis (Settings for Cash Flow)
MPDBCollection InfoScreenManagementBreakEvenCollection Info Screen Management: Breakeven Analysis (Export Header)
MPDBCollectionItems InfoScreenManagementBreakEvenCollectionItems Info Screen Management: Breakeven Analysis (Export Line)
MPDBColumnsDefinition InfoScreenManagementBreakEvenColumnHead Info Screen Management: Column Definition Head
MPDBColumnsDefinitionCol InfoScreenManagementBreakEvenColumnDef Info Screen Management: Column Definition Columns
MPDocApproval DocApproval Approval Process Definition
MPDocApprovalLink DocApprovalLink Special Approval Rules per contract
MPDocApprovalRessource DocApprovalRessources Steps in the approval process. Rule Lines (Steps) for each approval prioritry. The rules are used from top (Priority=0) to button.
MPDocApprovalRessourceSub DocApprovalRessourcesSub Store 1:n the Receipients for serial or chain approvals
MPDocumentDraftHead DocumentDraftHead Header for the draft document
MPDocumentDraftHeadApproval DocumentDraftHeadApproval Approval or workflow list for the draft document
MPDocumentDraftHeadLink DocumentDraftHeadLink Linked contracts and purchase processes
MPDocumentDraftInstallments DocumentDraftInstallments Payment conditions and installments
MPDocumentDraftPosition DocumentDraftPosition Positions based on the order of the paper document
MPDocumentDraftPositionLink DocumentDraftPositionLink Linked positions in the sales contract and or purchase process
MPDocumentDraftPositionLinkBatch DocumentDraftPositionLinkBatch Used batches
MPDocumentDraftPositionLinkSerial DocumentDraftPositionLinkSerial Used/reserved serial numbers
MPDocumentDraftPositionLinkTax DocumentDraftPositionTax Positions based on the order of the paper document sub tax
MPDocumentDraftPositionTax DocumentDraftPositionLinkTax Linked positions in the sales contract and or purchase process sub tax
MPDocumentDraftTax DocumentDraftTax Tax information
MPDocumentInvoiceFlow DocumentInvoiceFlow InvoicePaymentReportStore
MPDocumentInvoiceFlowPosition DocumentInvoiceFlowPosition InvoicePaymentReportStore Positions
MPDocValidation DocValidation Validation rule for A/P invoices based on the linked purchase order
MPDocValidationResource DocValidationResource Validation rule details for A/P invoices based on the linked purchase order
MPDokumente Documents Documents linked in the Folder tabs of the master data
MPDokumenteVersionen DocumentsVersions Revision History of a document
MPEinheiten Units Unit of measurement basic setting
MPEKFremdBelegErfassung PurchaseImportDocument Purchase Order: Import external documents (Header)
MPEKFremdBelegErfassungPos PurchaseImportDocumentPos Purchase Order: Import external documents (Line)
MPEKFremdBelegErfassungPos2EKPos PurchaseImportDocumentPos2POProcessPos Purchase Order: Import external documents (Link to PO Process lines)
MPEKVertraege PurchaseProcess Purchase Process: Header
MPEKVertraegeAnzahlungen PurchaseProcessDownPayments Purchase Process: Down Payments
MPEKVertraegeBelege PurchaseProcessDocument Purchase Process: Purchase Document (Header)
MPEKVertraegeBelegeAnhaenge PurchaseProcessDocumentAttachments Purchase Process: Link to Attachments
MPEKVertraegeBelegeDruck PurchaseProcessDocumentPrint Purchase Process: Print history
MPEKVertraegeBelegeEInvoice PurchaseProcessDocumentEInvoice Purchase Process: Extra Information peparing an electronic document
MPEKVertraegeBelegeFehler PurchaseProcessDocumentError Purchase Process: Saved Errors
MPEKVertraegeBelegeFreigabe PurchaseProcessDocumentApproval Purchase Process: Document Approval Employee Link
MPEKVertraegeBelegeILVKopf PurchaseProcessDocumentISCHead Purchase Process: Document Internal Service Change Head
MPEKVertraegeBelegeILVPos PurchaseProcessDocumentISCPos Purchase Process: Document Internal Service Change Positions
MPEKVertraegeBelegeILVPosSteuer PurchaseProcessDocumentISCPosTax Purchase Process: Document Internal Service Change Positions Tax
MPEKVertraegeBelegePositionen PurchaseProcessDocumentPositions Purchase Process: Purchase Document (Positions)
MPEKVertraegeBelegePositionenCharge PurchaseProcessDocumentPositionsBatches Purchase Process: Purchase Document (Positions+Batches)
MPEKVertraegeBelegePositionenSerie PurchaseProcessDocumentPositionsSerialNumbers Purchase Process: Purchase Document (Positions+Serial)
MPEKVertraegeBelegePositionenSteuer PurchaseProcessDocumentPositionsTax Purchase Process: Purchase Document (Positions+Tax)
MPEKVertraegeBelegeSteuer PurchaseProcessDocumentTax Purchase Process: Purchase Document (Tax)
MPEKVertraegeBelegeZKD PurchaseProcessDocumentInstallments Purchase Process: Purchase Document (Payment conditions)
MPEKVertraegeBelegeZuordnung PurchaseProcessDocumentLink Purchase Process: Purchase Document Link to down payments
MPEKVertraegeCommission PurchaseProcessDocumentCommision Purchase Process: Purchase Document Bonus definition
MPEKVertraegeCommissionPos PurchaseProcessDocumentCommisionPos Purchase Process: Purchase Document Bonus position definition
MPEKVertraegeERDefinition PurchaseProcessReturnRevenueDefinition Purchase Process: Revenue Return Account Definition (not used in PO)
MPEKVertraegePos2BelPos PurchaseProcessPosDocPosLink Purchase Process: Link between PO document line and PO process position
MPEKVertraegePos2Service PurchaseProcessPos2Service Purchase Process: Link Position to Customer Service Object or parts
MPEKVertraegePositionen PurchaseProcessPositions Purchase Process: PO Process Position (equivilant to contract position)
MPEKVertraegePositionenAkd PurchaseProcessPositionAccounting Purchase Process: Accounting lines (due date, phase ...)
MPEKVertraegePositionenDef PurchaseProcessPositionDefinition Purchase Process: Definition of extra fields by position type
MPEKVertraegePositionenEquipment PurchaseProcessPositionEquipment Purchase Process: Equipment linked to a position
MPEKVertraegePositionenPers PurchaseProcessPositionEmployees Purchase Process: Employees linked to a position
MPEKVertraegePositionenPhasen PurchaseProcessPositionPhases Purchase Process: Phases linked to a position
MPEKVertraegePositionenTexte PurchaseProcessPositionTextelements Purchase Process: Text definition (master data) for positions
MPEKVertraegeTexte PurchaseProcessText Purchase Process: Text definition (master data) for header, footer
MPEKVertraegeZahlungsplan PurchaseProcessPaymentPlan Purchase Process: Payment plan (not used in PO)
MPEKVertraegeZKD PurchaseProcessInstallments Purchase Process: Installment Plan
MPEquipment EquipmentMaster Equipment: Master Data for each individual Equipment
MPEquipmentCategory EquipmentCategory EquipmentCategory: Cagetory Master
MPEquipmentCategoryBPCatalog EquipmentCategoryBPCatalog EquipmentCategory: Business Partner Catalog Number
MPEquipmentCategorySubject EquipmentCategorySubject EquipmentCategory: Standard cost types for categories
MPEquipmentCategorySubjectRates EquipmentCategorySubjectRates EquipmentCategory: Standard cost and sales prices for the cost types of categories
MPEquipmentDetails EquipmentDetails Equipment: Master Data "date from" based
MPEquipmentDetailsLink EquipmentDetailsLink Equipment Assembly: List of inner components
MPEquipmentDetailsSerial EquipmentDetailsSerial Equipment: Master Data "Date from" based serial numbers
MPEquipmentLocation EquipmentLocation Equipment: Current Location of this equipment
MPEquipmentReminder EquipmentReminder Equipment: recurrent dates for each equipment
MPEquipmentSubjectBooking EquipmentSubjectBooking Time/Costbooking on Equipment data
MPEquipmentSubjectRates EquipmentSubjectRates Equipment: Specific cost rates
MPEquipmentSubjectRatesBU EquipmentSubjectRatesBU Equipment: Specific cost and sales rates for internal service charges
MPExchangeSync MPExchangeSync MS Exchange Server Link Log
MPExchangeSyncLine MPExchangeSyncLine MS Exchange Server Link Planning Line
MPFiBuBewertungen WorkInProgress Work In Progress: Header (one line per project and month)
MPFiBuBewertungenWerte WorkInProgressValues Work In Progress: Store Column Values
MPFiBuBewertungenZeilen WorkInProgressLines Work In Progress: calculated lines
MPFibuBuchungsautomatRegel JournalEntryISCRule Definitions for Internal Service Charge Wizard
MPFibuBuchungsautomatRegelZeilen JournalEntryISCRuleLine Definitions for Internal Service Charge Wizard Lines
MPFibuImportStapel JournalEntryImportStack Journal Entry Import Flaggs
MPFiBuPositionen JournalEntryExport Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress)
MPFibuPositionenBeleg JournalEntryExportDocument Journal Entries Export Document Head
MPFiBuPositionenStapel JournalEntryExportBatch Journal Entries Header Table per run
MPFiBuPositionenStorno JournalEntryExportCancel Journal Entries Canceled Records (Travel Expenses, Internal Service Charges, Work in Progress)
MPGebinde Container Definition of a container carrying other goods
MPGebindeAdresse ContainerAddress Addtional information for trucks as container for shipping
MPGebindeKategorie ContainerCategory Container Categtrory to manage special settings
MPGebindeLocation ContainerLocation Current location of a container
MPGebindeZeile ContainerLine Container Lines to see the goods in the container
MPGebindeZeileSerieCharge ContainerBatchSN Linked batches of serialnumbers for a line in the container
MPGruppen Groups Groups used for a long list of master data. See the GruppenArt enumeration
MPGruppenEquipment GroupsEquipment Groups for Equipment and EquipmentCategories
MPHotlineAnfrage SupportIssue Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks The type of ticket is defined by the field HotlineClassType.
DimensionHotlineClassType
Support Ticket17
Task676
Idea677
Development Task678
HR Task679
MPHotlineAnfrageAnhang SupportIssueLine Support Module: Issue tracking: Issue line for comments, documents, emails, etc.
MPHotlineAnfrageEmpfaenger SupportIssueRecipients Support Module: Issue tracking: Linked email recipients
MPHotlineAnfrageFreigabe SupportIssueApproval Support Module: Store the approval steps for a ticket
MPHotlineAnfrageIndex SupportIssueIndex Support Module: store key words from external keyword tool
MPHotlineAnfrageKeywording SupportIssueKeywording Support Module: Split content in key words to find equal tickets
MPHotlineAnfrageKeywords SupportIssueKeywords Support Module: Global list of keywords for all tickets
MPHotlineAnfrageLink SupportIssueLink Support Module: Link a ticket to other core data (CSO, Equipment)
MPHotlineAnfrageLog SupportIssueChangeLog Support Module: Issue tracking: Issue change log
MPHotlineAnfrageModule SupportIssueModules Support Module: Issue tracking: Issue linked modules
MPHotlineAnfrageVersionen SupportIssueVersions Support Module: Issue tracking: Issue linked versions
MPHotlineClassType SupportClassType Support Module: Settings by class type (Ticket, Task, Idea, DevTask, HR Task)
MPHotlineClassTypeForms SupportClassTypeForms Support Module: Setting for the master forms to show the Ticket tab
MPHotlineGruppe SupportGroup Support Module: Support Group: Header
MPHotlineGruppeMandant SupportGroupCompany Support Module: Support Group: E-Mail settings by company
MPHotlineGruppeMitarbeiter SupportGroupEmployee Support Module: Support Group: Linked employees
MPHotlineMap SupportGroupingMap Support Module: Self organzing the tickets
MPHotlineMapTree SupportGroupingMapTree Support Module: Self organzing the tickets in lines
MPHotlineProdukt SupportProduct Support Module: Support Product: Master Data
MPHotlineProduktBetrachter SupportProductListener Support Module: Customers/Users to be informed for changes
MPHotlineProduktKunde SupportProductCustomer Support Module: Support Product: Customer Product Link
MPHotlineProduktKundeBelege SupportProductDocuments Support Module: Support Product: Linked invoice documents
MPHotlineProduktKundeEmpfaenger SupportProductCustomerRecipients Support Module: Default for the ticket recipient list
MPHotlineProduktKundeLizenz SupportProductCustomerLicenses Support Module: Support Product: License files by customer
MPHotlineProduktKundeModul SupportProductCustomerModules Support Module: Support Product: Customer Product Link: Modules
MPHotlineProduktModul SupportProductModules Support Module: Support Product: Master Data Modules
MPHotlineProduktModulVersion SupportProductModuleVersions Support Module: Support Product: Master Data Versions for Modules
MPHotlineProduktVersion SupportProductVersions Support Module: Support Product: Master Data Versions
MPHotlineRuleSet SupportTicketRuleSet Support Module: Routing Set for blanc email input
MPHotlineRuleSetLine SupportTicketRuleSetLine Support Module: Routing Set for blanc email input - Step
MPHotlineRuleSetLineStep SupportTicketRuleSetLineStep Support Module: Routing Set for blanc email input - Condition line for each step
MPHotlineSettings SupportSettings Support Module: Settings for the Status, Priority, Mode etc. of hottline issues
MPHotlineSettingsClassType SupportSettingsClassType Support Module: Selection of setting by the HotlineClassType (Ticket, Task, Idea, DevTask, HR Task)
MPHotlineSLA SupportSLA Support Module: Service Level Agreement Master
MPHotlineSLANotification SupportSLANotification Support Module: Service Level Agreement Notifications
MPHotlineSLASettings SupportSLASettings Support Module: Service Level Agreement Settings
MPHotlineSyncMapping SupportSyncMapping Support Module: Mapping dimensions for synchronization
MPHotlineSyncPartner SupportSyncPartner Support Module: Synchronizaion settings
MPHotlineVertraege SupportContracts Support Module: Support Contracts (not used)
MPHotlineWorkFlow SupportWorkflow Support Module: Workflow definition for the status
MPHotlineWorkFlowSettings SupportWorkflowSettings Support Module: Workflow definition for the status details
MPHotlineWorkFlowTransition SupportWorkflowTransition Support Module: Workflow definition for the status transition
MPInterfaceImportLog InterfaceImportLog Logging of MARIInterface Messages and action
MPKalender Calendar Calendar Management: Calendar Header
MPKalenderPeriode CalendarPeriod Calendar Management: Calendar Month (Period)
MPKalenderTage CalendarDays Calendar Management: Calendar Day Definition
MPKalenderTagesVorlagen CalendarDayPresets Calendar Management: Stadard for Monday,Tuesday..
MPKalenderTemplate CalendarTemplates Calendar Management: Public Holiday Rules
MPKalenderTemplateTage CalendarTemplateDays Calendar Management: Public Holiday Rules per Day
MPKBArtikel KnowledgeBaseEntry Support Module: Knowledge Base Header
MPKBArtikelReferenz KnowledgeBaseEntryReference Support Module: Knowledge Base Product link
MPKBArtikelSchlagworte KnowledgeBaseEntryKeyWords Support Module: Knowledge Base Key Words
MPKBArtikelSprache KnowledgeBaseEntryLanguage Support Module: Knowledge Base Languages
MPKontoauszuege BankStatement Header of a bank statement like OBNH
MPKontoauszuegeZeilen BankStatementLine Booking line of a bank statement
MPLeistung Services

Service Master: Master Data Header Line (Without company assignment)

The table MPVKVertrage with VertragsArt=6 will be used to store the company link

The table MPVKVertragePositionen will be used to store the itemcodes and detailed settings
MPLeistungPool ServicePools Service Master: Master Data Pool link
MPLocation Location Location: Place (India Localization)
MPLocationCompany LocationCompany Location: Link to locations in SBO database (India Localization)
MPLocationDistance LocationDistance Distance between locations
MPLohnArten PayrollTypes Payroll Interface: Payroll Types Master Data by company
MPLohnArtenKategorie PayrollTypeGroup Payroll Interface: Payroll Types Master Data global
MPLohnArtenKategorieMandant PayrollTypeGroupLink Payroll Interface: Payroll Types Link
MPLohnSettings PayrollSettings Payroll Interface: Payroll Types Settings
MPLohnStapel PayrollStack Payroll Interface: Export Header
MPLohnZeile PayrollLine Payroll Interface: Export Lines
MPLohnZeileAnhang PayrollLineAttachment Payroll Interface: Export Lines Source Details
MPMAProtokol EmployeeProtocol Error Message Protocol
MPMSPDatabases MSProjectDatabases MS Project Interface: Database Link (MSP Server)
MPMSPImports MSProjectImports MS Project Interface: Import log
MPMSPMitarbeiter MSProjectEmployees MS Project Interface: Employee/resource link
MPMSPParameter MSProjectParameters MS Project Interface: Export Import Parameter
MPMSPPhasen MSProjectPhases MS Project Interface: Phase/task link
MPNewsletterCampaign NewsletterCampaign Source data for a plain newsletter (one time user)
MPNewsletterConnector NewsletterConnector Store special email server connections
MPNewsletterFilterSet NewsletterFilterSet Predefined filter on the E-Mail sources
MPNewsletterLog NewsletterLog Log the sending action of a new newsletter
MPNewsletterMaster NewsletterMaster Newsletter Design Template
MPNummernPool NumberPool Work Items: Number Pool
MPOnlineCatalogTree OnlineCatalogTree OnlineCatalogTree: Build grouping for online shop
MPOnlineCatalogTreeElement OnlineCatalogTreeElement OnlineCatalogTree: Lines in the grouping
MPOnlineCatalogTreeElementContent OnlineCatalogTreeElementContent OnlineCatalogTree: rules to biuld one line
MPOnlineCatalogTreeLink OnlineCatalogTreeLink OnlineCatalogTree: Link to business partner
MPPerioden Periods 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
MPPeriodenKurse PeriodsExchangeRates Calendar Management: Monthly currency exchange rates
MPPeriodenKW PeriodsCalendarWeeks Calendar Management: CalendarWeeks by ISO
MPPersonenEigenschaften EmployeeProperties Employee Master: Additional Settings
MPPersonenFahrzeugarten EmployeesTravelMilage Employee Master: Linked mileage allowances
MPPersonenLeistungen EmployeesService Employee Master: Linked services
MPPersonenOrganisation EmployeesOrganisation Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period
MPPersonenPeriode EmployeesPeriod Employee Master: One line per employee and valid from period and business unit
MPPersonenPool EmployeesPool Employee Master: Employee Pool link
MPPersonenProjektVorlagen EmployeesProjectLinks Employee Master: Project link (standard vacation project...)
MPPersonenProvisionsEinstellungen EmployeesCommissionSettings Employee Master: Standard Settings for Commission by Employee
MPPersonenReise2Fahrz EmployeesTrip2TravelMilage Travel Expenses Module: Employee Mileage type (header)
MPPersonenReise2FahrzSub EmployeesTrip2TravelMilageSub Travel Expenses Module: Employee Mileage type (sub)
MPPersonenSkills EmployeeSkills Employee Master: Employee Skill link
MPPersonenstamm EmployeeMaster Employee Master: Employee Master
MPPersonenUrlaubsAntrag EmployeeVacationRequest Vacation Management: Vacation Request and Approval
MPPersonenUrlaubsAntragFreigabe EmployeeVacationRequestApproval Vacation Management: Link to steps of approval process
MPPersonenUrlaubsAntragTage EmployeeVacationRequestDays Vacation Management: Link days for special day request
MPPersonenUrlaubsplan EmployeeAnnualVacation Employee Master: Vacation Management Annual Vacation
MPPersonenVerrechnung EmployeeCostRates Employee Master: Cost Rates
MPPersonenVerrechnungProjekt EmployeeCostRatesProject Employee Master: Cost Rates per project for freelancers
MPPersonenZeitenAktionen AttendanceAction Attendance: Actions "in the door" (Lines per day)
MPPersonenZeitenAktionenArchiv AttendanceActionArchive Attendance: Actions "in the door" (Lines per day) History
MPPersonenZeitenRegel AttendanceRule Attendance: Working Time rules (Header valid from)
MPPersonenZeitenRegelDetails AttendanceRuleDetail Attendance: Working Time rules (Details for the rule)
MPPersonenZeitenRegelKopf AttendanceRuleHead Attendance: Working Time rules (Header)
MPPersonenZeitenRegelZulagen AttendanceRuleShifts Attendance: Working Time rules (Night shift additionals)
MPPersonenZeitenSchicht AttendanceShiftRule Shift: Rule Definition
MPPersonenZeitenSchichtPlan AttendanceShiftPlan Shift: Standard Plan Rhythm
MPPersonenZeitenSchichtPlanTag AttendanceShiftPlanDays Shift: Standard Plan Rhythm Definition
MPPersonenZeitenTage AttendanceRuleDays Attandence: Actions "in the door" (Day header)
MPPersonenZeitenVorerfassung TimeBookingActivityTracker Table to store activities, before they are linked to time bookings
MPPreisIndex PriceIndex Maintenance: Price Index Header
MPPreisIndexLauf PriceIndexHeader Maintenance: Price Index Protocol of wizard (Header)
MPPreisIndexLaufPos PriceIndexLine Maintenance: Price Index Protocol of wizard (per position)
MPPreisIndexPeriode PriceIndexPeriod Maintenance: Price Index per month
MPProjectPhaseStatusHistory ProjectPhaseStatusHistory Stores the phase stauts of a project
MPProjektArbeitskreis ProjectWorkGroup Project Master: Work group
MPProjektArbeitspaketerfassung ProjectWorkPackageEntry Work Packages progress reporting by day
MPProjektArbeitspaketerfassungWerte ProjectWorkPackageEntryValues Work Packages progress reporting by structure element
MPProjektArtikelerfassung ProjectItemBooking 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
MPProjektArtikelerfassungSerie ProjectItemBookingSerialNumbers Time Keeping: ProjectTimeKeepingItemsSeries: Serial numbers
MPProjektAufmassStruktur ProjectMeasurementStructure Measurement strucutre definition: Head
MPProjektAufmassStrukturDimensionen ProjectMeasurementStructureDimension Measurement strucutre definition: Used dimensions
MPProjektAufmassStrukturElement ProjectMeasurementStructureElement Measurement strucutre definition: Structure Lines
MPProjektAufmassStrukturProjekte ProjectMeasurementStructureProject Measurement strucutre definition: Link to project
MPProjektAufmassStrukturWerte ProjectMeasurementStructureValues Measurement strucutre definition: Measurement values
MPProjektBuchungFavoriten ProjectBookingsFavorits Time Keeping: Favorits
MPProjektBuchungFehler ProjectBookingErrors Time Keeping: Error log in the time keeping
MPProjektBuchungserfassung ProjectTimeKeepingLines Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type
MPProjektBuchungserfassungBericht ProjectTimeKeepingReport Time Keeping: Link Week Report of employee or for customer
MPProjektBuchungserfassungZuschlaege ProjectTimeKeepingLinesAddOnCategory Time Keeping: AddOnCategoryDetails
MPProjektBuchungskopf ProjectTimeKeepingHeader 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).
MPProjektGruppen ProjectGroups Project Master: Project Groups
MPProjektKunden ProjectCustomerLink Project Master: Customer Link
MPProjektLeistungserfassung ProjectTimeKeepingLinesServices 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
MPProjektPhasen ProjectPhases Project Phases Master: Master Data (linked to project and planning version)
MPProjektPhasenBudget ProjectPhaseBudget Project Phases Master: Budget
MPProjektPhasenFertigstellungsgrad ProjectPhaseDegreeOfCompletion Project Phases Master: Degree OF Completion History
MPProjektPhasenMeldung ProjectPhaseEmployeeFeedback Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion
MPProjektPhasenMitarbeiter ProjectPhaseEmployeeLink Project Phases Master: Employee link
MPProjektPhasenVorgaenger ProjectPhasePredecessor Project Phases Phase Predecessors
MPProjektPlanungRessourcen ProjectPlanningResource Planning: Filter list for plannable resources (ex. G/L Accounts)
MPProjektPlanungsLog ProjectPlanningLog Planning: Log Phase dependency changes
MPProjektPlanungsversion ProjectPlanningVersions Project Master: Planning versions linked to a project
MPProjektPlanungsZeilen ProjectPlanningLines Planning: Master Planning lines
MPProjektPlanungsZeilenLog ProjectPlanningLinesLog Planning: Master Planning lines History
MPProjektReiseRegeln ProjectTravelExpenseRules Travel Expenses Module: Properties by Project
MPProjektReisevorlagen ProjectTravelExpenseTemplates Travel Expenses Module: Properties by Project
MPProjektstamm ProjectMaster Project Master: Master Data
MPProjektstammProjektleiter ProjectManager Project Master: Linked project manager
MPProjektstammWIP ProjectMasterWorkInProgess Project Master: Save degree of compleation for each month
MPProjektstatus ProjectStatus Project Master: status history
MPQualityProcess QualityProcess QualityProcess Definition
MPQualityProcessLink QualityProcessLink QualityProcess Combine Checklists to a master list
MPQualityProcessQuestions QualityProcessQuestions QualityProcess Definition Questionnaire
MPQualityProcessResults QualityProcessResults QualityProcess Result for each question of the questionaire
MPQualityProcessSettings QualityProcessSettings QualityProcess Special Settings for each process
MPQualityStatus QualityStatus QualityStatus: Type of statuses
MPReise2 TravelTrip Travel Expenses Module: Business Trip Master
MPReise2BuchungBeleg TravelPostingDocument Travel Expenses Module: Posting document
MPReise2BuchungBelegPos TravelPostingDocumentLine Travel Expenses Module: Posting document lines
MPReise2BuchungBelegPosSteuer TravelPostingDocumentLineTax Travel Expenses Module: Posting document lines sub tax
MPReise2BuchungKopf TravelAccountingHeader Travel Expenses Module: Accounting Header
MPReise2Freigabe TravelAccountingApproval Travel Expenses Module: Approval for travel requests
MPReise2Grundprojekte TravelTripProjectLink Travel Expenses Module: Business Trip Project Link
MPReise2KostenArten TravelExpenseTypes Travel Expenses Module: Travel Expenses Types Master Data
MPReise2KostenArtenKonten TravelExpenseTypesAccounts Travel Expenses Module: Travel Expenses Types Company G/L Account Link
MPReise2KostenArtenKontenMatrix TravelExpenseTypesAccountsMatrix Travel Expenses Module: Travel Expenses Types Company G/L Account Link (Matrix)
MPReise2KostenFahrzeugarten TravelMilageAllowanceHeader Travel Expenses Module: Mileage allowances header
MPReise2KostenFahrzeugartenSub TravelMilageAllowanceSub Travel Expenses Module: Mileage allowances sub
MPReise2Laender TravelCountries Travel Expenses Module: Countries
MPReise2LaenderPauschalen TravelCountriesAllowances Travel Expenses Module: Country allowances
MPReise2Template TravelTemplate Travel Expenses Module: Template Header
MPReise2TemplateRegel TravelTemplateSetting Travel Expenses Module: Template Settings
MPReise2TemplateVersion TravelTemplateVersion Travel Expenses Module: Template by "period from"
MPReise2Zeile TravelTripLine Travel Expenses Module: Trip receipt line
MPReise2ZeileDokumente TravelTripLineDocument Travel Expenses Module: Trip receipt line (document link for scanned documents)
MPReise2ZeileProjekt TravelTripLineProject Travel Expenses Module: Trip receipt project line for invoice
MPReise2Zeiten TravelTripTime Travel Expenses Module: Trip day lines
MPReise2ZeitenPauschalen TravelTripTimeAllowancesLines Travel Expenses Module: Employee trip days
MPReise2ZeitenPauschalenZeilen TravelTripTimeAllowances Travel Expenses Module: Employee trip days allowance link
MPReiseKostenFahrzeugarten TravelMilageAllowances Travel Expenses Module: Mileage allowances
MPRessourcenGPTeam ResourcePoolBPTeam External resource team (Supplier, customer)
MPRessourcenGPTeamKostensaetze ResourcePoolBPTeamCostRates Cost rates for external resource team
MPRessourcenGPTeamLink ResourcePoolBPTeamLink Link between resource pool and external resource team
MPRessourcenPool ResourcePool Resource Pool: Master Data
MPRessourcenPoolKostensaetze ResourcePoolCostRates Resource Pool: Cost Rates
MPSammelmappe FolderDocuments Master Data Folder Documents
MPSammelmappeBaum FolderDocumentTree Master Data Folder Search Tree
MPSammelmappeGruppen FolderDocumentsGroups Document Tab Registers
MPSammelmappeIndex FolderIndex Document tagging
MPSammelmappeIndexFelder FolderIndexFields Definition of document tags
MPSammelmappeIndexFormFields FolderIndexFormFields Link of index fields to an index form
MPSammelmappeIndexForms FolderIndexForms Defining additional index forms
MPSammelmappeIndexValues FolderIndexValues Index Form Values for MARIDMS
MPSammelmappeOCR FolderIndexOCR Additional Information via Document Recognition Services
MPServiceAsyncAction ServiceAsyncAction To Do Table for MARIService to send messages async
MPServiceJob ServiceJobs MARIService: Service Job header
MPServiceJobParameter ServiceJobParameter MARIService: Service Job settings
MPServiceJobSchedule ServiceJobSchedule MARIService: Service Job timing
MPServiceJournal ServiceJournal MARIService: Service Job log header
MPServiceJournalMessage ServiceJournalMessage MARIService: Service Job log messages
MPServiceJournalParameter ServiceJournalParameter MARIService: Service Job log parameters
MPSetupClientSettings SetupClientSettings Kiosk Mobile Clients
MPSetupFormControlsBrowserSettings SetupFormControlsBrowserSettings System Table for user grid settings
MPSetupFormControlsSettings SetupFormControlsSettings System table for user control settings
MPSetupGBSettings SettingsBusinessUnit Master Data: Settings by business unit
MPSetupGBSettingsBuchungsVariante SettingsBusinessUnitAccountingVersion Internal Service Changes: Setting of type BU vs. BU
MPSetupGBSettingsMatrix SettingsBusinessUnitMatrix Master Data: Settings by business unit in matrix
MPSetupGeschaeftsbereich BusinessUnitMaster Business Units: Master Data
MPSetupMandantEInvoice SettingsCompanyEInvoice Master Data: Electronic Invoice settings by company
MPSetupMandantSettings SettingsCompany Master Data: Settings by company
MPSetupMandantSettingsMatrix SettingsCompanyMatrix Master Data: Settings by company in matrix
MPSetupMengenFeldBasis SetupQuantityFieldBase Field definition for quantity formular
MPSetupMengenFeldBasisMandant SetupQuantityFieldBaseCompany Link to UDF in the company
MPSetupMengenFormel SetupQuantityFormular Quantity Formular Head
MPSetupMengenFormelFelder SetupQuantityFormularField Quantity Formular Lines
MPSetupTypen SettingTypes Master Data: Selectable values with translation
MPSetupUserBrowserTree SetupUserBrowserTree Master Data: Store Tree Selection
MPSetupUserFormularFields SetupUserFormularFields Master Data: Settings by user and form
MPSetupUserFormularPos SetupUserFormularPos Master Data: Settings by user, form and form element
MPSetupUserSettings SetupUserSettings Master Data: Settings by user
MPSetupVacationType SetupVacationType Master Data: Setting for different vacation types
MPSimulation Simulation Plannings Simulator: Master Table
MPSimulationDaten SimulationData Plannings Simulator: Data of dimensions
MPSimulationDatenHistory SimulationDataHistory Plannings Simulator: Data of old simulations
MPSimulationEigenschaft SimulationMasterSettings Plannings Simulator: Master Table Settings
MPSimulationImport SimulationImport Plannings Simulator: Import from real planning
MPSimulationRegelEigenschaft SimulationRuleProperty Plannings Simulator: Export Rule (Settings)
MPSimulationRegelKopf SimulationRuleHead Plannings Simulator: Export Rule (Master Header)
MPSimulationRegeln SimulationRules Plannings Simulator: Export Rule (Master)
MPSimulationStammdaten SimulationMasterData Plannings Simulator: Master Data by dimension
MPSimulationStammdatenBerechtigung SimulationMasterDataAuthentication Plannings Simulator: Master Data by dimension authorization
MPSimulationStammdatenHistory SimulationMasterDataHistory Plannings Simulator: Master Data by dimension (history for old simulations)
MPSimulationSzenarien SimulationScenario Plannings Simulator: Scenarios
MPSimulationSzenarienBerechtigung SimulationScenarioAuthentication Plannings Simulator: Scenarios authorization
MPSimulationSzenarienHistory SimulationScenarioHistory Plannings Simulator: Scenarios history
MPSkills SkillMaster Employee Master: Employee Skills
MPStammdatenEigenschaften MaterDataProperties Master Data Extra Properties. Universal table
MPSysActivityLink SysActivityLink Link OCLG Activities to PM Objects
MPSysAddOns SysAddOns Manage Programm Add Ons in MARI
MPSysArchivePattern SysArchivePattern Definition to tag and place documents into DMS
MPSysArchivePatternTree SysArchivePatternTree Definition to tag and place documents into DMS-Trees
MPSysArchivePatternTreeLine SysArchivePatternTreeLine Definition to tag and place documents into DMS-Trees details
MPSysClassApproval SysClassApproval Approval of core data
MPSysClassApprovalLine SysClassApprovalLine Approval of core data receipients
MPSysClassApprovalRule SysClassApprovalRule Definition of Approval procedures
MPSysClassApprovalRuleRessources SysClassApprovalRuleRessources Definition of Approval procedures lines
MPSysClassCompanyFilter SysClassCompanyFilter Define for a given Master data the visibility to users with company restrictions
MPSysClassFavorites SysClassFavorites Store Search Tree favorite elements by user
MPSysClassFieldView SysClassFieldView System Table: Order of fields in system dimensions
MPSysClassInfoQuery SysClassInfoQuery Query user tables for employee / individual information
MPSysClassLookup SysClassLookup Info Screen Management: Lookup for additional columns
MPSysClassNotification SysClassNotification Event Management: Definition of used events by master data dimension
MPSysClassNotificationReceipients ClassNotificationReceipients Event Management: Additional receipients for core data
MPSysClassNotificationText ClassNotificationText Event Management: Textdefinition master
MPSysClassNotificationTextLang ClassNotificationTextLang Event Management: Textdefinitions by language
MPSysConnections SysConnections System: Link to SBO company databases [!! Never edit this table !!]
MPSysDefinition SysDefinition Internal Database Version Information
MPSysDocSeries SysDocSeries System: Numberseries for ProjectManagement documents
MPSysDocWorkflow SysDocWorkflow Print Process: Definition Table
MPSysDocWorkflowStep SysDocWorkflowStep Print Process: Steps
MPSysDocWorkflowStepDocType SysDocWorkflowStepDocType Print Process: Settings by document type for each step
MPSysDocWorkflowStepDocTypePrintOrder SysDocWorkflowStepDocTypePrintOrder Print Process: Store Settings by first and following pages
MPSysDragRelate SysDragRelate used in future versions
MPSysFilterDefinition SysFilterDefinition Definition of dynamic filter forms
MPSysFilterDefinitionFilter SysFilterDefinitionFilter Definition of dynamic filter forms - field definition
MPSysFilterDefinitionGroup SysFilterDefinitionGroup Definition of dynamic filter forms - Tabs
MPSysFilterDefinitionValues SysFilterDefinitionValues User Values for filter forms, with different names
MPSysFlexVarianten SysFlexVersions Info Screen Management: User-defined columns (header)
MPSysFlexVariantenLookup SysFlexVersionsLookup Info Screen Management: User-defined columns (source data)
MPSysFlexVariantenSpalten SysFlexVersionsColumns Info Screen Management: User-defined columns (columns)
MPSysFormFieldOptions SysFormFieldOptions System Table: Manage defaults and visibility of fieds in web forms
MPSysFullTextSearch SysFullTextSearch System Table: Store the selected full text search settings
MPSysImportDef SysImportDef System Table: Text Field Mapping for data import
MPSysImportDefLog SysImportDefLog System Table: Stores date and file with result
MPSysImportDefSpalten SysImportDefColumns System Table: Text Field Mapping for data import by col
MPSysImportDefSpaltenRegeln SysImportDefColumnsRules System Table: Text Field Mapping for data import Extra rules
MPSysKundenSprachen SysCustomerLanguages System: Language
MPSysKundenSprachenMandant SysCustomerLanguagesCompany System: Languages linked to SBO company languages
MPSysKundenTexte SysCustomerText System: Text elements
MPSysLock SysLock System: logical lock of master data
MPSysLogBuch SysLogBook System: Change log by SQL Triggers (Table information)
MPSysLogbuchDetail SysLogBookDetail System: Change log by SQL Triggers (Field information)
MPSysLogDebug SysLogDebug Debug Content
MPSysMARICopyLog SysMARICopyLog System: Log of MARI Copy program distribution by client PC
MPSysMasterProperties SysMasterProperties Property Settings for master data (Contract Person, Employees, Service Tasks, Events)
MPSysMasterPropertyLink SysMasterPropertyLink Link between Dimension (ClassID) and a SysMasterProperty. See MPSysMasterProperty.UsageFlag for the used linked dimensions.
MPSysMasterPropertyStack SysMasterPropertyStack Header Line for a set of properties
MPSysMasterPropertyStackLink SysMasterPropertyStackLink Link to the master data for the property stack
MPSysMenu SysMenu System: Menu contents for the different clients (Fat, Web, customer portal..)
MPSysMenuFavorites SysMenuFavorites System: User Menu
MPSysMessages SysMessages System: eMail System (Header)
MPSysMessagesAttachment SysMessagesAttachment System: eMail System (Attachments)
MPSysMessagesAttachmentFilter SysMessagesAttachmentFilter System: eMail System (Filter for the Email In module)
MPSysPlayerFrmAction SysPlayerFrmAction Player for stored scenarios: Head
MPSysPlayerFrmActionFilm SysPlayerFrmActionFilm Player for stored scenarios: Film
MPSysPlayerFrmActionFilmStack SysPlayerFrmActionFilmStack Player for stored scenarios: Master Data Ids
MPSysPlayerFrmActionSequence SysPlayerFrmActionSequence Player for stored scenarios: Sequence
MPSysPlayerFrmActionSequenceLog SysPlayerFrmActionSequenceLog Player for stored scenarios: Player Log
MPSysProRata SysProRata Rule to spred revenue for mainenance positions to 12 month
MPSysProRataSettings SysProRataSettings Rule to spred revenue for mainenance positions to 12 month (Details)
MPSysReportGruppen SysReportGroups Reporting: Report Groups: List of different reports run at once
MPSysReportGruppenSub SysReportGroupsDetail Reporting: Report Groups (sub)
MPSysReportLayoutSettings SysReportLayoutSettings Reporting: Saves the print from grid to multiple pages settings by user
MPSysReports SysReports Reporting: User Report definition
MPSysReportSize SysReportSize Define Sizes for Label Printing
MPSysReportSizeMapping SysReportSizeMapping Mapping of real Printer to Sizes
MPSysReportsLanguage SysReportsLanguage Reporting: User Report definition translation of crystal reports objects
MPSysReportsSQL SysReportsSQL Reporting: User Report definition: SQL for main and sub reports
MPSysRestService SysRestService Settings for REST Service Interfaces
MPSysStamp SysStamp System: CoreDataTimeStamp: Change ID for each change of a core element
MPSysStrings SysLanguageStrings System: User-defined translations of the user interface. If not entry in the user table the ID is used by the MARIResource.dll with the standard translations
MPSysSuchBedingung SysSearchCondition Saved Search: Conditions
MPSysSuchErgebniss SysSearchResult Saved Search: Results
MPSysSuchGruppe SysSearchGroup Saved Search: Groups
MPSysSuchKopf SysSearchHead Saved Search: Header
MPSysSuchSchritt SysSearchStep Saved Search: Steps
MPSysUserFields SysUserFields System: User-defined fields: Additional fields by master data
MPSysUserFieldsGroup SysUserFieldsGroup System: Header for user defined groups
MPSysUserFormFields SysUserFormFields SDK: User-Defined Tables: Form Fields
MPSysUserFormPages SysUserFormPages SDK: User-Defined Tables: Form Pages
MPSysUserGroups SysUserGroups SDK: User-Defined Tables: Groups in UDT
MPSysUserObjects SysUserObjects SDK: User-Defined Tables: Master Table for UDT
MPSysUserProcesses SysUserProcesses System: User Processes Settings Master
MPSysUserProcessesSettings SysUserProcessesSettings System: User Processes Settings Lines
MPSysUserQuery SysUserQuery System: User Defined Queries
MPSysUserQueryGruppe SysUserQueryGroup System: User Defined Groups for Queries
MPSysUserStrings SysUserStrings System: User-defined translations of the user interface
MPSysUserTable SysUserTable SDK: User-Defined Tables: Table description
MPSysUserTableClassDelete SysUserTableClassDelete SDK: User-Defined Tables: Delete conditions
MPSysUserTableClassIndex SysUserTableClassIndex SDK: User-Defined Tables: Search Conditions
MPSysUserTableClassIndexCol SysUserTableClassIndexCol SDK: User-Defined Tables: Columns for search conditions
MPSysUserTableClassTree SysUserTableClassTree SDK: User-Defined Tables: Search Tree
MPSysUserTableFields SysUserTableFields SDK: User-Defined Tables: Field definition
MPSysUserTableLink SysUserTableFieldsLink SDK: User-Defined Tables: Link to existing master data forms
MPSysUserTableOptions SysUserTableOptions SDK: User-Defined Tables: Internal Links
MPSysVersionLog SysLogVersion System: Log the upgrade process
MPTan TransactionID System: Transaction Table to handle the unique IDs of all data (master data and tasks)
MPTaxServiceLog TaxServiceLog USA Sales Tax Interface Log
MPTaxServiceMapping TaxServiceMapping USA Sales Tax Interface Mapping storage
MPTaxServiceMappingSub TaxServiceMappingSub USA Sales Tax Interface Mapping sub table
MPTenantActions TenantActions Action table to store (CreateUser, ChangeUser) Actions in the master database. To be consumed via web service or MARIService
MPTenantBatchLog TenantBatchLog Bucket to store events from batches locally or remote
MPTenantDatabases TenantDatabases Management of MARIProject/SBO client datatabases
MPTenantEnvironments TenantEnvironments Base client enviornment (master for over all clients)
MPTenantMonitorAppInstallations TenantMonitorAppInstallations Bucket to store installation data at client location: installed apps
MPTenantMonitorAppUserGroups TenantMonitorAppUserGroups Bucket to store installation data at client location: installed user groups
MPTenantMonitorAppUsers TenantMonitorAppUsers Bucket to store installation data at client location: assigned users
MPTenantMonitorDatabases TenantMonitorDatabases Bucket to store installation data at client location: used databases
MPTenantMonitorEnvironments TenantMonitorEnvironments Bucket to store installation data at client location: Information from SLD
MPTenantMonitorMachines TenantMonitorMachines Bucket to store installation data at client location: database servers, RDP Servers, Clients
MPTenantMonitorSysLogDebug TenantMonitorSysLogDebug Bucket to store installation data at client location: last 10 Sys Logs
MPTenantServices TenantServices Manage monitoring web sites or RestServices at the clients
MPTenantTenants TenantTenants Management of MARIProject/SBO client installations
MPTenantUserGroups TenantUserGroups Management of MARIProject/SBO client installations user groups
MPTenantUsers TenantUsers Management of MARIProject/SBO client installation users
MPTenantUsersDBLink TenantUsersDBLink Management of MARIProject/SBO client installation licenses, rights
MPTextbausteine TextElements System: User-defined Text Elements
MPTextbausteineSprachen TextElementsLanguages System: User-defined Text Elements (Languages)
MPTimeBookingAddOnCategory TimeBookingAddOnCategory Time Keeping: Add On Items Sales Rules Valid From
MPTimeBookingAddOnCategoryHead TimeBookingAddOnCategoryHead Time Keeping: Add On Items Sales Rules
MPTimeBookingAddOnCategoryLine TimeBookingAddOnCategoryLine Time Keeping: Add On Items Sales Rule Details
MPTmpRptKalender TempReportCalendar Reporting: Temporary Table: Calendar
MPTmpRptPrintAdresse TempReportAddress Reportng: 1:n Addresses for ducments
MPTmpRptPrintBelegKopf TempReportDocumentHeader Reporting: Temporary Table: Document Header
MPTmpRptPrintPositionen TempReportDocumentPos Reporting: Temporary Table: Document Positions
MPTmpRptPrintPositionenLagerplaetze TempReportDocumentPosBinLocations Reporting: Temporary Table: Document Positions Bin Location Information
MPTmpRptPrintPositionenSerien TempReportDocumentPosSerialNumbers Reporting: Temporary Table: Document Positions Serial Numbers
MPTmpRptPrintSteuer TempReportDocumentTax Reporting: Temporary Table: Document TAX
MPTmpRptPrintZKD TempReportDocumentPayment Reporting: Temporary Table: Document Payment Conditions
MPTmpRptPrintZuschlag TempReportDocumentAddOns Reporting: Temporary Table: Document Add On Items
MPTmpRptProjektPhaseLeistung TempReportProjectPhaseService Reporting: Temporary Table: Project Phase Service
MPTmpRptProjektPhasenBericht TempReportProjectPhase Reporting: Temporary Table: Project Phase Report
MPTmpRptStundenUeberblick TempReportTimeKeeping Reporting: Temporary Table: Time Keeping
MPTmpRptUmsatz TempReportInfoScreens Reporting: Temporary Table: Info Screens
MPTmpRptVSFlex TempReportGridSmall Reporting: Temporary Table: Grid small
MPTmpRptVSFlexLong TempReportGridLarge Reporting: Temporary Table: Grid large
MPTmpTimeBookingAddOn TempTimeBookingAddOn Reporting: Temporary Table: Time Booking Add On
MPTrainingExams TrainingExams Training Module: List of exams
MPTrainingGrade TrainingGrade Training Module: List of grades
MPTrainingParticipant TrainingParticipant Training Module: List Of Participants
MPTrainingParticipantCompanyLink TrainingParticipantCompanyLink Training Module: Link of a participant to addiational companies
MPTrainingParticipantExams TrainingParticipantExams Training Module: Passed exams of participants
MPTrainingParticipantGrades TrainingParticipantGrades Training Module: Grades of participants
MPTrainingRegistration TrainingRegistration Training Module: Registratrion to training cources
MPTrainingRegistrationContractLink TrainingRegistrationContractLink Training Module: Selection of billable contract positions (Contract from registration)
MPTrainingRegistrationOptionLink TrainingRegistrationOptionLink Training Module: Selectable options (formaly phases)
MPTrainingRegistrationPhaseLink TrainingRegistrationPhaseLink Training Module: Selected options=Phases from the project linked to the training cource
MPTrainingRegistrationTeam TrainingRegistrationTeam Training Module: Team for the training
MPTrainingRegistrationTeamLink TrainingRegistrationTeamLink Training Module: Link to the team
MPVertragRundung ContractRoundingDefinition Defines Time Rounding Methods
MPVertragRundungDetails ContractRoundingDefinitionDetails Defines Time Rounding Methods (From Qty/To Qty)
MPVKVertraege Contract Contract Management: Contract Master Data + Service Master Data
MPVKVertraegeAnzahlungen ContractDownPayments Contract Management: Contract Down Payments
MPVKVertraegeBelege ContractDocument Contract Management: Sales Documents
MPVKVertraegeBelegeAnhaenge ContractDocumentAttachments Contract Management: Attachment Selection
MPVKVertraegeBelegeDruck ContractDocumentPrintHistory Contract Management: Print History
MPVKVertraegeBelegeEInvoice ContractDocumentEInvoice Contract Management: Additional information for PEPPOL
MPVKVertraegeBelegeER ContractDocumentReturnRevenueLink Contract Management: [not used]
MPVKVertraegeBelegeFehler ContractDocumentErrors Contract Management: Document Error Info
MPVKVertraegeBelegeFreigabe ContractDocumentApproval Contract Management: Document Approval
MPVKVertraegeBelegeILVKopf ContractDocumentISCHead Contract Management: Document Internal Service Charges Head
MPVKVertraegeBelegeILVPos ContractDocumentISCPos Contract Management: Document Internal Service Charges Positions
MPVKVertraegeBelegeILVPosSteuer ContractDocumentISCPosTax Contract Management: Document Internal Service Charges Positions Tax
MPVKVertraegeBelegePositionen ContractDocumentPositions Contract Management: Document Positions
MPVKVertraegeBelegePositionenCharge ContractDocumentPositionsBatches Contract Management: Document Positions Batches
MPVKVertraegeBelegePositionenSerie ContractDocumentPositionsSerialNumbers Contract Management: Document Positions Serial Numbers
MPVKVertraegeBelegePositionenSteuer ContractDocumentPositionsTax Contract Management: Document Positions Tax
MPVKVertraegeBelegeSteuer ContractDocumentTAX Contract Management: Document TAX
MPVKVertraegeBelegeZKD ContractDocumentInstallments Contract Management: Document Payment Conditions
MPVKVertraegeBelegeZuordnung ContractDocumentLink Contract Management: Document Link to down payments
MPVKVertraegeCommission ContractCommission Contract Management: Link Sales Representetive to Contract
MPVKVertraegeCommissionPos ContractCommissionPos Contract Management: Percentage for each position for the commission receipient
MPVKVertraegeEKPositionen ContractPOPositionLink Contract Management: Contract link to PO Process by position
MPVKVertraegeERDefinition ContractReturnRevenueAccountDef Contract Management: Contract revenue return account definition
MPVKVertraegeKundenDokumente ContractCustomerDocuments Drawings to be created for the customer
MPVKVertraegePos2BelPos ContractPosition2DocumentPosition Contract Management: Contract document position to document position link
MPVKVertraegePos2EKPos ContractPosition2POPosition Contract Management: Contract position to PO position link
MPVKVertraegePos2Service ContractPosition2Service Contract Management: Contract position to Customer Service Object and parts
MPVKVertraegePositionen ContractPositions Contract Management: Contract positions (also service master positions)
MPVKVertraegePositionenAkd ContractPositionPayment Contract Management: Contract positions accounting lines (due date, phase ...)
MPVKVertraegePositionenAufmassDimensionen ContractPositionMeasurementDimension Contract Position Workpackage definition: Dimension
MPVKVertraegePositionenAufmassWerte ContractPositionMeasurementValues Contract Position Workpackage definition: Values
MPVKVertraegePositionenAufmassZeile ContractPositionMeasurementLine Contract Position Workpackage definition: Structure Lines
MPVKVertraegePositionenDef ContractPositionDefinition Contract Management: Contract position extra field definition
MPVKVertraegePositionenEquipment ContractPositionEquipment Contract Management: Link an equipment to the contract position
MPVKVertraegePositionenPers ContractPositionEmployee Contract Management: Contract position employee link
MPVKVertraegePositionenPhasen ContractPositionPhase Contract Management: Contract position phase link
MPVKVertraegePositionenTexte ContractPositionTextElements Contract Management: Contract position texts (standard definition)
MPVKVertraegeTexte ContractTextElements Contract Management: Contract header footer texts (standard definition)
MPVKVertraegeZahlungsplan ContractInstallmentPlan Contract Management: Contract Invoicing plan
MPVKVertraegeZKD ContractInstallments Contract Management: Installment Plan
MPWiedervorlagen Reminder System: Reminder
MPWorkInProgressDefinition WorkInProgressDefinition Work In Progress Definition
MPWorkItem WorkItem The table is used basically for service task and other tasks. For each dimension using this table, special views have been created. See also the description of the field WorkItemType.
DimensionClassID/WorkItemTypeView
Service Task364MARIWorkItem_ServiceTask
Internal Service Task365MARIWorkItem_InternalServiceTask
Result Task456MARIWorkItem_ResultTask
Service Plan379MARIWorkItem_ServicePlan
Service Plan Template378MARIWorkItem_ServicePlanTemplate
Qualification493MARIWorkItem_Qualification
Qualification Plan494MARIWorkItem_QualificationPlan
Qualification Task495MARIWorkItem_QualificationTask
Business Partner Audit Template496MARIWorkItem_BPAuditTemplate
Business Partner Audit Plan497MARIWorkItem_BPAuditPlan
Business Partner Audit498MARIWorkItem_BPAuditTask
Trainings Course/Event/Meeting492MARIWorkItem_TrainingCourse
Part List401
Check List Limit471
Production Task522
MPWorkItemDocumentLink WorkItemDocumentLink Service Task Link created documents
MPWorkItemOptions WorkItemOptions Training Course: selectable options by the participants
MPWorkItemPhaseCPosFilter WorkItemPhaseCPosFilter Training Course: Filter selectable phases or contract positions
MPWorkItemPosition WorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource
MPWorkItemPositionSerial WorkItemPositionSerial Serialnumbers, Batchnumbers for work item positions
MPWorkItemResources WorkItemResources Employees or Equipment necessary for the tasks
MPWorkItemResults WorkItemResults Results of quality process questionnaire
MPWorkItemScheduleDates WorkItemScheduleDates Recurring service tasks
MPWorkItemSettings WorkItemSettings Additional Properties for a service order
MPXcelsiusDimensionParamenter XcelsiusDimensionParameter Xcelsius: Special Parameter for each film
MPXcelsiusFiles XcelsiusFiles Xcelsius: Source Files for one Film
MPXcelsiusFilms XcelsiusFilms Xcelsius: one flash film

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany