MARIProject Database Structure

Table Name:MPBenutzer
View Name:MARIUser
Group:Group: User
Description:ProjectManagement User + Customer Portal User
ClassID: 8. See Overview of ClassIDs by table.

Field View(engl.field)/Type Description Related
Benutzer UserCode

NVARCHAR (4) Primary

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
BenutzerTyp UserType

INT Primary

1=User, 2=CustomerSupportLogin clsImportEmployee_eUserType
Name Name

NVARCHAR (50) Unique

Kennwort Password

NTEXT

Gruppen Groups

BIGINT

binary flags MPBenutzergruppen.Gruppe
BenutzerAktiv LoginActive

SMALLINT (0=false,-1=true)

Modules Modules

INT

EMailName Email

NVARCHAR (100)

UserLevel UserLevelMode

SMALLINT

FibuLevel AccountingMode

INT

KHKUserName ERPUserName

NVARCHAR (128) Index

KHKUserPWD ERPUserPassword

NTEXT

ERPByCompany ERPUserByCompany

SMALLINT (0=false,-1=true)

EncryptionMethod EncryptionMethod

SMALLINT

EncryptionSalt EncryptionSalt

NVARCHAR (40)

LastPasswordChange LastPasswordChange

Datetime

LastPassword1 LastPassword1

NTEXT

LastPassword2 LastPassword2

NTEXT

LastPassword3 LastPassword3

NTEXT

LastPassword4 LastPassword4

NTEXT

LastPassword5 LastPassword5

NTEXT

ResetToken ResetToken

NVARCHAR (255)

ResetTokenDate ResetTokenDate

Datetime

CustomerCompany Company

SMALLINT

MPSysConnections.CompanyID (WHERE ConnectionType=6)
CustomerCardCode CustomerCardCode

NVARCHAR (20) Index

OCRD.CardCode
CustomerContact CustomerContact

INT

OCPR.CntctCode
DMSUser DMSUser

NVARCHAR (50)

DMSPWD DMSPWD

NTEXT

AvatarPictureID AvatarPictureID

INT Index

CreationID CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
CreationDate CreateDate

Datetime

ChangeID ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

InAktiv Inactive

SMALLINT (0=false,-1=true)

Hide dataset
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MPAccoutingProfitCenterPlanningLine Store the financial planning on profit center level per month
MPAccoutingProfitCenterPlanningYear Store the financial planning on profit center level per year
MPAdressenKennzeichen Additional Data for OCRD
MPArbeitspaket

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 Item Groups: Additional fields for maintenance and purchase order
MPArtikelKennzeichen Item Master: Additional fields for maintenance and purchase order
MPAuswertungGeschaeftsbereiche Plannings Simulator: Dimension Business Unit
MPAuswertungGeschaeftsbereicheMA Plannings Simulator: Dimension Business Unit / Employees
MPAuswertungGruppen Plannings Simulator: Dimension Groups
MPAuswertungKopf Plannings Simulator: Header
MPAuswertungProjekte Plannings Simulator: Dimension Projects
MPAuswertungProjekteMA Plannings Simulator: Dimension Projects/Employees
MPAuswertungRessourcen Plannings Simulator: Dimension Resources
MPAuswertungRessourcenMA Plannings Simulator: Dimension Resources/Employees
MPBelegeEmpfaenger Definition of eMail Recipients for documents out of a contract.
MPBenutzer ProjectManagement User + Customer Portal User
MPBenutzerERP ProjectManagement User Link to SBO Users
MPBenutzerGeschaeftsbereiche ProjectManagement User Athorization to Business Units
MPBenutzergruppen ProjectManagement: User Groups
MPBenutzerLog User Log for each login and logoff
MPBenutzerMandantenSicht User Company Visibility
MPBenutzerScanLog User Barcode Scan Log for all single scans
MPBilder Images linked to support issues, employees...
MPBilderVersionen Revisions of the pirctures
MPBuch Project Dokumentation: Book Header
MPBuchArchiv Project Dokumentation: Archived Book Content
MPBuchdruck Project Dokumentation: Print Defnition Head
MPBuchdruckAnhaenge Project Dokumentation: Print Defnition AttachementSelection
MPBuchdruckInhalt Project Dokumentation: Print Action Head
MPBuchdruckInhaltSeitenElemente Project Dokumentation: Print Action PageElementPrintLines
MPBuchdruckInhaltsVerzeichnis Project Dokumentation: Print Action Table of Content
MPBuchdruckMappen Project Dokumentation: Print Defnition Linked Folder Documents
MPBuchdruckSeiten Project Dokumentation: Print Defnition Book pages
MPBuchEigenschaftenUser Project Dokumentation: Book User Properties
MPBuchLayout Project Dokumentation: Layout Definition of a content element
MPBuchLink Project Dokumentation: externale links to pages
MPBuchLinkArchiv Project Dokumentation: externale link archive
MPBuchSeite Project Dokumentation: Book Page (Left hierarchy)
MPBuchSeitenArchiv Project Dokumentation: Book Page Archive (Left hierarchy)
MPBuchSeitenElement Project Dokumentation: Book Page Content Element
MPBuchSeitenElementArchiv Project Dokumentation: Book Page Content Element Archive
MPBuchSeitenFreigabe Project Dokumentation: Book Page Approval Flow
MPBuchSeitenInhalt Project Dokumentation: Book Page Content Data
MPBuchSeitenInhaltArchiv Project Dokumentation: Book Page Content Data Archive
MPChefInfoAuswertungenKopf Info Screen Management: Export Header
MPChefInfoCashFlowRun Info Screen Management: Daily cash flow run
MPChefInfoCashFlowRunProject Info Screen Management: Status of a project
MPChefInfoChart Info Screen Management: Status Settings for chart design
MPChefInfoDashboard Project Dash Board Settings
MPChefInfoDashboardTiles Project Dash Board Settings Tiles
MPChefInfoUserColumns Info Screen Management: User-defined columns
MPChefInfoUserStore Info Screen Management: Store filter settings (Header)
MPChefInfoUserTree Info Screen Management: Store tree selection
MPChefInfoUserView Info Screen Management: Store selected analysis
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)
MPCommissionDocumentPositions Commission: Sales Rep A/P Invoice Position Link
MPCommissionDocuments Commission: Sales Rep A/P Invoice Link
MPCommissionTypeRules Commission: Percentage Definition
MPCommissionTypes Commission: Basic Settings for different Types
MPCommissionWizardLog Commission: Log of the usage
MPContractCalculation Cotnract Sales Prices Calculation Method Head
MPCreditCardMapping Stores Credit Card Information to Business Partner and Employees for CreditCard Import
MPCustomerEquipmentCard Advanced table to sbo standard customer equipment card
MPCustomerEquipmentLocation Current location of a CSO at the client/Project
MPCustomerLocationTree Name of the location tree
MPCustomerLocationTreeElement Tree elements to manage levels, rooms of the customer
MPCustomerLocationTreeLink Link of a customer and a user to a tree or an element of the tree
MPDBAuswertungen Info Screen Management: Breakeven Analysis (Header)
MPDBColumnsDefinition Info Screen Management: Column Definition Head
MPDocApproval Approval Process Definition
MPDocApprovalLink Special Approval Rules per contract
MPDocumentDraftHead Header for the draft document
MPDocumentDraftHeadApproval Approval or workflow list for the draft document
MPDocumentDraftHeadLink Linked contracts and purchase processes
MPDocumentDraftPositionLink Linked positions in the sales contract and or purchase process
MPDocumentInvoiceFlow InvoicePaymentReportStore
MPDocValidation Validation rule for A/P invoices based on the linked purchase order
MPDokumente Documents linked in the Folder tabs of the master data
MPDokumenteVersionen Revision History of a document
MPEinheiten Unit of measurement basic setting
MPEKFremdBelegErfassung Purchase Order: Import external documents (Header)
MPEKVertraege Purchase Process: Header
MPEKVertraegeBelege Purchase Process: Purchase Document (Header)
MPEKVertraegeBelegeAnhaenge Purchase Process: Link to Attachments
MPEKVertraegeBelegeDruck Purchase Process: Print history
MPEKVertraegeBelegeFehler Purchase Process: Saved Errors
MPEKVertraegeBelegeFreigabe Purchase Process: Document Approval Employee Link
MPEKVertraegeBelegeILVKopf Purchase Process: Document Internal Service Change Head
MPEKVertraegeBelegeILVPos Purchase Process: Document Internal Service Change Positions
MPEKVertraegeCommission Purchase Process: Purchase Document Bonus definition
MPEKVertraegeCommissionPos Purchase Process: Purchase Document Bonus position definition
MPEKVertraegePositionen Purchase Process: PO Process Position (equivilant to contract position)
MPEKVertraegePositionenTexte Purchase Process: Text definition (master data) for positions
MPEquipment Equipment: Master Data for each individual Equipment
MPEquipmentCategory EquipmentCategory: Cagetory Master
MPEquipmentCategoryBPCatalog EquipmentCategory: Business Partner Catalog Number
MPEquipmentCategorySubject EquipmentCategory: Standard cost types for categories
MPEquipmentCategorySubjectRates EquipmentCategory: Standard cost and sales prices for the cost types of categories
MPEquipmentDetails Equipment: Master Data "date from" based
MPEquipmentDetailsLink Equipment Assembly: List of inner components
MPEquipmentLocation Equipment: Current Location of this equipment
MPEquipmentReminder Equipment: recurrent dates for each equipment
MPEquipmentSubjectBooking Time/Costbooking on Equipment data
MPEquipmentSubjectRates Equipment: Specific cost rates
MPEquipmentSubjectRatesBU Equipment: Specific cost and sales rates for internal service charges
MPExchangeSync MS Exchange Server Link Log
MPFibuBuchungsautomatRegel Definitions for Internal Service Charge Wizard
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)
MPGebinde Definition of a container carrying other goods
MPGebindeKategorie Container Categtrory to manage special settings
MPGebindeZeile Container Lines to see the goods in the container
MPGruppen Groups used for a long list of master data. See the GruppenArt enumeration
MPHotlineAnfrage 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 Support Module: Issue tracking: Issue line for comments, documents, emails, etc.
MPHotlineAnfrageFreigabe Support Module: Store the approval steps for a ticket
MPHotlineAnfrageKeywords Support Module: Global list of keywords for all tickets
MPHotlineGruppe Support Module: Support Group: Header
MPHotlineGruppeMitarbeiter Support Module: Support Group: Linked employees
MPHotlineMap Support Module: Self organzing the tickets
MPHotlineProdukt Support Module: Support Product: Master Data
MPHotlineProduktBetrachter Support Module: Customers/Users to be informed for changes
MPHotlineProduktKunde Support Module: Support Product: Customer Product Link
MPHotlineProduktKundeLizenz Support Module: Support Product: License files by customer
MPHotlineProduktModul Support Module: Support Product: Master Data Modules
MPHotlineProduktModulVersion Support Module: Support Product: Master Data Versions for Modules
MPHotlineProduktVersion Support Module: Support Product: Master Data Versions
MPHotlineRuleSet Support Module: Routing Set for blanc email input
MPHotlineRuleSetLine Support Module: Routing Set for blanc email input - Step
MPHotlineSLA Support Module: Service Level Agreement Master
MPHotlineSyncPartner Support Module: Synchronizaion settings
MPHotlineVertraege Support Module: Support Contracts (not used)
MPHotlineWorkFlow Support Module: Workflow definition for the status
MPKalender Calendar Management: Calendar Header
MPKalenderTemplate Calendar Management: Public Holiday Rules
MPKBArtikel Support Module: Knowledge Base Header
MPKBArtikelSprache Support Module: Knowledge Base Languages
MPLeistung

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 Service Master: Master Data Pool link
MPLocation Location: Place (India Localization)
MPLocationDistance Distance between locations
MPLohnArten Payroll Interface: Payroll Types Master Data by company
MPLohnArtenKategorie Payroll Interface: Payroll Types Master Data global
MPLohnStapel Payroll Interface: Export Header
MPMSPDatabases MS Project Interface: Database Link (MSP Server)
MPMSPImports MS Project Interface: Import log
MPNewsletterCampaign Source data for a plain newsletter (one time user)
MPNewsletterConnector Store special email server connections
MPNewsletterFilterSet Predefined filter on the E-Mail sources
MPNewsletterLog Log the sending action of a new newsletter
MPNewsletterMaster Newsletter Design Template
MPNummernPool Work Items: Number Pool
MPOnlineCatalogTree OnlineCatalogTree: Build grouping for online shop
MPOnlineCatalogTreeElement OnlineCatalogTree: Lines in the grouping
MPOnlineCatalogTreeElementContent OnlineCatalogTree: rules to biuld one line
MPPerioden 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 Calendar Management: Monthly currency exchange rates
MPPersonenPool Employee Master: Employee Pool link
MPPersonenProvisionsEinstellungen Employee Master: Standard Settings for Commission by Employee
MPPersonenSkills Employee Master: Employee Skill link
MPPersonenstamm Employee Master: Employee Master
MPPersonenUrlaubsAntrag Vacation Management: Vacation Request and Approval
MPPersonenUrlaubsAntragFreigabe Vacation Management: Link to steps of approval process
MPPersonenZeitenAktionen Attendance: Actions "in the door" (Lines per day)
MPPersonenZeitenAktionenArchiv Attendance: Actions "in the door" (Lines per day) History
MPPersonenZeitenRegel Attendance: Working Time rules (Header valid from)
MPPersonenZeitenRegelKopf Attendance: Working Time rules (Header)
MPPersonenZeitenSchicht Shift: Rule Definition
MPPersonenZeitenSchichtPlan Shift: Standard Plan Rhythm
MPPersonenZeitenTage Attandence: Actions "in the door" (Day header)
MPPersonenZeitenVorerfassung Table to store activities, before they are linked to time bookings
MPPreisIndex Maintenance: Price Index Header
MPPreisIndexLauf Maintenance: Price Index Protocol of wizard (Header)
MPPreisIndexPeriode Maintenance: Price Index per month
MPProjectPhaseStatusHistory Stores the phase stauts of a project
MPProjektArbeitspaketerfassung Work Packages progress reporting by day
MPProjektArbeitspaketerfassungWerte Work Packages progress reporting by structure element
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
MPProjektAufmassStruktur Measurement strucutre definition: Head
MPProjektAufmassStrukturElement Measurement strucutre definition: Structure Lines
MPProjektAufmassStrukturWerte Measurement strucutre definition: Measurement values
MPProjektBuchungFavoriten Time Keeping: Favorits
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
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).
MPProjektGruppen Project Master: Project Groups
MPProjektPhasen Project Phases Master: Master Data (linked to project and planning version)
MPProjektPhasenBudget Project Phases Master: Budget
MPProjektPhasenFertigstellungsgrad Project Phases Master: Degree OF Completion History
MPProjektPhasenMeldung Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion
MPProjektPhasenMitarbeiter Project Phases Master: Employee link
MPProjektPhasenVorgaenger Project Phases Phase Predecessors
MPProjektPlanungRessourcen Planning: Filter list for plannable resources (ex. G/L Accounts)
MPProjektPlanungsLog Planning: Log Phase dependency changes
MPProjektPlanungsversion Project Master: Planning versions linked to a project
MPProjektPlanungsZeilen Planning: Master Planning lines
MPProjektPlanungsZeilenLog Planning: Master Planning lines History
MPProjektReiseRegeln Travel Expenses Module: Properties by Project
MPProjektstamm Project Master: Master Data
MPProjektstammProjektleiter Project Master: Linked project manager
MPProjektstammWIP Project Master: Save degree of compleation for each month
MPProjektstatus Project Master: status history
MPQualityProcess QualityProcess Definition
MPQualityProcessLink QualityProcess Combine Checklists to a master list
MPQualityProcessQuestions QualityProcess Definition Questionnaire
MPQualityProcessResults QualityProcess Result for each question of the questionaire
MPQualityStatus QualityStatus: Type of statuses
MPReise2 Travel Expenses Module: Business Trip Master
MPReise2BuchungBeleg Travel Expenses Module: Posting document
MPReise2BuchungBelegPos Travel Expenses Module: Posting document lines
MPReise2BuchungKopf Travel Expenses Module: Accounting Header
MPReise2Freigabe Travel Expenses Module: Approval for travel requests
MPReise2KostenArten Travel Expenses Module: Travel Expenses Types Master Data
MPReise2KostenFahrzeugarten Travel Expenses Module: Mileage allowances header
MPReise2Laender Travel Expenses Module: Countries
MPReise2Template Travel Expenses Module: Template Header
MPReise2TemplateRegel Travel Expenses Module: Template Settings
MPReise2TemplateVersion Travel Expenses Module: Template by "period from"
MPReise2Zeile Travel Expenses Module: Trip receipt line
MPReise2ZeileDokumente Travel Expenses Module: Trip receipt line (document link for scanned documents)
MPReise2ZeileProjekt Travel Expenses Module: Trip receipt project line for invoice
MPReiseKostenFahrzeugarten Travel Expenses Module: Mileage allowances
MPRessourcenGPTeam External resource team (Supplier, customer)
MPRessourcenPool Resource Pool: Master Data
MPSammelmappe Master Data Folder Documents
MPSammelmappeBaum Master Data Folder Search Tree
MPSammelmappeGruppen Document Tab Registers
MPSammelmappeIndexFelder Definition of document tags
MPSammelmappeIndexForms Defining additional index forms
MPSammelmappeOCR Additional Information via Document Recognition Services
MPServiceJob MARIService: Service Job header
MPServiceJobSchedule MARIService: Service Job timing
MPSetupClientSettings Kiosk Mobile Clients
MPSetupGBSettings Master Data: Settings by business unit
MPSetupGBSettingsMatrix Master Data: Settings by business unit in matrix
MPSetupGeschaeftsbereich Business Units: Master Data
MPSetupMandantEInvoice Master Data: Electronic Invoice settings by company
MPSetupMandantSettings Master Data: Settings by company
MPSetupMandantSettingsMatrix Master Data: Settings by company in matrix
MPSetupMengenFeldBasis Field definition for quantity formular
MPSetupMengenFormel Quantity Formular Head
MPSetupUserBrowserTree Master Data: Store Tree Selection
MPSetupUserFormularFields Master Data: Settings by user and form
MPSetupUserFormularPos Master Data: Settings by user, form and form element
MPSetupUserSettings Master Data: Settings by user
MPSetupVacationType Master Data: Setting for different vacation types
MPSimulation Plannings Simulator: Master Table
MPSimulationImport Plannings Simulator: Import from real planning
MPSimulationRegelKopf Plannings Simulator: Export Rule (Master Header)
MPSimulationRegeln Plannings Simulator: Export Rule (Master)
MPSimulationStammdaten Plannings Simulator: Master Data by dimension
MPSimulationStammdatenBerechtigung Plannings Simulator: Master Data by dimension authorization
MPSimulationStammdatenHistory Plannings Simulator: Master Data by dimension (history for old simulations)
MPSimulationSzenarien Plannings Simulator: Scenarios
MPSimulationSzenarienBerechtigung Plannings Simulator: Scenarios authorization
MPSimulationSzenarienHistory Plannings Simulator: Scenarios history
MPStammdatenEigenschaften Master Data Extra Properties. Universal table
MPSysArchivePattern Definition to tag and place documents into DMS
MPSysArchivePatternTree Definition to tag and place documents into DMS-Trees
MPSysArchivePatternTreeLine Definition to tag and place documents into DMS-Trees details
MPSysClassApproval Approval of core data
MPSysClassApprovalLine Approval of core data receipients
MPSysClassApprovalRule Definition of Approval procedures
MPSysClassCompanyFilter Define for a given Master data the visibility to users with company restrictions
MPSysClassFavorites Store Search Tree favorite elements by user
MPSysClassInfoQuery Query user tables for employee / individual information
MPSysClassNotification Event Management: Definition of used events by master data dimension
MPSysClassNotificationReceipients Event Management: Additional receipients for core data
MPSysClassNotificationText Event Management: Textdefinition master
MPSysClassNotificationTextLang Event Management: Textdefinitions by language
MPSysDocSeries System: Numberseries for ProjectManagement documents
MPSysDocWorkflow Print Process: Definition Table
MPSysFilterDefinition Definition of dynamic filter forms
MPSysFilterDefinitionFilter Definition of dynamic filter forms - field definition
MPSysFilterDefinitionValues User Values for filter forms, with different names
MPSysFlexVarianten Info Screen Management: User-defined columns (header)
MPSysFormFieldOptions System Table: Manage defaults and visibility of fieds in web forms
MPSysImportDef System Table: Text Field Mapping for data import
MPSysImportDefLog System Table: Stores date and file with result
MPSysKundenSprachen System: Language
MPSysKundenSprachenMandant System: Languages linked to SBO company languages
MPSysKundenTexte System: Text elements
MPSysLock System: logical lock of master data
MPSysLogDebug Debug Content
MPSysMasterProperties Property Settings for master data (Contract Person, Employees, Service Tasks, Events)
MPSysMasterPropertyLink Link between Dimension (ClassID) and a SysMasterProperty. See MPSysMasterProperty.UsageFlag for the used linked dimensions.
MPSysMasterPropertyStack Header Line for a set of properties
MPSysMessages System: eMail System (Header)
MPSysMessagesAttachmentFilter System: eMail System (Filter for the Email In module)
MPSysPlayerFrmActionFilm Player for stored scenarios: Film
MPSysPlayerFrmActionSequence Player for stored scenarios: Sequence
MPSysPlayerFrmActionSequenceLog Player for stored scenarios: Player Log
MPSysProRata Rule to spred revenue for mainenance positions to 12 month
MPSysReportGruppen Reporting: Report Groups: List of different reports run at once
MPSysReportLayoutSettings Reporting: Saves the print from grid to multiple pages settings by user
MPSysReports Reporting: User Report definition
MPSysReportSize Define Sizes for Label Printing
MPSysReportSizeMapping Mapping of real Printer to Sizes
MPSysRestService Settings for REST Service Interfaces
MPSysStrings 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
MPSysSuchGruppe Saved Search: Groups
MPSysSuchKopf Saved Search: Header
MPSysUserFieldsGroup System: Header for user defined groups
MPSysUserQuery System: User Defined Queries
MPSysUserQueryGruppe System: User Defined Groups for Queries
MPSysUserTable SDK: User-Defined Tables: Table description
MPSysVersionLog System: Log the upgrade process
MPTaxServiceLog USA Sales Tax Interface Log
MPTenantActions Action table to store (CreateUser, ChangeUser) Actions in the master database. To be consumed via web service or MARIService
MPTenantBatchLog Bucket to store events from batches locally or remote
MPTenantDatabases Management of MARIProject/SBO client datatabases
MPTenantEnvironments Base client enviornment (master for over all clients)
MPTenantMonitorAppInstallations Bucket to store installation data at client location: installed apps
MPTenantMonitorAppUserGroups Bucket to store installation data at client location: installed user groups
MPTenantMonitorAppUsers Bucket to store installation data at client location: assigned users
MPTenantMonitorDatabases Bucket to store installation data at client location: used databases
MPTenantMonitorEnvironments Bucket to store installation data at client location: Information from SLD
MPTenantMonitorMachines Bucket to store installation data at client location: database servers, RDP Servers, Clients
MPTenantTenants Management of MARIProject/SBO client installations
MPTenantUserGroups Management of MARIProject/SBO client installations user groups
MPTenantUsers Management of MARIProject/SBO client installation users
MPTenantUsersDBLink Management of MARIProject/SBO client installation licenses, rights
MPTextbausteine System: User-defined Text Elements
MPTextbausteineSprachen System: User-defined Text Elements (Languages)
MPTimeBookingAddOnCategory Time Keeping: Add On Items Sales Rules Valid From
MPTimeBookingAddOnCategoryHead Time Keeping: Add On Items Sales Rules
MPTimeBookingAddOnCategoryLine Time Keeping: Add On Items Sales Rule Details
MPTrainingExams Training Module: List of exams
MPTrainingGrade Training Module: List of grades
MPTrainingParticipant Training Module: List Of Participants
MPTrainingParticipantExams Training Module: Passed exams of participants
MPTrainingParticipantGrades Training Module: Grades of participants
MPTrainingRegistration Training Module: Registratrion to training cources
MPTrainingRegistrationTeam Training Module: Team for the training
MPVertragRundung Defines Time Rounding Methods
MPVKVertraege Contract Management: Contract Master Data + Service Master Data
MPVKVertraegeBelege Contract Management: Sales Documents
MPVKVertraegeBelegeAnhaenge Contract Management: Attachment Selection
MPVKVertraegeBelegeDruck Contract Management: Print History
MPVKVertraegeBelegeER Contract Management: [not used]
MPVKVertraegeBelegeFehler Contract Management: Document Error Info
MPVKVertraegeBelegeFreigabe Contract Management: Document Approval
MPVKVertraegeBelegeILVKopf Contract Management: Document Internal Service Charges Head
MPVKVertraegeBelegeILVPos Contract Management: Document Internal Service Charges Positions
MPVKVertraegeCommission Contract Management: Link Sales Representetive to Contract
MPVKVertraegeCommissionPos Contract Management: Percentage for each position for the commission receipient
MPVKVertraegeKundenDokumente Drawings to be created for the customer
MPVKVertraegePositionen Contract Management: Contract positions (also service master positions)
MPVKVertraegePositionenAufmassWerte Contract Position Workpackage definition: Values
MPVKVertraegePositionenAufmassZeile Contract Position Workpackage definition: Structure Lines
MPVKVertraegePositionenTexte Contract Management: Contract position texts (standard definition)
MPWiedervorlagen System: Reminder
MPWorkInProgressDefinition Work In Progress Definition
MPWorkItem 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
MPWorkItemOptions Training Course: selectable options by the participants
MPWorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource
MPWorkItemResults Results of quality process questionnaire
MPWorkItemScheduleDates Recurring service tasks
MPXcelsiusFiles Xcelsius: Source Files for one Film
MPXcelsiusFilms Xcelsius: one flash film


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany