MARIProject Database Structure

See also the refernce to objects in MARIInterface.clsImportBase.eCoreDataClassID


ClassID View/Table Dimension name Table Description
8 MARIUser
MPBenutzer
User ProjectManagement User + Customer Portal User
12 MARIPurchaseProcessDocument
MPEKVertraegeBelege
PurchaseProcessDocument Purchase Process: Purchase Document (Header)
13 MARINumberPool
MPNummernPool
NumberPool Work Items: Number Pool
14 MARIBusinessUnitMaster
MPSetupGeschaeftsbereich
BusinessUnitMaster Business Units: Master Data
15 MARISysSearchHead
MPSysSuchKopf
SysSearchHead Saved Search: Header
16 MARISupportProduct
MPHotlineProdukt
SupportProduct Support Module: Support Product: Master Data
17 MARISupportIssue
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
19 MARICalendar
MPKalender
Calendar Calendar Management: Calendar Header
20 MARIKnowledgeBaseEntry
MPKBArtikel
KnowledgeBaseEntry Support Module: Knowledge Base Header
30 MARIMSProjectDatabases
MPMSPDatabases
MSProjectDatabases MS Project Interface: Database Link (MSP Server)
31 MARIPeriods
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
33 MARIEmployeeMaster
MPPersonenstamm
EmployeeMaster Employee Master: Employee Master
37 MARISkillMaster
MPSkills
SkillMaster Employee Master: Employee Skills
40 MARIProjectMaster
MPProjektstamm
ProjectMaster Project Master: Master Data
48 MARIResourcePool
MPRessourcenPool
ResourcePool Resource Pool: Master Data
51 MARISimulation
MPSimulation
Simulation Plannings Simulator: Master Table
51 MARIInfoSimulationSettings
MPAuswertungEigenschaften
InfoSimulationSettings Plannings Simulator: Settings
58 MARIProjectTimeKeepingLines
MPProjektBuchungserfassung
ProjectTimeKeepingLines Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type
66 MARIContractDocument
MPVKVertraegeBelege
ContractDocument Contract Management: Sales Documents
68 MARIServices
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

71 MARIContract
MPVKVertraege
Contract Contract Management: Contract Master Data + Service Master Data
74 MARIContractPositions
MPVKVertraegePositionen
ContractPositions Contract Management: Contract positions (also service master positions)
79 MARIAttendanceRuleHead
MPPersonenZeitenRegelKopf
AttendanceRuleHead Attendance: Working Time rules (Header)
102 MARIUserGroups
MPBenutzergruppen
UserGroups ProjectManagement: User Groups
103 MARIPurchaseProcess
MPEKVertraege
PurchaseProcess Purchase Process: Header
104 MARIPayrollTypes
MPLohnArten
PayrollTypes Payroll Interface: Payroll Types Master Data by company
105 MARISupportProductModules
MPHotlineProduktModul
SupportProductModules Support Module: Support Product: Master Data Modules
106 MARISupportProductVersions
MPHotlineProduktVersion
SupportProductVersions Support Module: Support Product: Master Data Versions
107 MARISupportGroup
MPHotlineGruppe
SupportGroup Support Module: Support Group: Header
109 MARISupportProductCustomer
MPHotlineProduktKunde
SupportProductCustomer Support Module: Support Product: Customer Product Link
110 MARIClassNotificationText
MPSysClassNotificationText
ClassNotificationText Event Management: Textdefinition master
112 MARIContractDocumentPositions
MPVKVertraegeBelegePositionen
ContractDocumentPositions Contract Management: Document Positions
113 MARITravelMilageAllowances
MPReiseKostenFahrzeugarten
TravelMilageAllowances Travel Expenses Module: Mileage allowances
130 MARIProjectTimeKeepingLinesServices
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
131 MARIProjectItemBooking
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
133 MARIServiceJobs
MPServiceJob
ServiceJobs MARIService: Service Job header
136 MARISysCustomerLanguages
MPSysKundenSprachen
SysCustomerLanguages System: Language
140 MARIPurchaseProcessDocumentPositions
MPEKVertraegeBelegePositionen
PurchaseProcessDocumentPositions Purchase Process: Purchase Document (Positions)
147 MARIPurchaseProcessPositions
MPEKVertraegePositionen
PurchaseProcessPositions Purchase Process: PO Process Position (equivilant to contract position)
151 MARITravelExpenseTypes
MPReise2KostenArten
TravelExpenseTypes Travel Expenses Module: Travel Expenses Types Master Data
152 MARITravelTemplate
MPReise2Template
TravelTemplate Travel Expenses Module: Template Header
153 MARITravelCountries
MPReise2Laender
TravelCountries Travel Expenses Module: Countries
154 MARITravelTrip
MPReise2
TravelTrip Travel Expenses Module: Business Trip Master
155 MARITravelTripLine
MPReise2Zeile
TravelTripLine Travel Expenses Module: Trip receipt line
159 MARITravelAccountingHeader
MPReise2BuchungKopf
TravelAccountingHeader Travel Expenses Module: Accounting Header
160 MARITravelPostingDocument
MPReise2BuchungBeleg
TravelPostingDocument Travel Expenses Module: Posting document
162 MARITextElements
MPTextbausteine
TextElements System: User-defined Text Elements
166 MARIProjectPhases
MPProjektPhasen
ProjectPhases Project Phases Master: Master Data (linked to project and planning version)
177 MARIEmployeeVacationRequest
MPPersonenUrlaubsAntrag
EmployeeVacationRequest Vacation Management: Vacation Request and Approval
182 MARISettingTypes
MPSetupTypen
SettingTypes Master Data: Selectable values with translation
192 MARIDocApproval
MPDocApproval
DocApproval Approval Process Definition
194 MARISysMessages
MPSysMessages
SysMessages System: eMail System (Header)
195 MARISysDocWorkflow
MPSysDocWorkflow
SysDocWorkflow Print Process: Definition Table
204 MARIProjectPlanningLines
MPProjektPlanungsZeilen
ProjectPlanningLines Planning: Master Planning lines
213 MARIQualityProcess
MPQualityProcess
QualityProcess QualityProcess Definition
214 MARIQualityStatus
MPQualityStatus
QualityStatus QualityStatus: Type of statuses
215 MARISysPlayerFrmActionFilm
MPSysPlayerFrmActionFilm
SysPlayerFrmActionFilm Player for stored scenarios: Film
216 MARISysPlayerFrmActionSequence
MPSysPlayerFrmActionSequence
SysPlayerFrmActionSequence Player for stored scenarios: Sequence
222 MARIEquipmentCategory
MPEquipmentCategory
EquipmentCategory EquipmentCategory: Cagetory Master
223 MARIEquipmentMaster
MPEquipment
EquipmentMaster Equipment: Master Data for each individual Equipment
224 MARIEquipmentCategorySubject
MPEquipmentCategorySubject
EquipmentCategorySubject EquipmentCategory: Standard cost types for categories
229 MARIXcelsiusFiles
MPXcelsiusFiles
XcelsiusFiles Xcelsius: Source Files for one Film
230 MARIXcelsiusFilms
MPXcelsiusFilms
XcelsiusFilms Xcelsius: one flash film
231 MARIContractRoundingDefinition
MPVertragRundung
ContractRoundingDefinition Defines Time Rounding Methods
236 MARIEquipmentSubjectBooking
MPEquipmentSubjectBooking
EquipmentSubjectBooking Time/Costbooking on Equipment data
249 MARILocation
MPLocation
Location Location: Place (India Localization)
250 MARISysUserQuery
MPSysUserQuery
SysUserQuery System: User Defined Queries
251 MARIInfoScreenManagementBreakEven
MPDBAuswertungen
InfoScreenManagementBreakEven Info Screen Management: Breakeven Analysis (Header)
252 MARISysClassApprovalRule
MPSysClassApprovalRule
SysClassApprovalRule Definition of Approval procedures
266 MARISysConnections
MPSysConnections
SysConnections System: Link to SBO company databases [!! Never edit this table !!]
270 MARIInfoScreenManagementBreakEvenColumnHead
MPDBColumnsDefinition
InfoScreenManagementBreakEvenColumnHead Info Screen Management: Column Definition Head
272 MARISupportSyncPartner
MPHotlineSyncPartner
SupportSyncPartner Support Module: Synchronizaion settings
274 MARIWorkInProgressDefinition
MPWorkInProgressDefinition
WorkInProgressDefinition Work In Progress Definition
278 MARITempReportDocumentHeader
MPTmpRptPrintBelegKopf
TempReportDocumentHeader Reporting: Temporary Table: Document Header
288 MARICommissionAccrual
MPCommissionAccrual
CommissionAccrual Commission: Stores the Accrual on Sales Invoicing Time (Project related)
289 MARICommissionAccrualSBO
MPCommissionAccrualSBO
CommissionAccrualSBO Commission: Stores the Accrual on Sales Invoicing Time (None Project related)
290 MARICommissionDocuments
MPCommissionDocuments
CommissionDocuments Commission: Sales Rep A/P Invoice Link
291 MARICommissionTypes
MPCommissionTypes
CommissionTypes Commission: Basic Settings for different Types
292 MARICommissionWizardLog
MPCommissionWizardLog
CommissionWizardLog Commission: Log of the usage
295 MARIContractCommission
MPVKVertraegeCommission
ContractCommission Contract Management: Link Sales Representetive to Contract
296 MARIJournalEntryExport
MPFiBuPositionen
JournalEntryExport Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress)
316 MARISysUserTable
MPSysUserTable
SysUserTable SDK: User-Defined Tables: Table description
319 MARISupportSLA
MPHotlineSLA
SupportSLA Support Module: Service Level Agreement Master
320 MARISupportSLASettings
MPHotlineSLASettings
SupportSLASettings Support Module: Service Level Agreement Settings
321 MARISupportSLANotification
MPHotlineSLANotification
SupportSLANotification Support Module: Service Level Agreement Notifications
324 MARISupportProductModuleVersions
MPHotlineProduktModulVersion
SupportProductModuleVersions Support Module: Support Product: Master Data Versions for Modules
326 MARICustomerServiceObject
MPCustomerEquipmentCard
CustomerServiceObject Advanced table to sbo standard customer equipment card
331 MARIPurchaseProcessDownPayments
MPEKVertraegeAnzahlungen
PurchaseProcessDownPayments Purchase Process: Down Payments
332 MARIContractDownPayments
MPVKVertraegeAnzahlungen
ContractDownPayments Contract Management: Contract Down Payments
347 MARIDocumentDraftHead
MPDocumentDraftHead
DocumentDraftHead Header for the draft document
349 MARIDocumentDraftPosition
MPDocumentDraftPosition
DocumentDraftPosition Positions based on the order of the paper document
351 MARIDocumentDraftPositionLink
MPDocumentDraftPositionLink
DocumentDraftPositionLink Linked positions in the sales contract and or purchase process
364 MARIWorkItem
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
366 MARIWorkItemPosition
MPWorkItemPosition
WorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource
372 MARIWorkItemResources
MPWorkItemResources
WorkItemResources Employees or Equipment necessary for the tasks
380 MARIWorkItemScheduleDates
MPWorkItemScheduleDates
WorkItemScheduleDates Recurring service tasks
382 MARISysActivityLink
MPSysActivityLink
SysActivityLink Link OCLG Activities to PM Objects
384 MARIQualityProcessQuestions
MPQualityProcessQuestions
QualityProcessQuestions QualityProcess Definition Questionnaire
385 MARICustomerServiceObjectCategory
MPCustomerEquipmentCardCategory
CustomerServiceObjectCategory Group to manage properties by group
386 MARICustomerServiceObjectLocation
MPCustomerEquipmentLocation
CustomerServiceObjectLocation Current location of a CSO at the client/Project
387 MARICustomerLocationTree
MPCustomerLocationTree
CustomerLocationTree Name of the location tree
388 MARICustomerLocationTreeElement
MPCustomerLocationTreeElement
CustomerLocationTreeElement Tree elements to manage levels, rooms of the customer
393 MARIWorkItemResults
MPWorkItemResults
WorkItemResults Results of quality process questionnaire
398 MARICustomerLocationTreeLink
MPCustomerLocationTreeLink
CustomerLocationTreeLink Link of a customer and a user to a tree or an element of the tree
403 MARIFolderDocuments
MPSammelmappe
FolderDocuments Master Data Folder Documents
438 MARITrainingParticipant
MPTrainingParticipant
TrainingParticipant Training Module: List Of Participants
439 MARITrainingRegistration
MPTrainingRegistration
TrainingRegistration Training Module: Registratrion to training cources
440 MARITrainingRegistrationTeam
MPTrainingRegistrationTeam
TrainingRegistrationTeam Training Module: Team for the training
441 MARITrainingRegistrationContractLink
MPTrainingRegistrationContractLink
TrainingRegistrationContractLink Training Module: Selection of billable contract positions (Contract from registration)
442 MARITrainingRegistrationPhaseLink
MPTrainingRegistrationPhaseLink
TrainingRegistrationPhaseLink Training Module: Selected options=Phases from the project linked to the training cource
442 MARITrainingRegistrationOptionLink
MPTrainingRegistrationOptionLink
TrainingRegistrationOptionLink Training Module: Selectable options (formaly phases)
443 MARITrainingRegistrationTeamLink
MPTrainingRegistrationTeamLink
TrainingRegistrationTeamLink Training Module: Link to the team
444 MARITrainingExams
MPTrainingExams
TrainingExams Training Module: List of exams
445 MARITrainingParticipantExams
MPTrainingParticipantExams
TrainingParticipantExams Training Module: Passed exams of participants
446 MARITrainingGrade
MPTrainingGrade
TrainingGrade Training Module: List of grades
447 MARITrainingParticipantGrades
MPTrainingParticipantGrades
TrainingParticipantGrades Training Module: Grades of participants
453 MARIDocumentDraftPositionLinkBatch
MPDocumentDraftPositionLinkBatch
DocumentDraftPositionLinkBatch Used batches
454 MARIDocumentDraftPositionLinkSerial
MPDocumentDraftPositionLinkSerial
DocumentDraftPositionLinkSerial Used/reserved serial numbers
465 MARIEquipmentDetails
MPEquipmentDetails
EquipmentDetails Equipment: Master Data "date from" based
466 MARIEquipmentDetailsLink
MPEquipmentDetailsLink
EquipmentDetailsLink Equipment Assembly: List of inner components
473 MARIOnlineCatalogTree
MPOnlineCatalogTree
OnlineCatalogTree OnlineCatalogTree: Build grouping for online shop
478 MARISysProRata
MPSysProRata
SysProRata Rule to spred revenue for mainenance positions to 12 month
524 MARISupportWorkflow
MPHotlineWorkFlow
SupportWorkflow Support Module: Workflow definition for the status
525 MARIProjectTimeKeepingReport
MPProjektBuchungserfassungBericht
ProjectTimeKeepingReport Time Keeping: Link Week Report of employee or for customer
535 MARIPurchaseProcessDocumentPositionsBatches
MPEKVertraegeBelegePositionenCharge
PurchaseProcessDocumentPositionsBatches Purchase Process: Purchase Document (Positions+Batches)
536 MARIPurchaseProcessDocumentPositionsSerialNumbers
MPEKVertraegeBelegePositionenSerie
PurchaseProcessDocumentPositionsSerialNumbers Purchase Process: Purchase Document (Positions+Serial)
537 MARIContractDocumentPositionsBatches
MPVKVertraegeBelegePositionenCharge
ContractDocumentPositionsBatches Contract Management: Document Positions Batches
538 MARIContractDocumentPositionsSerialNumbers
MPVKVertraegeBelegePositionenSerie
ContractDocumentPositionsSerialNumbers Contract Management: Document Positions Serial Numbers
555 MARIEmployeesCommissionSettings
MPPersonenProvisionsEinstellungen
EmployeesCommissionSettings Employee Master: Standard Settings for Commission by Employee
559 MARINewsletterFilterSet
MPNewsletterFilterSet
NewsletterFilterSet Predefined filter on the E-Mail sources
560 MARINewsletterMaster
MPNewsletterMaster
NewsletterMaster Newsletter Design Template
564 MARISysMasterProperties
MPSysMasterProperties
SysMasterProperties Property Settings for master data (Contract Person, Employees, Service Tasks, Events)
578 MARINewsletterLog
MPNewsletterLog
NewsletterLog Log the sending action of a new newsletter
580 MARINewsletterCampaign
MPNewsletterCampaign
NewsletterCampaign Source data for a plain newsletter (one time user)
581 MARIWorkItemPhaseCPosFilter
MPWorkItemPhaseCPosFilter
WorkItemPhaseCPosFilter Training Course: Filter selectable phases or contract positions
584 MARICommissionAccrualPeriods
MPCommissionAccrualPeriods
CommissionAccrualPeriods Commission: Monthly values for employee commission
625 MARISysArchivePattern
MPSysArchivePattern
SysArchivePattern Definition to tag and place documents into DMS
627 MARIAttendanceShiftRule
MPPersonenZeitenSchicht
AttendanceShiftRule Shift: Rule Definition
628 MARIAttendanceShiftPlan
MPPersonenZeitenSchichtPlan
AttendanceShiftPlan Shift: Standard Plan Rhythm
629 MARIAttendanceShiftPlanDays
MPPersonenZeitenSchichtPlanTag
AttendanceShiftPlanDays Shift: Standard Plan Rhythm Definition
644 MARITenantEnvironments
MPTenantEnvironments
TenantEnvironments Base client enviornment (master for over all clients)
645 MARITenantMonitorMachines
MPTenantMonitorMachines
TenantMonitorMachines Bucket to store installation data at client location: database servers, RDP Servers, Clients
646 MARITenantDatabases
MPTenantDatabases
TenantDatabases Management of MARIProject/SBO client datatabases
646 MARITenantMonitorDatabases
MPTenantMonitorDatabases
TenantMonitorDatabases Bucket to store installation data at client location: used databases
647 MARITenantTenants
MPTenantTenants
TenantTenants Management of MARIProject/SBO client installations
648 MARITenantMonitorAppInstallations
MPTenantMonitorAppInstallations
TenantMonitorAppInstallations Bucket to store installation data at client location: installed apps
650 MARITenantActions
MPTenantActions
TenantActions Action table to store (CreateUser, ChangeUser) Actions in the master database. To be consumed via web service or MARIService
651 MARITenantMonitorAppUsers
MPTenantMonitorAppUsers
TenantMonitorAppUsers Bucket to store installation data at client location: assigned users
651 MARITenantUsers
MPTenantUsers
TenantUsers Management of MARIProject/SBO client installation users
652 MARITenantMonitorAppUserGroups
MPTenantMonitorAppUserGroups
TenantMonitorAppUserGroups Bucket to store installation data at client location: installed user groups
653 MARITenantMonitorEnvironments
MPTenantMonitorEnvironments
TenantMonitorEnvironments Bucket to store installation data at client location: Information from SLD
654 MARITenantMonitorSysLogDebug
MPTenantMonitorSysLogDebug
TenantMonitorSysLogDebug Bucket to store installation data at client location: last 10 Sys Logs
655 MARITenantUserGroups
MPTenantUserGroups
TenantUserGroups Management of MARIProject/SBO client installations user groups
698 MARIBook
MPBuch
Book Project Dokumentation: Book Header
699 MARIBookPage
MPBuchSeite
BookPage Project Dokumentation: Book Page (Left hierarchy)
700 MARIBookPageContent
MPBuchSeitenInhalt
BookPageContent Project Dokumentation: Book Page Content Data
701 MARIBookPageElements
MPBuchSeitenElement
BookPageElements Project Dokumentation: Book Page Content Element
702 MARIBookPrint
MPBuchdruck
BookPrint Project Dokumentation: Print Defnition Head
703 MARIBookLink
MPBuchLink
BookLink Project Dokumentation: externale links to pages
760 MARITenantServices
MPTenantServices
TenantServices Manage monitoring web sites or RestServices at the clients
764 MARISysMasterPropertyStack
MPSysMasterPropertyStack
SysMasterPropertyStack Header Line for a set of properties

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany