MARIProject Database Structure


View English Description
MARIAccountingProfitCenterPlanningLine AccountingProfitCenterPlanningLine Store the financial planning on profit center level per month
MARIAccountingProfitCenterPlanningYear AccountingProfitCenterPlanningYear Store the financial planning on profit center level per year
MARIAddresses Addresses Business Partner: Used only for synchronization with other databases
MARIAddressProperties AddressProperties Additional Data for OCRD
MARIAttendanceAction AttendanceAction Attendance: Actions "in the door" (Lines per day)
MARIAttendanceActionArchive AttendanceActionArchive Attendance: Actions "in the door" (Lines per day) History
MARIAttendanceRule AttendanceRule Attendance: Working Time rules (Header valid from)
MARIAttendanceRuleDays AttendanceRuleDays Attandence: Actions "in the door" (Day header)
MARIAttendanceRuleDetail AttendanceRuleDetail Attendance: Working Time rules (Details for the rule)
MARIAttendanceRuleHead AttendanceRuleHead Attendance: Working Time rules (Header)
MARIAttendanceRuleShifts AttendanceRuleShifts Attendance: Working Time rules (Night shift additionals)
MARIAttendanceShiftPlan AttendanceShiftPlan Shift: Standard Plan Rhythm
MARIAttendanceShiftPlanDays AttendanceShiftPlanDays Shift: Standard Plan Rhythm Definition
MARIAttendanceShiftRule AttendanceShiftRule Shift: Rule Definition
MARIBankAccounts BankAccounts Bank Accounts: Used only for synchronization with other databases
MARIBankStatement BankStatement Header of a bank statement like OBNH
MARIBankStatementLine BankStatementLine Booking line of a bank statement
MARIBook Book Project Dokumentation: Book Header
MARIBookArchive BookArchive Project Dokumentation: Archived Book Content
MARIBookLayout BookLayout Project Dokumentation: Layout Definition of a content element
MARIBookLink BookLink Project Dokumentation: externale links to pages
MARIBookLinkArchive BookLinkArchive Project Dokumentation: externale link archive
MARIBookPage BookPage Project Dokumentation: Book Page (Left hierarchy)
MARIBookPageApproval BookPageApproval Project Dokumentation: Book Page Approval Flow
MARIBookPageArchive BookPageArchive Project Dokumentation: Book Page Archive (Left hierarchy)
MARIBookPageContent BookPageContent Project Dokumentation: Book Page Content Data
MARIBookPageContentArchive BookPageContentArchive Project Dokumentation: Book Page Content Data Archive
MARIBookPageElementArchive BookPageElementArchive Project Dokumentation: Book Page Content Element Archive
MARIBookPageElements BookPageElements Project Dokumentation: Book Page Content Element
MARIBookPrint BookPrint Project Dokumentation: Print Defnition Head
MARIBookPrintAttachments BookPrintAttachments Project Dokumentation: Print Defnition AttachementSelection
MARIBookPrintFolder BookPrintFolder Project Dokumentation: Print Defnition Linked Folder Documents
MARIBookPrintPages BookPrintPages Project Dokumentation: Print Defnition Book pages
MARIBookPrintSequence BookPrintSequence Project Dokumentation: Print Action Head
MARIBookPrintSequenceElements BookPrintSequenceElements Project Dokumentation: Print Action PageElementPrintLines
MARIBookPrintTableOfContent BookPrintTableOfContent Project Dokumentation: Print Action Table of Content
MARIBookProperties BookProperties Project Dokumentation: Book Properties
MARIBookPropertiesArchive BookPropertiesArchive Project Dokumentation: Book Archived Properties
MARIBookPropertiesUser BookPropertiesUser Project Dokumentation: Book User Properties
MARIBusinessUnitMaster BusinessUnitMaster Business Units: Master Data
MARICalendar Calendar Calendar Management: Calendar Header
MARICalendarDayPresets CalendarDayPresets Calendar Management: Stadard for Monday,Tuesday..
MARICalendarDays CalendarDays Calendar Management: Calendar Day Definition
MARICalendarPeriod CalendarPeriod Calendar Management: Calendar Month (Period)
MARICalendarTemplateDays CalendarTemplateDays Calendar Management: Public Holiday Rules per Day
MARICalendarTemplates CalendarTemplates Calendar Management: Public Holiday Rules
MARIChefInfoCashFlowRun ChefInfoCashFlowRun Info Screen Management: Daily cash flow run
MARIChefInfoCashFlowRunLine ChefInfoCashFlowRunLine Info Screen Management: Stored line data per run
MARIChefInfoCashFlowRunProject ChefInfoCashFlowRunProject Info Screen Management: Status of a project
MARIChefInfoChart ChefInfoChart Info Screen Management: Status Settings for chart design
MARIChefInfoChartCol ChefInfoChartCol Info Screen Management: Status Settings for chart design Columns and data sources
MARIChefInfoDashboard ChefInfoDashboard Project Dash Board Settings
MARIChefInfoDashboardTiles ChefInfoDashboardTiles Project Dash Board Settings Tiles
MARIClassNotificationReceipients ClassNotificationReceipients Event Management: Additional receipients for core data
MARIClassNotificationText ClassNotificationText Event Management: Textdefinition master
MARIClassNotificationTextLang ClassNotificationTextLang Event Management: Textdefinitions by language
MARICommissionAccrual CommissionAccrual Commission: Stores the Accrual on Sales Invoicing Time (Project related)
MARICommissionAccrualPeriods CommissionAccrualPeriods Commission: Monthly values for employee commission
MARICommissionAccrualSBO CommissionAccrualSBO Commission: Stores the Accrual on Sales Invoicing Time (None Project related)
MARICommissionDocumentPositions CommissionDocumentPositions Commission: Sales Rep A/P Invoice Position Link
MARICommissionDocuments CommissionDocuments Commission: Sales Rep A/P Invoice Link
MARICommissionTypes CommissionTypes Commission: Basic Settings for different Types
MARICommissionTypesRules CommissionTypesRules Commission: Percentage Definition
MARICommissionWizardLog CommissionWizardLog Commission: Log of the usage
MARIContactPerson ContactPerson Contact Person: Used only for synchronization with other databases
MARIContainer Container Definition of a container carrying other goods
MARIContainerAddress ContainerAddress Addtional information for trucks as container for shipping
MARIContainerBatchSN ContainerBatchSN Linked batches of serialnumbers for a line in the container
MARIContainerCategory ContainerCategory Container Categtrory to manage special settings
MARIContainerLine ContainerLine Container Lines to see the goods in the container
MARIContainerLocation ContainerLocation Current location of a container
MARIContract Contract Contract Management: Contract Master Data + Service Master Data
MARIContractCalculation ContractCalculation Cotnract Sales Prices Calculation Method Head
MARIContractCalculationFields ContractCalculationFields Cotnract Sales Prices Calculation Method Fields
MARIContractCommission ContractCommission Contract Management: Link Sales Representetive to Contract
MARIContractCommissionPos ContractCommissionPos Contract Management: Percentage for each position for the commission receipient
MARIContractCustomerDocuments ContractCustomerDocuments Drawings to be created for the customer
MARIContractDocument ContractDocument Contract Management: Sales Documents
MARIContractDocumentApproval ContractDocumentApproval Contract Management: Document Approval
MARIContractDocumentAttachments ContractDocumentAttachments Contract Management: Attachment Selection
MARIContractDocumentEInvoice ContractDocumentEInvoice Contract Management: Additional information for PEPPOL
MARIContractDocumentErrors ContractDocumentErrors Contract Management: Document Error Info
MARIContractDocumentInstallments ContractDocumentInstallments Contract Management: Document Payment Conditions
MARIContractDocumentISCHead ContractDocumentISCHead Contract Management: Document Internal Service Charges Head
MARIContractDocumentISCPos ContractDocumentISCPos Contract Management: Document Internal Service Charges Positions
MARIContractDocumentISCPosTax ContractDocumentISCPosTax Contract Management: Document Internal Service Charges Positions Tax
MARIContractDocumentLink ContractDocumentLink Contract Management: Document Link to down payments
MARIContractDocumentPositions ContractDocumentPositions Contract Management: Document Positions
MARIContractDocumentPositionsBatches ContractDocumentPositionsBatches Contract Management: Document Positions Batches
MARIContractDocumentPositionsSerialNumbers ContractDocumentPositionsSerialNumbers Contract Management: Document Positions Serial Numbers
MARIContractDocumentPositionsTax ContractDocumentPositionsTax Contract Management: Document Positions Tax
MARIContractDocumentPrintHistory ContractDocumentPrintHistory Contract Management: Print History
MARIContractDocumentReturnRevenueLink ContractDocumentReturnRevenueLink Contract Management: [not used]
MARIContractDocumentTAX ContractDocumentTAX Contract Management: Document TAX
MARIContractDownPayments ContractDownPayments Contract Management: Contract Down Payments
MARIContractInstallmentPlan ContractInstallmentPlan Contract Management: Contract Invoicing plan
MARIContractInstallments ContractInstallments Contract Management: Installment Plan
MARIContractPOPositionLink ContractPOPositionLink Contract Management: Contract link to PO Process by position
MARIContractPosition2DocumentPosition ContractPosition2DocumentPosition Contract Management: Contract document position to document position link
MARIContractPosition2POPosition ContractPosition2POPosition Contract Management: Contract position to PO position link
MARIContractPosition2Service ContractPosition2Service Contract Management: Contract position to Customer Service Object and parts
MARIContractPositionDefinition ContractPositionDefinition Contract Management: Contract position extra field definition
MARIContractPositionEmployee ContractPositionEmployee Contract Management: Contract position employee link
MARIContractPositionEquipment ContractPositionEquipment Contract Management: Link an equipment to the contract position
MARIContractPositionMeasurementDimension ContractPositionMeasurementDimension Contract Position Workpackage definition: Dimension
MARIContractPositionMeasurementLine ContractPositionMeasurementLine Contract Position Workpackage definition: Structure Lines
MARIContractPositionMeasurementValues ContractPositionMeasurementValues Contract Position Workpackage definition: Values
MARIContractPositionPayment ContractPositionPayment Contract Management: Contract positions accounting lines (due date, phase ...)
MARIContractPositionPhase ContractPositionPhase Contract Management: Contract position phase link
MARIContractPositions ContractPositions Contract Management: Contract positions (also service master positions)
MARIContractPositionTextElements ContractPositionTextElements Contract Management: Contract position texts (standard definition)
MARIContractReturnRevenueAccountDef ContractReturnRevenueAccountDef Contract Management: Contract revenue return account definition
MARIContractRoundingDefinition ContractRoundingDefinition Defines Time Rounding Methods
MARIContractRoundingDefinitionDetails ContractRoundingDefinitionDetails Defines Time Rounding Methods (From Qty/To Qty)
MARIContractTextElements ContractTextElements Contract Management: Contract header footer texts (standard definition)
MARICreditCardMapping CreditCardMapping Stores Credit Card Information to Business Partner and Employees for CreditCard Import
MARICustomerLocationTree CustomerLocationTree Name of the location tree
MARICustomerLocationTreeElement CustomerLocationTreeElement Tree elements to manage levels, rooms of the customer
MARICustomerLocationTreeLink CustomerLocationTreeLink Link of a customer and a user to a tree or an element of the tree
MARICustomerServiceObject CustomerServiceObject Advanced table to sbo standard customer equipment card
MARICustomerServiceObjectCategory CustomerServiceObjectCategory Group to manage properties by group
MARICustomerServiceObjectLocation CustomerServiceObjectLocation Current location of a CSO at the client/Project
MARIDocApproval DocApproval Approval Process Definition
MARIDocApprovalLink DocApprovalLink Special Approval Rules per contract
MARIDocApprovalRessources DocApprovalRessources Steps in the approval process. Rule Lines (Steps) for each approval prioritry. The rules are used from top (Priority=0) to button.
MARIDocApprovalRessourcesSub DocApprovalRessourcesSub Store 1:n the Receipients for serial or chain approvals
MARIDocumentDraftHead DocumentDraftHead Header for the draft document
MARIDocumentDraftHeadApproval DocumentDraftHeadApproval Approval or workflow list for the draft document
MARIDocumentDraftHeadLink DocumentDraftHeadLink Linked contracts and purchase processes
MARIDocumentDraftInstallments DocumentDraftInstallments Payment conditions and installments
MARIDocumentDraftPosition DocumentDraftPosition Positions based on the order of the paper document
MARIDocumentDraftPositionLink DocumentDraftPositionLink Linked positions in the sales contract and or purchase process
MARIDocumentDraftPositionLinkBatch DocumentDraftPositionLinkBatch Used batches
MARIDocumentDraftPositionLinkSerial DocumentDraftPositionLinkSerial Used/reserved serial numbers
MARIDocumentDraftPositionLinkTax DocumentDraftPositionLinkTax Linked positions in the sales contract and or purchase process sub tax
MARIDocumentDraftPositionTax DocumentDraftPositionTax Positions based on the order of the paper document sub tax
MARIDocumentDraftTax DocumentDraftTax Tax information
MARIDocumentInvoiceFlow DocumentInvoiceFlow InvoicePaymentReportStore
MARIDocumentInvoiceFlowPosition DocumentInvoiceFlowPosition InvoicePaymentReportStore Positions
MARIDocumentRecipient DocumentRecipient Definition of eMail Recipients for documents out of a contract.
MARIDocuments Documents Documents linked in the Folder tabs of the master data
MARIDocumentsVersions DocumentsVersions Revision History of a document
MARIDocValidation DocValidation Validation rule for A/P invoices based on the linked purchase order
MARIDocValidationResource DocValidationResource Validation rule details for A/P invoices based on the linked purchase order
MARIEmployeeAnnualVacation EmployeeAnnualVacation Employee Master: Vacation Management Annual Vacation
MARIEmployeeCostRates EmployeeCostRates Employee Master: Cost Rates
MARIEmployeeCostRatesProject EmployeeCostRatesProject Employee Master: Cost Rates per project for freelancers
MARIEmployeeMaster EmployeeMaster Employee Master: Employee Master
MARIEmployeeProperties EmployeeProperties Employee Master: Additional Settings
MARIEmployeeProtocol EmployeeProtocol Error Message Protocol
MARIEmployeesCommissionSettings EmployeesCommissionSettings Employee Master: Standard Settings for Commission by Employee
MARIEmployeeSkills EmployeeSkills Employee Master: Employee Skill link
MARIEmployeesOrganisation EmployeesOrganisation Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period
MARIEmployeesPeriod EmployeesPeriod Employee Master: One line per employee and valid from period and business unit
MARIEmployeesPool EmployeesPool Employee Master: Employee Pool link
MARIEmployeesProjectLinks EmployeesProjectLinks Employee Master: Project link (standard vacation project...)
MARIEmployeesService EmployeesService Employee Master: Linked services
MARIEmployeesTravelMilage EmployeesTravelMilage Employee Master: Linked mileage allowances
MARIEmployeesTrip2TravelMilage EmployeesTrip2TravelMilage Travel Expenses Module: Employee Mileage type (header)
MARIEmployeesTrip2TravelMilageSub EmployeesTrip2TravelMilageSub Travel Expenses Module: Employee Mileage type (sub)
MARIEmployeeVacationRequest EmployeeVacationRequest Vacation Management: Vacation Request and Approval
MARIEmployeeVacationRequestApproval EmployeeVacationRequestApproval Vacation Management: Link to steps of approval process
MARIEmployeeVacationRequestDays EmployeeVacationRequestDays Vacation Management: Link days for special day request
MARIEquipmentCategory EquipmentCategory EquipmentCategory: Cagetory Master
MARIEquipmentCategoryBPCatalog EquipmentCategoryBPCatalog EquipmentCategory: Business Partner Catalog Number
MARIEquipmentCategorySubject EquipmentCategorySubject EquipmentCategory: Standard cost types for categories
MARIEquipmentCategorySubjectRates EquipmentCategorySubjectRates EquipmentCategory: Standard cost and sales prices for the cost types of categories
MARIEquipmentDetails EquipmentDetails Equipment: Master Data "date from" based
MARIEquipmentDetailsLink EquipmentDetailsLink Equipment Assembly: List of inner components
MARIEquipmentDetailsSerial EquipmentDetailsSerial Equipment: Master Data "Date from" based serial numbers
MARIEquipmentLocation EquipmentLocation Equipment: Current Location of this equipment
MARIEquipmentMaster EquipmentMaster Equipment: Master Data for each individual Equipment
MARIEquipmentReminder EquipmentReminder Equipment: recurrent dates for each equipment
MARIEquipmentSubjectBooking EquipmentSubjectBooking Time/Costbooking on Equipment data
MARIEquipmentSubjectRates EquipmentSubjectRates Equipment: Specific cost rates
MARIEquipmentSubjectRatesBU EquipmentSubjectRatesBU Equipment: Specific cost and sales rates for internal service charges
MARIFolderDocuments FolderDocuments Master Data Folder Documents
MARIFolderDocumentsGroups FolderDocumentsGroups Document Tab Registers
MARIFolderDocumentTree FolderDocumentTree Master Data Folder Search Tree
MARIFolderIndex FolderIndex Document tagging
MARIFolderIndexFields FolderIndexFields Definition of document tags
MARIFolderIndexFormFields FolderIndexFormFields Link of index fields to an index form
MARIFolderIndexForms FolderIndexForms Defining additional index forms
MARIFolderIndexOCR FolderIndexOCR Additional Information via Document Recognition Services
MARIFolderIndexValues FolderIndexValues Index Form Values for MARIDMS
MARIFormAuthorization FormAuthorization Authorization for each form and report
MARIGroups Groups Groups used for a long list of master data. See the GruppenArt enumeration
MARIGroupsEquipment GroupsEquipment Groups for Equipment and EquipmentCategories
MARIInfoScreenManagementBreakEven InfoScreenManagementBreakEven Info Screen Management: Breakeven Analysis (Header)
MARIInfoScreenManagementBreakEvenAccounts InfoScreenManagementBreakEvenAccounts Info Screen Management: Breakeven Analysis (Accounts)
MARIInfoScreenManagementBreakEvenCollection InfoScreenManagementBreakEvenCollection Info Screen Management: Breakeven Analysis (Export Header)
MARIInfoScreenManagementBreakEvenCollectionItems InfoScreenManagementBreakEvenCollectionItems Info Screen Management: Breakeven Analysis (Export Line)
MARIInfoScreenManagementBreakEvenColumnDef InfoScreenManagementBreakEvenColumnDef Info Screen Management: Column Definition Columns
MARIInfoScreenManagementBreakEvenColumnHead InfoScreenManagementBreakEvenColumnHead Info Screen Management: Column Definition Head
MARIInfoScreenManagementBreakEvenPos InfoScreenManagementBreakEvenPos Info Screen Management: Breakeven Analysis (Lines)
MARIInfoScreenManagementBreakEvenSettings InfoScreenManagementBreakEvenSettings Info Screen Management: Breakeven Analysis (Settings for Cash Flow)
MARIInfoScreenManagementData InfoScreenManagementData Info Screen Management: Export Data
MARIInfoScreenManagementEmployee InfoScreenManagementEmployee Info Screen Management: Export Employees
MARIInfoScreenManagementHead InfoScreenManagementHead Info Screen Management: Export Header
MARIInfoScreenManagementKey InfoScreenManagementKey Info Screen Management: Export Keys
MARIInfoScreenManagementPool InfoScreenManagementPool Info Screen Management: Export Pools
MARIInfoScreenManagementProject InfoScreenManagementProject Info Screen Management: Export Projects
MARIInfoScreenManagementUserColumn InfoScreenManagementUserColumn Info Screen Management: User-defined column settings
MARIInfoScreenManagementUserColumns InfoScreenManagementUserColumns Info Screen Management: User-defined columns
MARIInfoScreenManagementUserStore InfoScreenManagementUserStore Info Screen Management: Store filter settings (Header)
MARIInfoScreenManagementUserStoreOptions InfoScreenManagementUserStoreOptions Info Screen Management: Store filter settings (Line)
MARIInfoScreenManagementUserTree InfoScreenManagementUserTree Info Screen Management: Store tree selection
MARIInfoScreenManagementUserView InfoScreenManagementUserView Info Screen Management: Store selected analysis
MARIInfoSimulationBusinessUnits InfoSimulationBusinessUnits Plannings Simulator: Dimension Business Unit
MARIInfoSimulationBusinessUnitsEmployees InfoSimulationBusinessUnitsEmployees Plannings Simulator: Dimension Business Unit / Employees
MARIInfoSimulationGroups InfoSimulationGroups Plannings Simulator: Dimension Groups
MARIInfoSimulationHead InfoSimulationHead Plannings Simulator: Header
MARIInfoSimulationProjectEmployees InfoSimulationProjectEmployees Plannings Simulator: Dimension Projects/Employees
MARIInfoSimulationProjects InfoSimulationProjects Plannings Simulator: Dimension Projects
MARIInfoSimulationResources InfoSimulationResources Plannings Simulator: Dimension Resources
MARIInfoSimulationResourcesEmpoyees InfoSimulationResourcesEmpoyees Plannings Simulator: Dimension Resources/Employees
MARIInfoSimulationSettings InfoSimulationSettings Plannings Simulator: Settings
MARIInterfaceImportLog InterfaceImportLog Logging of MARIInterface Messages and action
MARIItemGroupProperties ItemGroupProperties Item Groups: Additional fields for maintenance and purchase order
MARIItemProperties ItemProperties Item Master: Additional fields for maintenance and purchase order
MARIJournalEntryExport JournalEntryExport Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress)
MARIJournalEntryExportBatch JournalEntryExportBatch Journal Entries Header Table per run
MARIJournalEntryExportCancel JournalEntryExportCancel Journal Entries Canceled Records (Travel Expenses, Internal Service Charges, Work in Progress)
MARIJournalEntryExportDocument JournalEntryExportDocument Journal Entries Export Document Head
MARIJournalEntryImportStack JournalEntryImportStack Journal Entry Import Flaggs
MARIJournalEntryISCRule JournalEntryISCRule Definitions for Internal Service Charge Wizard
MARIJournalEntryISCRuleLine JournalEntryISCRuleLine Definitions for Internal Service Charge Wizard Lines
MARIKnowledgeBaseEntry KnowledgeBaseEntry Support Module: Knowledge Base Header
MARIKnowledgeBaseEntryKeyWords KnowledgeBaseEntryKeyWords Support Module: Knowledge Base Key Words
MARIKnowledgeBaseEntryLanguage KnowledgeBaseEntryLanguage Support Module: Knowledge Base Languages
MARIKnowledgeBaseEntryReference KnowledgeBaseEntryReference Support Module: Knowledge Base Product link
MARILocation Location Location: Place (India Localization)
MARILocationCompany LocationCompany Location: Link to locations in SBO database (India Localization)
MARILocationDistance LocationDistance Distance between locations
MARIMaterDataProperties MaterDataProperties Master Data Extra Properties. Universal table
MARIMPExchangeSync MPExchangeSync MS Exchange Server Link Log
MARIMPExchangeSyncLine MPExchangeSyncLine MS Exchange Server Link Planning Line
MARIMSProjectDatabases MSProjectDatabases MS Project Interface: Database Link (MSP Server)
MARIMSProjectEmployees MSProjectEmployees MS Project Interface: Employee/resource link
MARIMSProjectImports MSProjectImports MS Project Interface: Import log
MARIMSProjectParameters MSProjectParameters MS Project Interface: Export Import Parameter
MARIMSProjectPhases MSProjectPhases MS Project Interface: Phase/task link
MARINewsletterCampaign NewsletterCampaign Source data for a plain newsletter (one time user)
MARINewsletterConnector NewsletterConnector Store special email server connections
MARINewsletterFilterSet NewsletterFilterSet Predefined filter on the E-Mail sources
MARINewsletterLog NewsletterLog Log the sending action of a new newsletter
MARINewsletterMaster NewsletterMaster Newsletter Design Template
MARINumberPool NumberPool Work Items: Number Pool
MARIOnlineCatalogTree OnlineCatalogTree OnlineCatalogTree: Build grouping for online shop
MARIOnlineCatalogTreeElement OnlineCatalogTreeElement OnlineCatalogTree: Lines in the grouping
MARIOnlineCatalogTreeElementContent OnlineCatalogTreeElementContent OnlineCatalogTree: rules to biuld one line
MARIOnlineCatalogTreeLink OnlineCatalogTreeLink OnlineCatalogTree: Link to business partner
MARIPayrollLine PayrollLine Payroll Interface: Export Lines
MARIPayrollLineAttachment PayrollLineAttachment Payroll Interface: Export Lines Source Details
MARIPayrollSettings PayrollSettings Payroll Interface: Payroll Types Settings
MARIPayrollStack PayrollStack Payroll Interface: Export Header
MARIPayrollTypeGroup PayrollTypeGroup Payroll Interface: Payroll Types Master Data global
MARIPayrollTypeGroupLink PayrollTypeGroupLink Payroll Interface: Payroll Types Link
MARIPayrollTypes PayrollTypes Payroll Interface: Payroll Types Master Data by company
MARIPeriods 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
MARIPeriodsCalendarWeeks PeriodsCalendarWeeks Calendar Management: CalendarWeeks by ISO
MARIPeriodsExchangeRates PeriodsExchangeRates Calendar Management: Monthly currency exchange rates
MARIPictures Pictures Images linked to support issues, employees...
MARIPicturesVersions PicturesVersions Revisions of the pirctures
MARIPriceIndex PriceIndex Maintenance: Price Index Header
MARIPriceIndexHeader PriceIndexHeader Maintenance: Price Index Protocol of wizard (Header)
MARIPriceIndexLine PriceIndexLine Maintenance: Price Index Protocol of wizard (per position)
MARIPriceIndexPeriod PriceIndexPeriod Maintenance: Price Index per month
MARIProjectBookingErrors ProjectBookingErrors Time Keeping: Error log in the time keeping
MARIProjectBookingsFavorits ProjectBookingsFavorits Time Keeping: Favorits
MARIProjectCustomerLink ProjectCustomerLink Project Master: Customer Link
MARIProjectGroups ProjectGroups Project Master: Project Groups
MARIProjectItemBooking 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
MARIProjectItemBookingSerialNumbers ProjectItemBookingSerialNumbers Time Keeping: ProjectTimeKeepingItemsSeries: Serial numbers
MARIProjectManager ProjectManager Project Master: Linked project manager
MARIProjectMaster ProjectMaster Project Master: Master Data
MARIProjectMasterWorkInProgess ProjectMasterWorkInProgess Project Master: Save degree of compleation for each month
MARIProjectMeasurementStructure ProjectMeasurementStructure Measurement strucutre definition: Head
MARIProjectMeasurementStructureDimension ProjectMeasurementStructureDimension Measurement strucutre definition: Used dimensions
MARIProjectMeasurementStructureElement ProjectMeasurementStructureElement Measurement strucutre definition: Structure Lines
MARIProjectMeasurementStructureProject ProjectMeasurementStructureProject Measurement strucutre definition: Link to project
MARIProjectMeasurementStructureValues ProjectMeasurementStructureValues Measurement strucutre definition: Measurement values
MARIProjectPhaseBudget ProjectPhaseBudget Project Phases Master: Budget
MARIProjectPhaseDegreeOfCompletion ProjectPhaseDegreeOfCompletion Project Phases Master: Degree OF Completion History
MARIProjectPhaseEmployeeFeedback ProjectPhaseEmployeeFeedback Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion
MARIProjectPhaseEmployeeLink ProjectPhaseEmployeeLink Project Phases Master: Employee link
MARIProjectPhasePredecessor ProjectPhasePredecessor Project Phases Phase Predecessors
MARIProjectPhases ProjectPhases Project Phases Master: Master Data (linked to project and planning version)
MARIProjectPhaseStatusHistory ProjectPhaseStatusHistory Stores the phase stauts of a project
MARIProjectPlanningLines ProjectPlanningLines Planning: Master Planning lines
MARIProjectPlanningLinesLog ProjectPlanningLinesLog Planning: Master Planning lines History
MARIProjectPlanningLog ProjectPlanningLog Planning: Log Phase dependency changes
MARIProjectPlanningResource ProjectPlanningResource Planning: Filter list for plannable resources (ex. G/L Accounts)
MARIProjectPlanningVersions ProjectPlanningVersions Project Master: Planning versions linked to a project
MARIProjectStatus ProjectStatus Project Master: status history
MARIProjectTimeKeepingHeader 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).
MARIProjectTimeKeepingLines ProjectTimeKeepingLines Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type
MARIProjectTimeKeepingLinesAddOnCategory ProjectTimeKeepingLinesAddOnCategory Time Keeping: AddOnCategoryDetails
MARIProjectTimeKeepingLinesServices 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
MARIProjectTimeKeepingReport ProjectTimeKeepingReport Time Keeping: Link Week Report of employee or for customer
MARIProjectTravelExpenseRules ProjectTravelExpenseRules Travel Expenses Module: Properties by Project
MARIProjectTravelExpenseTemplates ProjectTravelExpenseTemplates Travel Expenses Module: Properties by Project
MARIProjectWorkGroup ProjectWorkGroup Project Master: Work group
MARIProjectWorkPackageEntry ProjectWorkPackageEntry Work Packages progress reporting by day
MARIProjectWorkPackageEntryValues ProjectWorkPackageEntryValues Work Packages progress reporting by structure element
MARIPurchaseImportDocument PurchaseImportDocument Purchase Order: Import external documents (Header)
MARIPurchaseImportDocumentPos PurchaseImportDocumentPos Purchase Order: Import external documents (Line)
MARIPurchaseImportDocumentPos2POProcessPos PurchaseImportDocumentPos2POProcessPos Purchase Order: Import external documents (Link to PO Process lines)
MARIPurchaseProcess PurchaseProcess Purchase Process: Header
MARIPurchaseProcessDocument PurchaseProcessDocument Purchase Process: Purchase Document (Header)
MARIPurchaseProcessDocumentApproval PurchaseProcessDocumentApproval Purchase Process: Document Approval Employee Link
MARIPurchaseProcessDocumentAttachments PurchaseProcessDocumentAttachments Purchase Process: Link to Attachments
MARIPurchaseProcessDocumentCommision PurchaseProcessDocumentCommision Purchase Process: Purchase Document Bonus definition
MARIPurchaseProcessDocumentCommisionPos PurchaseProcessDocumentCommisionPos Purchase Process: Purchase Document Bonus position definition
MARIPurchaseProcessDocumentEInvoice PurchaseProcessDocumentEInvoice Purchase Process: Extra Information peparing an electronic document
MARIPurchaseProcessDocumentError PurchaseProcessDocumentError Purchase Process: Saved Errors
MARIPurchaseProcessDocumentInstallments PurchaseProcessDocumentInstallments Purchase Process: Purchase Document (Payment conditions)
MARIPurchaseProcessDocumentISCHead PurchaseProcessDocumentISCHead Purchase Process: Document Internal Service Change Head
MARIPurchaseProcessDocumentISCPos PurchaseProcessDocumentISCPos Purchase Process: Document Internal Service Change Positions
MARIPurchaseProcessDocumentISCPosTax PurchaseProcessDocumentISCPosTax Purchase Process: Document Internal Service Change Positions Tax
MARIPurchaseProcessDocumentLink PurchaseProcessDocumentLink Purchase Process: Purchase Document Link to down payments
MARIPurchaseProcessDocumentPositions PurchaseProcessDocumentPositions Purchase Process: Purchase Document (Positions)
MARIPurchaseProcessDocumentPositionsBatches PurchaseProcessDocumentPositionsBatches Purchase Process: Purchase Document (Positions+Batches)
MARIPurchaseProcessDocumentPositionsSerialNumbers PurchaseProcessDocumentPositionsSerialNumbers Purchase Process: Purchase Document (Positions+Serial)
MARIPurchaseProcessDocumentPositionsTax PurchaseProcessDocumentPositionsTax Purchase Process: Purchase Document (Positions+Tax)
MARIPurchaseProcessDocumentPrint PurchaseProcessDocumentPrint Purchase Process: Print history
MARIPurchaseProcessDocumentTax PurchaseProcessDocumentTax Purchase Process: Purchase Document (Tax)
MARIPurchaseProcessDownPayments PurchaseProcessDownPayments Purchase Process: Down Payments
MARIPurchaseProcessInstallments PurchaseProcessInstallments Purchase Process: Installment Plan
MARIPurchaseProcessPaymentPlan PurchaseProcessPaymentPlan Purchase Process: Payment plan (not used in PO)
MARIPurchaseProcessPos2Service PurchaseProcessPos2Service Purchase Process: Link Position to Customer Service Object or parts
MARIPurchaseProcessPosDocPosLink PurchaseProcessPosDocPosLink Purchase Process: Link between PO document line and PO process position
MARIPurchaseProcessPositionAccounting PurchaseProcessPositionAccounting Purchase Process: Accounting lines (due date, phase ...)
MARIPurchaseProcessPositionDefinition PurchaseProcessPositionDefinition Purchase Process: Definition of extra fields by position type
MARIPurchaseProcessPositionEmployees PurchaseProcessPositionEmployees Purchase Process: Employees linked to a position
MARIPurchaseProcessPositionEquipment PurchaseProcessPositionEquipment Purchase Process: Equipment linked to a position
MARIPurchaseProcessPositionPhases PurchaseProcessPositionPhases Purchase Process: Phases linked to a position
MARIPurchaseProcessPositions PurchaseProcessPositions Purchase Process: PO Process Position (equivilant to contract position)
MARIPurchaseProcessPositionTextelements PurchaseProcessPositionTextelements Purchase Process: Text definition (master data) for positions
MARIPurchaseProcessReturnRevenueDefinition PurchaseProcessReturnRevenueDefinition Purchase Process: Revenue Return Account Definition (not used in PO)
MARIPurchaseProcessText PurchaseProcessText Purchase Process: Text definition (master data) for header, footer
MARIQualityProcess QualityProcess QualityProcess Definition
MARIQualityProcessLink QualityProcessLink QualityProcess Combine Checklists to a master list
MARIQualityProcessQuestions QualityProcessQuestions QualityProcess Definition Questionnaire
MARIQualityProcessResults QualityProcessResults QualityProcess Result for each question of the questionaire
MARIQualityProcessSettings QualityProcessSettings QualityProcess Special Settings for each process
MARIQualityStatus QualityStatus QualityStatus: Type of statuses
MARIReminder Reminder System: Reminder
MARIResourcePool ResourcePool Resource Pool: Master Data
MARIResourcePoolBPTeam ResourcePoolBPTeam External resource team (Supplier, customer)
MARIResourcePoolBPTeamCostRates ResourcePoolBPTeamCostRates Cost rates for external resource team
MARIResourcePoolBPTeamLink ResourcePoolBPTeamLink Link between resource pool and external resource team
MARIResourcePoolCostRates ResourcePoolCostRates Resource Pool: Cost Rates
MARIServiceAsyncAction ServiceAsyncAction To Do Table for MARIService to send messages async
MARIServiceJobParameter ServiceJobParameter MARIService: Service Job settings
MARIServiceJobs ServiceJobs MARIService: Service Job header
MARIServiceJobSchedule ServiceJobSchedule MARIService: Service Job timing
MARIServiceJournal ServiceJournal MARIService: Service Job log header
MARIServiceJournalMessage ServiceJournalMessage MARIService: Service Job log messages
MARIServiceJournalParameter ServiceJournalParameter MARIService: Service Job log parameters
MARIServicePools ServicePools Service Master: Master Data Pool link
MARIServices 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
MARISettingsBusinessUnit SettingsBusinessUnit Master Data: Settings by business unit
MARISettingsBusinessUnitAccountingVersion SettingsBusinessUnitAccountingVersion Internal Service Changes: Setting of type BU vs. BU
MARISettingsBusinessUnitMatrix SettingsBusinessUnitMatrix Master Data: Settings by business unit in matrix
MARISettingsCompany SettingsCompany Master Data: Settings by company
MARISettingsCompanyEInvoice SettingsCompanyEInvoice Master Data: Electronic Invoice settings by company
MARISettingsCompanyMatrix SettingsCompanyMatrix Master Data: Settings by company in matrix
MARISettingTypes SettingTypes Master Data: Selectable values with translation
MARISetupClientSettings SetupClientSettings Kiosk Mobile Clients
MARISetupFormControlsBrowserSettings SetupFormControlsBrowserSettings System Table for user grid settings
MARISetupFormControlsSettings SetupFormControlsSettings System table for user control settings
MARISetupQuantityFieldBase SetupQuantityFieldBase Field definition for quantity formular
MARISetupQuantityFieldBaseCompany SetupQuantityFieldBaseCompany Link to UDF in the company
MARISetupQuantityFormular SetupQuantityFormular Quantity Formular Head
MARISetupQuantityFormularField SetupQuantityFormularField Quantity Formular Lines
MARISetupUserBrowserTree SetupUserBrowserTree Master Data: Store Tree Selection
MARISetupUserFormularFields SetupUserFormularFields Master Data: Settings by user and form
MARISetupUserFormularPos SetupUserFormularPos Master Data: Settings by user, form and form element
MARISetupUserSettings SetupUserSettings Master Data: Settings by user
MARISetupVacationType SetupVacationType Master Data: Setting for different vacation types
MARISimulation Simulation Plannings Simulator: Master Table
MARISimulationData SimulationData Plannings Simulator: Data of dimensions
MARISimulationDataHistory SimulationDataHistory Plannings Simulator: Data of old simulations
MARISimulationImport SimulationImport Plannings Simulator: Import from real planning
MARISimulationMasterData SimulationMasterData Plannings Simulator: Master Data by dimension
MARISimulationMasterDataAuthentication SimulationMasterDataAuthentication Plannings Simulator: Master Data by dimension authorization
MARISimulationMasterDataHistory SimulationMasterDataHistory Plannings Simulator: Master Data by dimension (history for old simulations)
MARISimulationMasterSettings SimulationMasterSettings Plannings Simulator: Master Table Settings
MARISimulationRuleHead SimulationRuleHead Plannings Simulator: Export Rule (Master Header)
MARISimulationRuleProperty SimulationRuleProperty Plannings Simulator: Export Rule (Settings)
MARISimulationRules SimulationRules Plannings Simulator: Export Rule (Master)
MARISimulationScenario SimulationScenario Plannings Simulator: Scenarios
MARISimulationScenarioAuthentication SimulationScenarioAuthentication Plannings Simulator: Scenarios authorization
MARISimulationScenarioHistory SimulationScenarioHistory Plannings Simulator: Scenarios history
MARISkillMaster SkillMaster Employee Master: Employee Skills
MARISupportClassType SupportClassType Support Module: Settings by class type (Ticket, Task, Idea, DevTask, HR Task)
MARISupportClassTypeForms SupportClassTypeForms Support Module: Setting for the master forms to show the Ticket tab
MARISupportContracts SupportContracts Support Module: Support Contracts (not used)
MARISupportGroup SupportGroup Support Module: Support Group: Header
MARISupportGroupCompany SupportGroupCompany Support Module: Support Group: E-Mail settings by company
MARISupportGroupEmployee SupportGroupEmployee Support Module: Support Group: Linked employees
MARISupportGroupingMap SupportGroupingMap Support Module: Self organzing the tickets
MARISupportGroupingMapTree SupportGroupingMapTree Support Module: Self organzing the tickets in lines
MARISupportIssue 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
MARISupportIssueApproval SupportIssueApproval Support Module: Store the approval steps for a ticket
MARISupportIssueChangeLog SupportIssueChangeLog Support Module: Issue tracking: Issue change log
MARISupportIssueIndex SupportIssueIndex Support Module: store key words from external keyword tool
MARISupportIssueKeywording SupportIssueKeywording Support Module: Split content in key words to find equal tickets
MARISupportIssueKeywords SupportIssueKeywords Support Module: Global list of keywords for all tickets
MARISupportIssueLine SupportIssueLine Support Module: Issue tracking: Issue line for comments, documents, emails, etc.
MARISupportIssueLink SupportIssueLink Support Module: Link a ticket to other core data (CSO, Equipment)
MARISupportIssueModules SupportIssueModules Support Module: Issue tracking: Issue linked modules
MARISupportIssueRecipients SupportIssueRecipients Support Module: Issue tracking: Linked email recipients
MARISupportIssueVersions SupportIssueVersions Support Module: Issue tracking: Issue linked versions
MARISupportProduct SupportProduct Support Module: Support Product: Master Data
MARISupportProductCustomer SupportProductCustomer Support Module: Support Product: Customer Product Link
MARISupportProductCustomerLicenses SupportProductCustomerLicenses Support Module: Support Product: License files by customer
MARISupportProductCustomerModules SupportProductCustomerModules Support Module: Support Product: Customer Product Link: Modules
MARISupportProductCustomerRecipients SupportProductCustomerRecipients Support Module: Default for the ticket recipient list
MARISupportProductDocuments SupportProductDocuments Support Module: Support Product: Linked invoice documents
MARISupportProductListener SupportProductListener Support Module: Customers/Users to be informed for changes
MARISupportProductModules SupportProductModules Support Module: Support Product: Master Data Modules
MARISupportProductModuleVersions SupportProductModuleVersions Support Module: Support Product: Master Data Versions for Modules
MARISupportProductVersions SupportProductVersions Support Module: Support Product: Master Data Versions
MARISupportSettings SupportSettings Support Module: Settings for the Status, Priority, Mode etc. of hottline issues
MARISupportSettingsClassType SupportSettingsClassType Support Module: Selection of setting by the HotlineClassType (Ticket, Task, Idea, DevTask, HR Task)
MARISupportSLA SupportSLA Support Module: Service Level Agreement Master
MARISupportSLANotification SupportSLANotification Support Module: Service Level Agreement Notifications
MARISupportSLASettings SupportSLASettings Support Module: Service Level Agreement Settings
MARISupportSyncMapping SupportSyncMapping Support Module: Mapping dimensions for synchronization
MARISupportSyncPartner SupportSyncPartner Support Module: Synchronizaion settings
MARISupportTicketRuleSet SupportTicketRuleSet Support Module: Routing Set for blanc email input
MARISupportTicketRuleSetLine SupportTicketRuleSetLine Support Module: Routing Set for blanc email input - Step
MARISupportTicketRuleSetLineStep SupportTicketRuleSetLineStep Support Module: Routing Set for blanc email input - Condition line for each step
MARISupportWorkflow SupportWorkflow Support Module: Workflow definition for the status
MARISupportWorkflowSettings SupportWorkflowSettings Support Module: Workflow definition for the status details
MARISupportWorkflowTransition SupportWorkflowTransition Support Module: Workflow definition for the status transition
MARISysActivityLink SysActivityLink Link OCLG Activities to PM Objects
MARISysAddOns SysAddOns Manage Programm Add Ons in MARI
MARISysArchivePattern SysArchivePattern Definition to tag and place documents into DMS
MARISysArchivePatternTree SysArchivePatternTree Definition to tag and place documents into DMS-Trees
MARISysArchivePatternTreeLine SysArchivePatternTreeLine Definition to tag and place documents into DMS-Trees details
MARISysClassApproval SysClassApproval Approval of core data
MARISysClassApprovalLine SysClassApprovalLine Approval of core data receipients
MARISysClassApprovalRule SysClassApprovalRule Definition of Approval procedures
MARISysClassApprovalRuleRessources SysClassApprovalRuleRessources Definition of Approval procedures lines
MARISysClassCompanyFilter SysClassCompanyFilter Define for a given Master data the visibility to users with company restrictions
MARISysClassFavorites SysClassFavorites Store Search Tree favorite elements by user
MARISysClassFieldView SysClassFieldView System Table: Order of fields in system dimensions
MARISysClassInfoQuery SysClassInfoQuery Query user tables for employee / individual information
MARISysClassLookup SysClassLookup Info Screen Management: Lookup for additional columns
MARISysClassNotification SysClassNotification Event Management: Definition of used events by master data dimension
MARISysConnections SysConnections System: Link to SBO company databases [!! Never edit this table !!]
MARISysCustomerLanguages SysCustomerLanguages System: Language
MARISysCustomerLanguagesCompany SysCustomerLanguagesCompany System: Languages linked to SBO company languages
MARISysCustomerText SysCustomerText System: Text elements
MARISysDefinition SysDefinition Internal Database Version Information
MARISysDocSeries SysDocSeries System: Numberseries for ProjectManagement documents
MARISysDocWorkflow SysDocWorkflow Print Process: Definition Table
MARISysDocWorkflowStep SysDocWorkflowStep Print Process: Steps
MARISysDocWorkflowStepDocType SysDocWorkflowStepDocType Print Process: Settings by document type for each step
MARISysDocWorkflowStepDocTypePrintOrder SysDocWorkflowStepDocTypePrintOrder Print Process: Store Settings by first and following pages
MARISysDragRelate SysDragRelate used in future versions
MARISysFilterDefinition SysFilterDefinition Definition of dynamic filter forms
MARISysFilterDefinitionFilter SysFilterDefinitionFilter Definition of dynamic filter forms - field definition
MARISysFilterDefinitionGroup SysFilterDefinitionGroup Definition of dynamic filter forms - Tabs
MARISysFilterDefinitionValues SysFilterDefinitionValues User Values for filter forms, with different names
MARISysFlexVersions SysFlexVersions Info Screen Management: User-defined columns (header)
MARISysFlexVersionsColumns SysFlexVersionsColumns Info Screen Management: User-defined columns (columns)
MARISysFlexVersionsLookup SysFlexVersionsLookup Info Screen Management: User-defined columns (source data)
MARISysFormFieldOptions SysFormFieldOptions System Table: Manage defaults and visibility of fieds in web forms
MARISysFullTextSearch SysFullTextSearch System Table: Store the selected full text search settings
MARISysImportDef SysImportDef System Table: Text Field Mapping for data import
MARISysImportDefColumns SysImportDefColumns System Table: Text Field Mapping for data import by col
MARISysImportDefColumnsRules SysImportDefColumnsRules System Table: Text Field Mapping for data import Extra rules
MARISysImportDefLog SysImportDefLog System Table: Stores date and file with result
MARISysLanguageStrings 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
MARISysLock SysLock System: logical lock of master data
MARISysLogBook SysLogBook System: Change log by SQL Triggers (Table information)
MARISysLogBookDetail SysLogBookDetail System: Change log by SQL Triggers (Field information)
MARISysLogDebug SysLogDebug Debug Content
MARISysLogVersion SysLogVersion System: Log the upgrade process
MARISysMARICopyLog SysMARICopyLog System: Log of MARI Copy program distribution by client PC
MARISysMasterProperties SysMasterProperties Property Settings for master data (Contract Person, Employees, Service Tasks, Events)
MARISysMasterPropertyLink SysMasterPropertyLink Link between Dimension (ClassID) and a SysMasterProperty. See MPSysMasterProperty.UsageFlag for the used linked dimensions.
MARISysMasterPropertyStack SysMasterPropertyStack Header Line for a set of properties
MARISysMasterPropertyStackLink SysMasterPropertyStackLink Link to the master data for the property stack
MARISysMenu SysMenu System: Menu contents for the different clients (Fat, Web, customer portal..)
MARISysMenuFavorites SysMenuFavorites System: User Menu
MARISysMessages SysMessages System: eMail System (Header)
MARISysMessagesAttachment SysMessagesAttachment System: eMail System (Attachments)
MARISysMessagesAttachmentFilter SysMessagesAttachmentFilter System: eMail System (Filter for the Email In module)
MARISysPlayerFrmAction SysPlayerFrmAction Player for stored scenarios: Head
MARISysPlayerFrmActionFilm SysPlayerFrmActionFilm Player for stored scenarios: Film
MARISysPlayerFrmActionFilmStack SysPlayerFrmActionFilmStack Player for stored scenarios: Master Data Ids
MARISysPlayerFrmActionSequence SysPlayerFrmActionSequence Player for stored scenarios: Sequence
MARISysPlayerFrmActionSequenceLog SysPlayerFrmActionSequenceLog Player for stored scenarios: Player Log
MARISysProRata SysProRata Rule to spred revenue for mainenance positions to 12 month
MARISysProRataSettings SysProRataSettings Rule to spred revenue for mainenance positions to 12 month (Details)
MARISysReportGroups SysReportGroups Reporting: Report Groups: List of different reports run at once
MARISysReportGroupsDetail SysReportGroupsDetail Reporting: Report Groups (sub)
MARISysReportLayoutSettings SysReportLayoutSettings Reporting: Saves the print from grid to multiple pages settings by user
MARISysReports SysReports Reporting: User Report definition
MARISysReportSize SysReportSize Define Sizes for Label Printing
MARISysReportSizeMapping SysReportSizeMapping Mapping of real Printer to Sizes
MARISysReportsLanguage SysReportsLanguage Reporting: User Report definition translation of crystal reports objects
MARISysReportsSQL SysReportsSQL Reporting: User Report definition: SQL for main and sub reports
MARISysRestService SysRestService Settings for REST Service Interfaces
MARISysSearchCondition SysSearchCondition Saved Search: Conditions
MARISysSearchGroup SysSearchGroup Saved Search: Groups
MARISysSearchHead SysSearchHead Saved Search: Header
MARISysSearchResult SysSearchResult Saved Search: Results
MARISysSearchStep SysSearchStep Saved Search: Steps
MARISysStamp SysStamp System: CoreDataTimeStamp: Change ID for each change of a core element
MARISysUserFields SysUserFields System: User-defined fields: Additional fields by master data
MARISysUserFieldsGroup SysUserFieldsGroup System: Header for user defined groups
MARISysUserFormFields SysUserFormFields SDK: User-Defined Tables: Form Fields
MARISysUserFormPages SysUserFormPages SDK: User-Defined Tables: Form Pages
MARISysUserGroups SysUserGroups SDK: User-Defined Tables: Groups in UDT
MARISysUserObjects SysUserObjects SDK: User-Defined Tables: Master Table for UDT
MARISysUserProcesses SysUserProcesses System: User Processes Settings Master
MARISysUserProcessesSettings SysUserProcessesSettings System: User Processes Settings Lines
MARISysUserQuery SysUserQuery System: User Defined Queries
MARISysUserQueryGroup SysUserQueryGroup System: User Defined Groups for Queries
MARISysUserStrings SysUserStrings System: User-defined translations of the user interface
MARISysUserTable SysUserTable SDK: User-Defined Tables: Table description
MARISysUserTableClassDelete SysUserTableClassDelete SDK: User-Defined Tables: Delete conditions
MARISysUserTableClassIndex SysUserTableClassIndex SDK: User-Defined Tables: Search Conditions
MARISysUserTableClassIndexCol SysUserTableClassIndexCol SDK: User-Defined Tables: Columns for search conditions
MARISysUserTableClassTree SysUserTableClassTree SDK: User-Defined Tables: Search Tree
MARISysUserTableFields SysUserTableFields SDK: User-Defined Tables: Field definition
MARISysUserTableFieldsLink SysUserTableFieldsLink SDK: User-Defined Tables: Link to existing master data forms
MARISysUserTableOptions SysUserTableOptions SDK: User-Defined Tables: Internal Links
MARITaxServiceLog TaxServiceLog USA Sales Tax Interface Log
MARITaxServiceMapping TaxServiceMapping USA Sales Tax Interface Mapping storage
MARITaxServiceMappingSub TaxServiceMappingSub USA Sales Tax Interface Mapping sub table
MARITempReportAddress TempReportAddress Reportng: 1:n Addresses for ducments
MARITempReportCalendar TempReportCalendar Reporting: Temporary Table: Calendar
MARITempReportDocumentAddOns TempReportDocumentAddOns Reporting: Temporary Table: Document Add On Items
MARITempReportDocumentHeader TempReportDocumentHeader Reporting: Temporary Table: Document Header
MARITempReportDocumentPayment TempReportDocumentPayment Reporting: Temporary Table: Document Payment Conditions
MARITempReportDocumentPos TempReportDocumentPos Reporting: Temporary Table: Document Positions
MARITempReportDocumentPosBinLocations TempReportDocumentPosBinLocations Reporting: Temporary Table: Document Positions Bin Location Information
MARITempReportDocumentPosSerialNumbers TempReportDocumentPosSerialNumbers Reporting: Temporary Table: Document Positions Serial Numbers
MARITempReportDocumentTax TempReportDocumentTax Reporting: Temporary Table: Document TAX
MARITempReportGridLarge TempReportGridLarge Reporting: Temporary Table: Grid large
MARITempReportGridSmall TempReportGridSmall Reporting: Temporary Table: Grid small
MARITempReportInfoScreens TempReportInfoScreens Reporting: Temporary Table: Info Screens
MARITempReportProjectPhase TempReportProjectPhase Reporting: Temporary Table: Project Phase Report
MARITempReportProjectPhaseService TempReportProjectPhaseService Reporting: Temporary Table: Project Phase Service
MARITempReportTimeKeeping TempReportTimeKeeping Reporting: Temporary Table: Time Keeping
MARITempTimeBookingAddOn TempTimeBookingAddOn Reporting: Temporary Table: Time Booking Add On
MARITenantActions TenantActions Action table to store (CreateUser, ChangeUser) Actions in the master database. To be consumed via web service or MARIService
MARITenantBatchLog TenantBatchLog Bucket to store events from batches locally or remote
MARITenantDatabases TenantDatabases Management of MARIProject/SBO client datatabases
MARITenantEnvironments TenantEnvironments Base client enviornment (master for over all clients)
MARITenantMonitorAppInstallations TenantMonitorAppInstallations Bucket to store installation data at client location: installed apps
MARITenantMonitorAppUserGroups TenantMonitorAppUserGroups Bucket to store installation data at client location: installed user groups
MARITenantMonitorAppUsers TenantMonitorAppUsers Bucket to store installation data at client location: assigned users
MARITenantMonitorDatabases TenantMonitorDatabases Bucket to store installation data at client location: used databases
MARITenantMonitorEnvironments TenantMonitorEnvironments Bucket to store installation data at client location: Information from SLD
MARITenantMonitorMachines TenantMonitorMachines Bucket to store installation data at client location: database servers, RDP Servers, Clients
MARITenantMonitorSysLogDebug TenantMonitorSysLogDebug Bucket to store installation data at client location: last 10 Sys Logs
MARITenantServices TenantServices Manage monitoring web sites or RestServices at the clients
MARITenantTenants TenantTenants Management of MARIProject/SBO client installations
MARITenantUserGroups TenantUserGroups Management of MARIProject/SBO client installations user groups
MARITenantUsers TenantUsers Management of MARIProject/SBO client installation users
MARITenantUsersDBLink TenantUsersDBLink Management of MARIProject/SBO client installation licenses, rights
MARITextElements TextElements System: User-defined Text Elements
MARITextElementsLanguages TextElementsLanguages System: User-defined Text Elements (Languages)
MARITimeBookingActivityTracker TimeBookingActivityTracker Table to store activities, before they are linked to time bookings
MARITimeBookingAddOnCategory TimeBookingAddOnCategory Time Keeping: Add On Items Sales Rules Valid From
MARITimeBookingAddOnCategoryHead TimeBookingAddOnCategoryHead Time Keeping: Add On Items Sales Rules
MARITimeBookingAddOnCategoryLine TimeBookingAddOnCategoryLine Time Keeping: Add On Items Sales Rule Details
MARITrainingExams TrainingExams Training Module: List of exams
MARITrainingGrade TrainingGrade Training Module: List of grades
MARITrainingParticipant TrainingParticipant Training Module: List Of Participants
MARITrainingParticipantCompanyLink TrainingParticipantCompanyLink Training Module: Link of a participant to addiational companies
MARITrainingParticipantExams TrainingParticipantExams Training Module: Passed exams of participants
MARITrainingParticipantGrades TrainingParticipantGrades Training Module: Grades of participants
MARITrainingRegistration TrainingRegistration Training Module: Registratrion to training cources
MARITrainingRegistrationContractLink TrainingRegistrationContractLink Training Module: Selection of billable contract positions (Contract from registration)
MARITrainingRegistrationOptionLink TrainingRegistrationOptionLink Training Module: Selectable options (formaly phases)
MARITrainingRegistrationPhaseLink TrainingRegistrationPhaseLink Training Module: Selected options=Phases from the project linked to the training cource
MARITrainingRegistrationTeam TrainingRegistrationTeam Training Module: Team for the training
MARITrainingRegistrationTeamLink TrainingRegistrationTeamLink Training Module: Link to the team
MARITransactionID TransactionID System: Transaction Table to handle the unique IDs of all data (master data and tasks)
MARITravelAccountingApproval TravelAccountingApproval Travel Expenses Module: Approval for travel requests
MARITravelAccountingHeader TravelAccountingHeader Travel Expenses Module: Accounting Header
MARITravelCountries TravelCountries Travel Expenses Module: Countries
MARITravelCountriesAllowances TravelCountriesAllowances Travel Expenses Module: Country allowances
MARITravelExpenseTypes TravelExpenseTypes Travel Expenses Module: Travel Expenses Types Master Data
MARITravelExpenseTypesAccounts TravelExpenseTypesAccounts Travel Expenses Module: Travel Expenses Types Company G/L Account Link
MARITravelExpenseTypesAccountsMatrix TravelExpenseTypesAccountsMatrix Travel Expenses Module: Travel Expenses Types Company G/L Account Link (Matrix)
MARITravelMilageAllowanceHeader TravelMilageAllowanceHeader Travel Expenses Module: Mileage allowances header
MARITravelMilageAllowances TravelMilageAllowances Travel Expenses Module: Mileage allowances
MARITravelMilageAllowanceSub TravelMilageAllowanceSub Travel Expenses Module: Mileage allowances sub
MARITravelPostingDocument TravelPostingDocument Travel Expenses Module: Posting document
MARITravelPostingDocumentLine TravelPostingDocumentLine Travel Expenses Module: Posting document lines
MARITravelPostingDocumentLineTax TravelPostingDocumentLineTax Travel Expenses Module: Posting document lines sub tax
MARITravelTemplate TravelTemplate Travel Expenses Module: Template Header
MARITravelTemplateSetting TravelTemplateSetting Travel Expenses Module: Template Settings
MARITravelTemplateVersion TravelTemplateVersion Travel Expenses Module: Template by "period from"
MARITravelTrip TravelTrip Travel Expenses Module: Business Trip Master
MARITravelTripLine TravelTripLine Travel Expenses Module: Trip receipt line
MARITravelTripLineDocument TravelTripLineDocument Travel Expenses Module: Trip receipt line (document link for scanned documents)
MARITravelTripLineProject TravelTripLineProject Travel Expenses Module: Trip receipt project line for invoice
MARITravelTripProjectLink TravelTripProjectLink Travel Expenses Module: Business Trip Project Link
MARITravelTripTime TravelTripTime Travel Expenses Module: Trip day lines
MARITravelTripTimeAllowances TravelTripTimeAllowances Travel Expenses Module: Employee trip days allowance link
MARITravelTripTimeAllowancesLines TravelTripTimeAllowancesLines Travel Expenses Module: Employee trip days
MARIUnits Units Unit of measurement basic setting
MARIUser User ProjectManagement User + Customer Portal User
MARIUserBarCodeScanLog UserBarCodeScanLog User Barcode Scan Log for all single scans
MARIUserBusinessUnits UserBusinessUnits ProjectManagement User Athorization to Business Units
MARIUserCompanyLogin UserCompanyLogin ProjectManagement User Link to SBO Users
MARIUserCompanyVisibility UserCompanyVisibility User Company Visibility
MARIUserGroups UserGroups ProjectManagement: User Groups
MARIUserLog UserLog User Log for each login and logoff
MARIWorkInProgress WorkInProgress Work In Progress: Header (one line per project and month)
MARIWorkInProgressDefinition WorkInProgressDefinition Work In Progress Definition
MARIWorkInProgressLines WorkInProgressLines Work In Progress: calculated lines
MARIWorkInProgressValues WorkInProgressValues Work In Progress: Store Column Values
MARIWorkItem 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
MARIWorkItemDocumentLink WorkItemDocumentLink Service Task Link created documents
MARIWorkItemOptions WorkItemOptions Training Course: selectable options by the participants
MARIWorkItemPhaseCPosFilter WorkItemPhaseCPosFilter Training Course: Filter selectable phases or contract positions
MARIWorkItemPosition WorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource
MARIWorkItemPositionSerial WorkItemPositionSerial Serialnumbers, Batchnumbers for work item positions
MARIWorkItemResources WorkItemResources Employees or Equipment necessary for the tasks
MARIWorkItemResults WorkItemResults Results of quality process questionnaire
MARIWorkItemScheduleDates WorkItemScheduleDates Recurring service tasks
MARIWorkItemSettings WorkItemSettings Additional Properties for a service order
MARIWorkPackage 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
MARIXcelsiusDimensionParameter XcelsiusDimensionParameter Xcelsius: Special Parameter for each film
MARIXcelsiusFiles XcelsiusFiles Xcelsius: Source Files for one Film
MARIXcelsiusFilms XcelsiusFilms Xcelsius: one flash film

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany