MARIProject Database Structure

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

Field Table(Germ.field)/Type Description Related
UserCode Benutzer

NVARCHAR (4) Primary

MARIUser.UserCode (WHERE BenutzerTyp=1)
UserType BenutzerTyp

INT Primary

1=User, 2=CustomerSupportLogin clsImportEmployee_eUserType
Name Name

NVARCHAR (50) Unique

Password Kennwort

NTEXT

Groups Gruppen

BIGINT

binary flags MARIUserGroups.Groups
LoginActive BenutzerAktiv

SMALLINT (0=false,-1=true)

Modules Modules

INT

Email EMailName

NVARCHAR (100)

UserLevelMode UserLevel

SMALLINT

AccountingMode FibuLevel

INT

ERPUserName KHKUserName

NVARCHAR (128) Index

ERPUserPassword KHKUserPWD

NTEXT

ERPUserByCompany ERPByCompany

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

Company CustomerCompany

SMALLINT

MARISysConnections.Company (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

CreateUser CreationID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
CreateDate CreationDate

Datetime

ChangeUser ChangeID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

Inactive InAktiv

SMALLINT (0=false,-1=true)

Hide dataset
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MARIItemGroupProperties Item Groups: Additional fields for maintenance and purchase order
MARIItemProperties Item Master: Additional fields for maintenance and purchase order
MARIInfoSimulationBusinessUnits Plannings Simulator: Dimension Business Unit
MARIInfoSimulationBusinessUnitsEmployees Plannings Simulator: Dimension Business Unit / Employees
MARIInfoSimulationGroups Plannings Simulator: Dimension Groups
MARIInfoSimulationHead Plannings Simulator: Header
MARIInfoSimulationProjects Plannings Simulator: Dimension Projects
MARIInfoSimulationProjectEmployees Plannings Simulator: Dimension Projects/Employees
MARIInfoSimulationResources Plannings Simulator: Dimension Resources
MARIInfoSimulationResourcesEmpoyees Plannings Simulator: Dimension Resources/Employees
MARIUser ProjectManagement User + Customer Portal User
MARIUserCompanyLogin ProjectManagement User Link to SBO Users
MARIUserBusinessUnits ProjectManagement User Athorization to Business Units
MARIUserGroups ProjectManagement: User Groups
MARIUserLog User Log for each login and logoff
MARIUserCompanyVisibility User Company Visibility
MARIPictures Images linked to support issues, employees...
MARIInfoScreenManagementHead Info Screen Management: Export Header
MARIInfoScreenManagementUserColumns Info Screen Management: User-defined columns
MARIInfoScreenManagementUserStore Info Screen Management: Store filter settings (Header)
MARIInfoScreenManagementUserTree Info Screen Management: Store tree selection
MARIInfoScreenManagementUserView Info Screen Management: Store selected analysis
MARIInfoScreenManagementBreakEven Info Screen Management: Breakeven Analysis (Header)
MARIDocApproval Approval Process Definition
MARIDocuments Documents linked in the Folder tabs of the master data
MARIPurchaseImportDocument Purchase Order: Import external documents (Header)
MARIPurchaseProcess Purchase Process: Header
MARIPurchaseProcessDocument Purchase Process: Purchase Document (Header)
MARIPurchaseProcessDocumentPrint Purchase Process: Print history
MARIPurchaseProcessDocumentApproval Purchase Process: Document Approval Employee Link
MARIPurchaseProcessPositions Purchase Process: PO Process Position (equivilant to contract position)
MARIPurchaseProcessPositionTextelements Purchase Process: Text definition (master data) for positions
MARIJournalEntryImportStack Journal Entry Import Flaggs
MARIJournalEntryExport Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress)
MARIJournalEntryExportCancel Journal Entries Canceled Records (Travel Expenses, Internal Service Charges, Work in Progress)
MARIGroups Groups used for a long list of master data. See the GruppenArt enumeration
MARISupportIssue 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
MARISupportIssueLine Support Module: Issue tracking: Issue line for comments, documents, emails, etc.
MARISupportGroup Support Module: Support Group: Header
MARISupportGroupEmployee Support Module: Support Group: Linked employees
MARISupportProduct Support Module: Support Product: Master Data
MARISupportProductCustomer Support Module: Support Product: Customer Product Link
MARISupportProductCustomerLicenses Support Module: Support Product: License files by customer
MARISupportProductModules Support Module: Support Product: Master Data Modules
MARISupportProductVersions Support Module: Support Product: Master Data Versions
MARISupportContracts Support Module: Support Contracts (not used)
MARICalendar Calendar Management: Calendar Header
MARICalendarTemplates Calendar Management: Public Holiday Rules
MARIKnowledgeBaseEntry Support Module: Knowledge Base Header
MARIServices

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

MARIServicePools Service Master: Master Data Pool link
MARIPayrollTypes Payroll Interface: Payroll Types Master Data by company
MARIPayrollStack Payroll Interface: Export Header
MARIMSProjectDatabases MS Project Interface: Database Link (MSP Server)
MARIMSProjectImports MS Project Interface: Import log
MARINumberPool Work Items: Number Pool
MARIPeriods 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
MARIPeriodsExchangeRates Calendar Management: Monthly currency exchange rates
MARIEmployeesPool Employee Master: Employee Pool link
MARIEmployeeSkills Employee Master: Employee Skill link
MARIEmployeeMaster Employee Master: Employee Master
MARIEmployeeVacationRequest Vacation Management: Vacation Request and Approval
MARIAttendanceAction Attendance: Actions "in the door" (Lines per day)
MARIAttendanceRule Attendance: Working Time rules (Header valid from)
MARIAttendanceRuleHead Attendance: Working Time rules (Header)
MARIAttendanceRuleDays Attandence: Actions "in the door" (Day header)
MARIPriceIndex Maintenance: Price Index Header
MARIPriceIndexHeader Maintenance: Price Index Protocol of wizard (Header)
MARIPriceIndexPeriod Maintenance: Price Index per month
MARIProjectItemBooking Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf
MARIProjectBookingsFavorits Time Keeping: Favorits
MARIProjectBookingErrors Time Keeping: Error log in the time keeping
MARIProjectTimeKeepingLines Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type
MARIProjectTimeKeepingHeader Time Keeping: ProjectTimeKeepingHeader: One line per employee and period. This header table indicates the booking month of time sheet entries. (no project information is stored).
MARIProjectGroups Project Master: Project Groups
MARIProjectPhases Project Phases Master: Master Data (linked to project and planning version)
MARIProjectPhaseBudget Project Phases Master: Budget
MARIProjectPhaseEmployeeFeedback Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion
MARIProjectPhaseEmployeeLink Project Phases Master: Employee link
MARIProjectPhasePredecessor Project Phases Phase Predecessors
MARIProjectPlanningResource Planning: Filter list for plannable resources (ex. G/L Accounts)
MARIProjectPlanningVersions Project Master: Planning versions linked to a project
MARIProjectPlanningLines Planning: Master Planning lines
MARIProjectTravelExpenseRules Travel Expenses Module: Properties by Project
MARIProjectMaster Project Master: Master Data
MARIProjectManager Project Master: Linked project manager
MARIProjectStatus Project Master: status history
MARIQualityProcess QualityProcess Definition
MARIQualityStatus QualityStatus: Type of statuses
MARITravelTrip Travel Expenses Module: Business Trip Master
MARITravelPostingDocument Travel Expenses Module: Posting document
MARITravelPostingDocumentLine Travel Expenses Module: Posting document lines
MARITravelAccountingHeader Travel Expenses Module: Accounting Header
MARITravelExpenseTypes Travel Expenses Module: Travel Expenses Types Master Data
MARITravelMilageAllowanceHeader Travel Expenses Module: Mileage allowances header
MARITravelCountries Travel Expenses Module: Countries
MARITravelTemplate Travel Expenses Module: Template Header
MARITravelTemplateSetting Travel Expenses Module: Template Settings
MARITravelTemplateVersion Travel Expenses Module: Template by "period from"
MARITravelTripLine Travel Expenses Module: Trip receipt line
MARITravelTripLineDocument Travel Expenses Module: Trip receipt line (document link for scanned documents)
MARITravelTripLineProject Travel Expenses Module: Trip receipt project line for invoice
MARITravelMilageAllowances Travel Expenses Module: Mileage allowances
MARIResourcePool Resource Pool: Master Data
MARIFolderDocuments Master Data Folder Documents
MARIFolderDocumentsGroups Document Tab Registers
MARIServiceJobs MARIService: Service Job header
MARIServiceJobSchedule MARIService: Service Job timing
MARISettingsBusinessUnit Master Data: Settings by business unit
MARISettingsBusinessUnitMatrix Master Data: Settings by business unit in matrix
MARIBusinessUnitMaster Business Units: Master Data
MARISettingsCompany Master Data: Settings by company
MARISettingsCompanyMatrix Master Data: Settings by company in matrix
MARISetupUserFormularFields Master Data: Settings by user and form
MARISetupUserFormularPos Master Data: Settings by user, form and form element
MARISetupUserSettings Master Data: Settings by user
MARISimulation Plannings Simulator: Master Table
MARISimulationImport Plannings Simulator: Import from real planning
MARISimulationRuleHead Plannings Simulator: Export Rule (Master Header)
MARISimulationRules Plannings Simulator: Export Rule (Master)
MARISimulationMasterData Plannings Simulator: Master Data by dimension
MARISimulationMasterDataAuthentication Plannings Simulator: Master Data by dimension authorization
MARISimulationMasterDataHistory Plannings Simulator: Master Data by dimension (history for old simulations)
MARISimulationScenario Plannings Simulator: Scenarios
MARISimulationScenarioAuthentication Plannings Simulator: Scenarios authorization
MARISimulationScenarioHistory Plannings Simulator: Scenarios history
MARISysClassNotification Event Management: Definition of used events by master data dimension
MARIClassNotificationReceipients Event Management: Additional receipients for core data
MARIClassNotificationText Event Management: Textdefinition master
MARIClassNotificationTextLang Event Management: Textdefinitions by language
MARISysDocWorkflow Print Process: Definition Table
MARISysFlexVersions Info Screen Management: User-defined columns (header)
MARISysImportDef System Table: Text Field Mapping for data import
MARISysCustomerLanguages System: Language
MARISysCustomerLanguagesCompany System: Languages linked to SBO company languages
MARISysCustomerText System: Text elements
MARISysLock System: logical lock of master data
MARISysLogDebug Debug Content
MARISysMessages System: eMail System (Header)
MARISysMessagesAttachmentFilter System: eMail System (Filter for the Email In module)
MARISysReportGroups Reporting: Report Groups: List of different reports run at once
MARISysReports Reporting: User Report definition
MARISysLanguageStrings 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
MARISysSearchGroup Saved Search: Groups
MARISysSearchHead Saved Search: Header
MARISysUserQuery System: User Defined Queries
MARISysUserTable SDK: User-Defined Tables: Table description
MARITextElements System: User-defined Text Elements
MARITextElementsLanguages System: User-defined Text Elements (Languages)
MARIContract Contract Management: Contract Master Data + Service Master Data
MARIContractDocument Contract Management: Sales Documents
MARIContractDocumentPrintHistory Contract Management: Print History
MARIContractDocumentReturnRevenueLink Contract Management: [not used]
MARIContractDocumentApproval Contract Management: Document Approval
MARIContractPositions Contract Management: Contract positions (also service master positions)
MARIContractPositionTextElements Contract Management: Contract position texts (standard definition)
MARIReminder System: Reminder
MARIMPExchangeSync MS Exchange Server Link Log
MARISysPlayerFrmActionFilm Player for stored scenarios: Film
MARISysPlayerFrmActionSequence Player for stored scenarios: Sequence
MARIPurchaseProcessDocumentISCHead Purchase Process: Document Internal Service Change Head
MARIPurchaseProcessDocumentISCPos Purchase Process: Document Internal Service Change Positions
MARIContractDocumentISCHead Contract Management: Document Internal Service Charges Head
MARIContractDocumentISCPos Contract Management: Document Internal Service Charges Positions
MARIEquipmentMaster Equipment: Master Data for each individual Equipment
MARIEquipmentCategory EquipmentCategory: Cagetory Master
MARIEquipmentCategorySubject EquipmentCategory: Standard cost types for categories
MARIEquipmentCategorySubjectRates EquipmentCategory: Standard cost and sales prices for the cost types of categories
MARIEquipmentDetails Equipment: Master Data "date from" based
MARIEquipmentReminder Equipment: recurrent dates for each equipment
MARIEquipmentSubjectBooking Time/Costbooking on Equipment data
MARIEquipmentSubjectRates Equipment: Specific cost rates
MARIEquipmentSubjectRatesBU Equipment: Specific cost and sales rates for internal service charges
MARIProjectMasterWorkInProgess Project Master: Save degree of compleation for each month
MARISysUserQueryGroup System: User Defined Groups for Queries
MARIContractRoundingDefinition Defines Time Rounding Methods
MARIXcelsiusFiles Xcelsius: Source Files for one Film
MARIXcelsiusFilms Xcelsius: one flash film
MARIAccountingProfitCenterPlanningLine Store the financial planning on profit center level per month
MARIAccountingProfitCenterPlanningYear Store the financial planning on profit center level per year
MARILocation Location: Place (India Localization)
MARILocationDistance Distance between locations
MARIAttendanceActionArchive Attendance: Actions "in the door" (Lines per day) History
MARISetupUserBrowserTree Master Data: Store Tree Selection
MARITrainingExams Training Module: List of exams
MARITrainingGrade Training Module: List of grades
MARITrainingParticipant Training Module: List Of Participants
MARITrainingParticipantExams Training Module: Passed exams of participants
MARITrainingParticipantGrades Training Module: Grades of participants
MARITrainingRegistration Training Module: Registratrion to training cources
MARIProjectPhaseStatusHistory Stores the phase stauts of a project
MARISysClassApproval Approval of core data
MARISysClassApprovalLine Approval of core data receipients
MARISysClassApprovalRule Definition of Approval procedures
MARISysUserFieldsGroup System: Header for user defined groups
MARIContractCalculation Cotnract Sales Prices Calculation Method Head
MARIInfoScreenManagementBreakEvenColumnHead Info Screen Management: Column Definition Head
MARISupportSyncPartner Support Module: Synchronizaion settings
MARISysDocSeries System: Numberseries for ProjectManagement documents
MARIWorkInProgressDefinition Work In Progress Definition
MARISupportSLA Support Module: Service Level Agreement Master
MARITaxServiceLog USA Sales Tax Interface Log
MARIPicturesVersions Revisions of the pirctures
MARIDocumentsVersions Revision History of a document
MARISysPlayerFrmActionSequenceLog Player for stored scenarios: Player Log
MARISupportProductListener Support Module: Customers/Users to be informed for changes
MARIEquipmentLocation Equipment: Current Location of this equipment
MARISupportProductModuleVersions Support Module: Support Product: Master Data Versions for Modules
MARISysFormFieldOptions System Table: Manage defaults and visibility of fieds in web forms
MARIContractDocumentErrors Contract Management: Document Error Info
MARIPurchaseProcessDocumentError Purchase Process: Saved Errors
MARIChefInfoCashFlowRun Info Screen Management: Daily cash flow run
MARIChefInfoCashFlowRunProject Info Screen Management: Status of a project
MARIDocumentDraftHead Header for the draft document
MARIDocumentDraftHeadApproval Approval or workflow list for the draft document
MARIDocumentDraftHeadLink Linked contracts and purchase processes
MARIDocumentDraftPositionLink Linked positions in the sales contract and or purchase process
MARIKnowledgeBaseEntryLanguage Support Module: Knowledge Base Languages
MARIDocumentInvoiceFlow InvoicePaymentReportStore
MARISysClassFavorites Store Search Tree favorite elements by user
MARIWorkItem 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
MARIWorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource
MARISysReportLayoutSettings Reporting: Saves the print from grid to multiple pages settings by user
MARICustomerServiceObject Advanced table to sbo standard customer equipment card
MARICustomerServiceObjectLocation Current location of a CSO at the client/Project
MARICustomerLocationTree Name of the location tree
MARICustomerLocationTreeElement Tree elements to manage levels, rooms of the customer
MARICustomerLocationTreeLink Link of a customer and a user to a tree or an element of the tree
MARIWorkItemScheduleDates Recurring service tasks
MARIQualityProcessQuestions QualityProcess Definition Questionnaire
MARIWorkItemResults Results of quality process questionnaire
MARICommissionAccrual Commission: Stores the Accrual on Sales Invoicing Time (Project related)
MARICommissionAccrualSBO Commission: Stores the Accrual on Sales Invoicing Time (None Project related)
MARICommissionDocuments Commission: Sales Rep A/P Invoice Link
MARICommissionTypes Commission: Basic Settings for different Types
MARICommissionWizardLog Commission: Log of the usage
MARIContractCommission Contract Management: Link Sales Representetive to Contract
MARICreditCardMapping Stores Credit Card Information to Business Partner and Employees for CreditCard Import
MARISupportGroupingMap Support Module: Self organzing the tickets
MARISysLogVersion System: Log the upgrade process
MARITimeBookingAddOnCategory Time Keeping: Add On Items Sales Rules Valid From
MARITimeBookingAddOnCategoryLine Time Keeping: Add On Items Sales Rule Details
MARISysImportDefLog System Table: Stores date and file with result
MARIUserBarCodeScanLog User Barcode Scan Log for all single scans
MARITrainingRegistrationTeam Training Module: Team for the training
MARIEquipmentCategoryBPCatalog EquipmentCategory: Business Partner Catalog Number
MARIEquipmentDetailsLink Equipment Assembly: List of inner components
MARIOnlineCatalogTree OnlineCatalogTree: Build grouping for online shop
MARIOnlineCatalogTreeElement OnlineCatalogTree: Lines in the grouping
MARIOnlineCatalogTreeElementContent OnlineCatalogTree: rules to biuld one line
MARIQualityProcessLink QualityProcess Combine Checklists to a master list
MARISysProRata Rule to spred revenue for mainenance positions to 12 month
MARIPayrollTypeGroup Payroll Interface: Payroll Types Master Data global
MARIEmployeeVacationRequestApproval Vacation Management: Link to steps of approval process
MARITravelAccountingApproval Travel Expenses Module: Approval for travel requests
MARITimeBookingAddOnCategoryHead Time Keeping: Add On Items Sales Rules
MARIJournalEntryISCRule Definitions for Internal Service Charge Wizard
MARITimeBookingActivityTracker Table to store activities, before they are linked to time bookings
MARISetupVacationType Master Data: Setting for different vacation types
MARISupportWorkflow Support Module: Workflow definition for the status
MARIProjectTimeKeepingReport Time Keeping: Link Week Report of employee or for customer
MARIProjectPlanningLinesLog Planning: Master Planning lines History
MARICommissionAccrualPeriods Commission: Monthly values for employee commission
MARIEmployeesCommissionSettings Employee Master: Standard Settings for Commission by Employee
MARIAttendanceShiftRule Shift: Rule Definition
MARIAttendanceShiftPlan Shift: Standard Plan Rhythm
MARIFolderDocumentTree Master Data Folder Search Tree
MARISysFilterDefinition Definition of dynamic filter forms
MARISysFilterDefinitionFilter Definition of dynamic filter forms - field definition
MARISysFilterDefinitionValues User Values for filter forms, with different names
MARINewsletterFilterSet Predefined filter on the E-Mail sources
MARINewsletterMaster Newsletter Design Template
MARIChefInfoChart Info Screen Management: Status Settings for chart design
MARIChefInfoDashboard Project Dash Board Settings
MARIChefInfoDashboardTiles Project Dash Board Settings Tiles
MARIProjectPhaseDegreeOfCompletion Project Phases Master: Degree OF Completion History
MARIProjectPlanningLog Planning: Log Phase dependency changes
MARISysMasterProperties Property Settings for master data (Contract Person, Employees, Service Tasks, Events)
MARISysMasterPropertyLink Link between Dimension (ClassID) and a SysMasterProperty. See MPSysMasterProperty.UsageFlag for the used linked dimensions.
MARINewsletterLog Log the sending action of a new newsletter
MARINewsletterCampaign Source data for a plain newsletter (one time user)
MARIFolderIndexFields Definition of document tags
MARISysArchivePattern Definition to tag and place documents into DMS
MARISysArchivePatternTree Definition to tag and place documents into DMS-Trees
MARISysArchivePatternTreeLine Definition to tag and place documents into DMS-Trees details
MARISysClassInfoQuery Query user tables for employee / individual information
MARIWorkItemOptions Training Course: selectable options by the participants
MARIDocApprovalLink Special Approval Rules per contract
MARIFolderIndexForms Defining additional index forms
MARISupportIssueKeywords Support Module: Global list of keywords for all tickets
MARISupportTicketRuleSet Support Module: Routing Set for blanc email input
MARISupportTicketRuleSetLine Support Module: Routing Set for blanc email input - Step
MARIQualityProcessResults QualityProcess Result for each question of the questionaire
MARISysClassCompanyFilter Define for a given Master data the visibility to users with company restrictions
MARISupportIssueApproval Support Module: Store the approval steps for a ticket
MARIDocValidation Validation rule for A/P invoices based on the linked purchase order
MARITenantActions Action table to store (CreateUser, ChangeUser) Actions in the master database. To be consumed via web service or MARIService
MARITenantBatchLog Bucket to store events from batches locally or remote
MARITenantDatabases Management of MARIProject/SBO client datatabases
MARITenantEnvironments Base client enviornment (master for over all clients)
MARITenantMonitorAppInstallations Bucket to store installation data at client location: installed apps
MARITenantMonitorAppUsers Bucket to store installation data at client location: assigned users
MARITenantMonitorDatabases Bucket to store installation data at client location: used databases
MARITenantMonitorMachines Bucket to store installation data at client location: database servers, RDP Servers, Clients
MARITenantTenants Management of MARIProject/SBO client installations
MARITenantUsers Management of MARIProject/SBO client installation users
MARITenantUsersDBLink Management of MARIProject/SBO client installation licenses, rights
MARITenantMonitorAppUserGroups Bucket to store installation data at client location: installed user groups
MARITenantMonitorEnvironments Bucket to store installation data at client location: Information from SLD
MARITenantUserGroups Management of MARIProject/SBO client installations user groups
MARINewsletterConnector Store special email server connections
MARIWorkPackage

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

MARIUnits Unit of measurement basic setting
MARIProjectWorkPackageEntry Work Packages progress reporting by day
MARIProjectWorkPackageEntryValues Work Packages progress reporting by structure element
MARIProjectMeasurementStructure Measurement strucutre definition: Head
MARIProjectMeasurementStructureElement Measurement strucutre definition: Structure Lines
MARIProjectMeasurementStructureValues Measurement strucutre definition: Measurement values
MARIContractCommissionPos Contract Management: Percentage for each position for the commission receipient
MARIContractPositionMeasurementValues Contract Position Workpackage definition: Values
MARIContractPositionMeasurementLine Contract Position Workpackage definition: Structure Lines
MARIBook Project Dokumentation: Book Header
MARIBookArchive Project Dokumentation: Archived Book Content
MARIBookPrint Project Dokumentation: Print Defnition Head
MARIBookPrintAttachments Project Dokumentation: Print Defnition AttachementSelection
MARIBookPrintTableOfContent Project Dokumentation: Print Action Table of Content
MARIBookPrintFolder Project Dokumentation: Print Defnition Linked Folder Documents
MARIBookPropertiesUser Project Dokumentation: Book User Properties
MARIBookLayout Project Dokumentation: Layout Definition of a content element
MARIBookLink Project Dokumentation: externale links to pages
MARIBookLinkArchive Project Dokumentation: externale link archive
MARIBookPage Project Dokumentation: Book Page (Left hierarchy)
MARIBookPageArchive Project Dokumentation: Book Page Archive (Left hierarchy)
MARIBookPageElements Project Dokumentation: Book Page Content Element
MARIBookPageContent Project Dokumentation: Book Page Content Data
MARIBookPageApproval Project Dokumentation: Book Page Approval Flow
MARIBookPageElementArchive Project Dokumentation: Book Page Content Element Archive
MARIBookPageContentArchive Project Dokumentation: Book Page Content Data Archive
MARICommissionTypesRules Commission: Percentage Definition
MARIPurchaseProcessDocumentAttachments Purchase Process: Link to Attachments
MARIPurchaseProcessDocumentCommision Purchase Process: Purchase Document Bonus definition
MARIPurchaseProcessDocumentCommisionPos Purchase Process: Purchase Document Bonus position definition
MARIMaterDataProperties Master Data Extra Properties. Universal table
MARIContractDocumentAttachments Contract Management: Attachment Selection
MARIJournalEntryExportDocument Journal Entries Export Document Head
MARIBookPrintSequence Project Dokumentation: Print Action Head
MARIBookPrintSequenceElements Project Dokumentation: Print Action PageElementPrintLines
MARIBookPrintPages Project Dokumentation: Print Defnition Book pages
MARIDocumentRecipient Definition of eMail Recipients for documents out of a contract.
MARICommissionDocumentPositions Commission: Sales Rep A/P Invoice Position Link
MARISetupClientSettings Kiosk Mobile Clients
MARIFolderIndexOCR Additional Information via Document Recognition Services
MARISysRestService Settings for REST Service Interfaces
MARISettingsCompanyEInvoice Master Data: Electronic Invoice settings by company
MARIAddressProperties Additional Data for OCRD
MARIContainer Definition of a container carrying other goods
MARIContainerCategory Container Categtrory to manage special settings
MARIContainerLine Container Lines to see the goods in the container
MARISetupQuantityFieldBase Field definition for quantity formular
MARISetupQuantityFormular Quantity Formular Head
MARISysMasterPropertyStack Header Line for a set of properties
MARIContractCustomerDocuments Drawings to be created for the customer
MARIResourcePoolBPTeam External resource team (Supplier, customer)
MARISysReportSize Define Sizes for Label Printing
MARISysReportSizeMapping Mapping of real Printer to Sizes


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany