Click or drag to resize

MARIInterface Namespace

The MARIInterface SDK allows to create transactions in MARIProject and SAP Business One (via DI-API/ServiceLayer). The main purpose of this SDK is to create new master data in MARIProject.

MARIInterface can be used by all programming languages working with the .NET. It can be used also via COM Interface. Since version 7.0 the solution is based on .NET 4..8

Please start reading the user manual describing the SDK.

This chm includes also examples. See MPInterface as a starting point.

Classes
  ClassDescription
Public classclsAddress
Public classclsBatchImport
This class will help to import many different dimensions in one batch. The challenge are the different depending master data.

A contract position can only be imported after the contract has been imported. The internal if the contract will be created dynamicly

This class can load several dimensions and then start to regroup them

Public classclsBatchImportDimension
Data holder for a collection of clsImportBase object of one MARIInterfaceType="clsImportSysCustomerLanguages" for example.
Public classclsBatchImportFieldDefinition
Desription of a property in the clsImport class and the linked table.field information from the database
Public classclsCommingGoing Obsolete.
[obsolete] class to read attendance information for one emplyee and day. Please use clsEmployeeAttendanceDayInfo instead.
Public classclsEmployeeAttendanceDayInfo
Class to read the day information for one employee from the attendance module. Shows content of the table:

View: MARIAttendanceRuleDays: :Table: MPPersonenZeitenTage

Use AttendanceDayInfo(String, DateTime) to load the information for one emplyee and working day.

Public classclsError
Small object to hold error number and text.
Public classclsErrors
Error collection. Object to store clsError objects in a collection
Public classCode exampleclsImportAttendanceDayActivity
Class to import attandance transactions (=Actions) for one employee and day. The emplyoee needs a calender with attendance time rules to use the actions.
Public classclsImportBase
Base class for all import core data classes. Manages the Import and Validation Process.
Public classclsImportBaseERP
Base class for dimendions from SAP Business One tables. All classes does have the companyID property in common
Public classclsImportBook
Import for table MPBuch: Project Documentation Book
Public classclsImportBookPage
Import for table MPBuchSeite: Page to a project description book
Public classclsImportBookPageElementBase
Base class to import content to a book page. Please use one of the overwrits to add an element.

MustInherit

Import for table MPBuchSeitenElement
Public classclsImportBookPageElementLinkLine
Public classclsImportBookPageElementText
Object to store a Text or HTML Text to a page
Public classclsImportBPAddress
Helperclass for business partners in SBOAdd Instances of this object to clsImportBusinessPartner.CollectionCDR1 collection.

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Public classCode exampleclsImportBPAuditPlan
Imports an audit plan. This links an audit template (clsImportBPAuditTemplate) to a business partner (clsImportBusinessPartner).

MS Access Table: MARIProjektImportBPAuditPlans. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportBPAuditPlan(clsImportBPAuditPlan, clsImportBaseeImportMode) to import.

MSAccess Import Table: MARIProjektImportWorkItemBPAuditPlan.

Public classCode exampleclsImportBPAuditTask
An audit task can be used to store the status of a business partner audit.

MS Access Table: MARIProjektImportQualificationTasks. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportBPAuditTask(clsImportBPAuditTask, clsImportBaseeImportMode) to import.

MS Access Table: MARIProjektImportWorkItemBPAuditTask.

Public classclsImportBPAuditTaskResource
Info for table MPWorkItemResources: Employees or Equipment necessary for a BP audit task

MS Access table MARIProjektImportWorkItemBPAuditTaskResource.

Use MPInterface.bImportBPAuditTaskResource(clsImportBPAuditTaskResource, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportBPAuditTemplate
Imports a audit template master data. AuditTemplates will be used to link them via audit plans (clsImportBPAuditPlan) to business partner and plan recurring audits (clsImportBPAuditTask).

MS Access Table: MARIProjektImportWorkItemBPAuditTemplate. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportBPAuditTemplate(clsImportBPAuditTemplate, clsImportBaseeImportMode) to import. MSAccess Import Table: MARIProjectImportWorkItemBPAuditTemplate.

Public classclsImportBPBank
Class to fill the OCRB Business Partner Bank Link table
Public classCode exampleclsImportBPContactPerson
Contact Person to a business partner. Add Instances of this object to clsImportBusinessPartner.CollectionContactPerson collection.

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Public classclsImportBPGroup
Small Helper Class to create:

Customer Groups (OCRG WHERE GroupType='C') in SBO via DI-API

Supplier Groups (OCRG WHERE GroupType='S') in SBO via DI-API

Industries (OOND) in SBO via DI-API

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Public classCode exampleclsImportBusinessPartner
Creates a new business partner data to SAP Business One OCRD table via DI-API or ServiceLayer.

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Use MPInterface.bImportBusinessPartner(clsImportBusinessPartner, clsImportBaseeImportMode) to import.
Public classclsImportClassNotification
Import for table MPSysClassNotification: Notification Management: Definition of used events by master data dimension
Public classCode exampleclsImportClassNotificationText
Import for table MPSysClassNotificationText: Notification Text Definition (Header Table). See clsImportClassNotificationTextLang for the language definition
Public classclsImportClassNotificationTextLang
Import for table MPSysClassNotificationTextLang: Notification Text Definition (Language child Tables). Use the clsImportClassNotificationText class to import a notification text. Add this Objects to the NotificationTextLanguages list.
Public classclsImportCommissionInitial
Data holder to import a the inital load for contract commissions and none project related sales order commissions. DTW is using the table
MARIProjektImportCommissionInitial
for import.
Public classclsImportContractAnzahlungen
Public classCode exampleclsImportCustomerLocationTree
Import the customer location for customer service objects and equipment.

MS Access table: MARIProjektImportCustomerTrees. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportCustomerLocationTree(clsImportCustomerLocationTree, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportCustomerLocationTreeElement
Import the customer location elements for customer service objects and equipment.

MS Access table: MARIProjektImportCustomerTreeElements. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportCustomerLocationTreeElement(clsImportCustomerLocationTreeElement, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportCustomerServiceObject
Info for table MPCustomerEquipmentCard: Advanced table to sbo standard customer equipment card. Using the access table MARIProjektImportCustomerServiceObjects.

Use MPInterface.bImportCustomerServiceObject(clsImportCustomerServiceObject, clsImportBaseeImportMode) to import.

Public classclsImportCustomerServiceObjectCategory
Info for table MARICustomerEquipmentCardCategory from the access table MARIProjektImportCustomerServiceObjectCategory.

Use MPInterface.bImportCustomerServiceObjectCategory(clsImportCustomerServiceObjectCategory, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportCustomerServiceObjectLocation
Import for table MPCustomerEquipmentLocation: Current location of a CSO at the client/Project (Location Tree): Access Table: MARIProjektImportCustomerServiceObjectLocation

Use MPInterface.bImportCustomerServiceObjectCategory(clsImportCustomerServiceObjectCategory, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportCustomerServiceObjectPart
Import parts to a customer service object. Using the table MARIProjektImportCustomerServiceObjectParts in the access database.

Use MPInterface.bImportCustomerServiceObjectPart(clsImportCustomerServiceObjectPart, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportDocument
Public classCode exampleclsImportDraftDocument

Import prerecorded goods receipt, prerecorded A/P Invoices

Header Object: clsImportDraftDocument

Positions: clsImportDraftDocumentPos

Use MARIInterface.bImportDraftDocument(clsImportDraftDocument, clsImportBaseeImportMode) to import a new document

Public classCode exampleclsImportDraftDocumentPos
Positions for prerecorded goods receipt or A/P invoices. Used only with ListOfDraftPositions.

Use MARIInterface.bImportDraftDocument(clsImportDraftDocument, clsImportBaseeImportMode) to import a new document

Public classCode exampleclsImportDraftDocumentPosLink
Allocation of a project/phase/Contract.. to a prerecorded document import. Sub class to clsImportDraftDocumentPos.ProjectAllocationLines. Cannot be imported manually.

Use MARIInterface.bImportDraftDocument(clsImportDraftDocument, clsImportBaseeImportMode) to import a new document

Public classclsImportEmail
Data holder to import emails into the MARIProject database
Public classclsImportEMailAttachment
Data holder to import emails attachment files into the MARIProject database
Public classCode exampleclsImportEmployee
Data holder to import the employee data into the MARIProject database (ClassID.Employees=33). The import will store the master data and the first details (valid from) to the employee. Use MPInterface.bImportEmployee(clsImportEmployee, clsImportBaseeImportMode) to import.

This class contains several tables. In real data many of the tables are 1:n to the employee master. For the initial import, the subtables can be created in one go.

User the newer class clsImportEmployeeMaster with objects for the 1:n tables.
Public classclsImportEmployeeAbsence
Import vacation and other absencees from external sources. based on the RangeFrom RangeTo, all existing data will be overwritten.

Use bImportEmployeeAbsense(clsImportEmployeeAbsence, clsImportBaseeImportMode) to import.

Public classclsImportEmployeeAbsenceLine
Line for the class clsImportEmployeeAbsence. Please use the list Absences to feed the objects
Public classclsImportEmployeeAnnualVacation
Import for table MPPersonenUrlaubsplan: Employee Master: Vacation Management Annual Vacation
Public classclsImportEmployeeCostRates
Employee cost rates.
Public classclsImportEmployeeCostRatesProject
Import for table MPPersonenVerrechnungProjekt: Employee Master: Cost Rates per project for freelancers
Public classCode exampleclsImportEmployeeMaster
Import employe master including some or all linked tables. This class can be used as of version 6.4 (11/2020) and will replace clsImportEmployee. The old class has properties for some of the sub tables.. Use bImportEmployeeMaster(clsImportEmployeeMaster, clsImportBaseeImportMode) to import an employee.

This class contains several sub tables. In real data many of the tables are 1:n to the employee master. For the initial import, the subtables can be created in one go.

Public classclsImportEmployeeOrganisation
Import for table MPPersonenOrganisation: Employee Master: One line per employee and valid from period
Public classclsImportEmployeePeriod
Import for table MPPersonenPeriode: Employee Master: One line per employee and valid from period and business unit

One class is required to create a new employee master using bImportEmployeeMaster(clsImportEmployeeMaster, clsImportBaseeImportMode). This class has to be added to the clsImportEmployeeMaster.ListOfEmployeeValidFrom list.

This class can also be used to create an additional ValidFrom period for an existing employee master. Use bImportEmployeePeriod(clsImportEmployeePeriod, clsImportBaseeImportMode).

Public classclsImportEmployeePoolLink
Data holder to import the link of a pool to an employee. See also clsImportResourcePool and clsImportEmployee.

View: MARIEmployeesPool::Table: MPPersonenPool

Public classclsImportEmployeeProjectLink
1:n Table to store the link to special projects in the Employee Master: Project link (standard vacation project...). Can be used with the import of an employee. See ListOfProjectLinks.
Public classclsImportEmployeeServiceLink
Definition of prefered services in the employee master. Can be used with the import of an employee. See ListOfServiceLinks.
Public classCode exampleclsImportEmployeeSkillLink
Import for table MPPersonenSkills: Employee Master: Employee Skill link. Use MPInterface.bImportEmployeeSkillLink(clsImportEmployeeSkillLink, clsImportBaseeImportMode) to import. Reads the MARIProjektImportData.mdb and the tables MARIProjektImportEmployeeSkillLink.
Public classclsImportEmployeesTravelMilage
Import for table MPPersonenFahrzeugarten: Employee Master: Linked mileage allowances

This calss is a child class in clsImportEmployeePeriod and can be stored in ListOfTravelMilage.

Public classCode exampleclsImportEquipmentBookings
Import class to import equipment bookings. This class is very close to clsImportLine, but it covers the equipment bookings instead of time bookings.

Use MPInterface.bImportEquipmentBooking(clsImportEquipmentBookings, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportEquipmentCategory
Import for table MPEquipmentCategory: EquipmentCategory: Cagetory Master

View: MARIEquipmentCategory: :Table: MPEquipmentCategory

Table in access: MARIProjektImportEquipmentCategory. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportEquipmentCategory(clsImportEquipmentCategory, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportEquipmentCategoryBPCatalog
Import for table MPEquipmentCategoryBPCatalog: EquipmentCategory: Business Partner Catalog Number

New table with version 5.1: View: MARIEquipmentCategoryBPCatalog: :Table: MPEquipmentCategoryBPCatalog

Table in access: MARIProjektImportEquipmentCategoryBPCatalog

Requires record in: View: MARIEquipmentCategory: :Table: MPEquipmentCategory

Use MPInterface.bImportEquipmentCategoryBPCatalog(clsImportEquipmentCategoryBPCatalog, clsImportBaseeImportMode) to import.

Public classclsImportEquipmentCategoryPart
Import parts to an equipment category. Using the table MARIProjektImportEquipmentMasterParts from the access database.

Use MPInterface.bImportEquipmentCategoryPart(clsImportEquipmentCategoryPart, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportEquipmentCategorySubject
Import for table MPEquipmentCategorySubject: EquipmentCategory: Standard cost types for categories. Please use this class only for second, third... subject to a category. The first category (UnitHandling=eUnitHandling.ReservationPlanningDays=1) will be created directly with the equipmetn category.

View: MARIEquipmentCategorySubject: :Table: MPEquipmentCategorySubject

Table in access: MARIProjektImportEquipmentCategorySubject

Requires record in: View: MARIEquipmentCategory: :Table: MPEquipmentCategory

Use MPInterface.bImportEquipmentCategoryAdditionalSubjects(clsImportEquipmentCategorySubject, clsImportBaseeImportMode) to import additional subjects. Use this class already when creating a clsImportEquipmentCategory.

Public classclsImportEquipmentCategorySubjectRate
Small helper Class to store for each company/business unit, the ItemCode, Cost, Salse Price. Import for table MPEquipmentCategorySubjectRates: EquipmentCategory: Standard cost and sales prices for the cost types of categories
Public classCode exampleclsImportEquipmentLocation
Import for table MPEquipmentLocation: Equipment: Current Location of this equipment. Each import will add a current location. The old status will be changed. The LocationChangeDate has to be the last in the row.

Use MPInterface.bImportEquipmentLocation(clsImportEquipmentLocation, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportEquipmentMaster
Data holder to import the equipment master linked to an existing equipment category.

Use MPInterface.bImportEquipmentMaster(clsImportEquipmentMaster, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportEquipmentMasterAssemblyLink
Import for table MPEquipmentDetailsLink: Equipment Assembly: List of inner components AccessMDB = MARIProjektImportEquipmentMasterAssemblyLink

Use MPInterface.bImportEquipmentMasterAssemblyLink(clsImportEquipmentMasterAssemblyLink, clsImportBaseeImportMode) to import.

Public classclsImportEquipmentMasterPart
Import parts (spareparts, wareparts, components) to an equipment master. Using the table MARIProjektImportEquipmentMasterParts from the access database.

Use MPInterface.bImportEquipmentMasterParts(clsImportEquipmentMasterPart, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportERPDocument
Data holder to import a Document to SAP Business One via DI-API

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Public classclsImportERPDocumentclsERPDocumentPosition
Store information about one line OIN1 POH1... in the clsImportERPDocument object. oPositions
Public classclsImportERPProfitCenter
Public classclsImportERPProfitCenterclsImportERPProfitCenter
Public classCode exampleclsImportERPProjectCode
Data holder to import a Project Code to ERP System via DI-API into OPRJ.

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Public classCode exampleclsImportERPResource
Store Resources data via DI-API to ORSC into the database given CompanyID.

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Use MPInterface.bImportERPResource(clsImportERPResource, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportExchangeRateForPlanning
The MARIProject Exchange rate is used for transactions not linked to a date and an daily exchange rate of SAP Business One.

This rate is for example necessary, when a user plans a sales position into the furture. The planned revenue in the system currency will be calculated based on this monthly exchange rate.

Changing exhange rates in the past will recalculate the planning lines and time bookings lines for contracts linked to foreign currencies.

Use MPInterface.bImportExchangeRateForPlanning(clsImportExchangeRateForPlanning, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportExchangeRateSBO
Changes an exchange rate for a time range in SAP Business One via DI-API.

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Use MPInterface.bImportExchangeRateSBO(clsImportExchangeRateSBO, clsImportBaseeImportMode) to import.

Public classclsImportFile

Import a file direkt to the database. Table MPDokumente for files and MPBilder for pictures

Please use clsImportDocument to add a file to the folder mechanism

Public classCode exampleclsImportGroups
Dataholder to import the Groups into MARIGroups or MARIProjectGroups

Use MPInterface.bImportGroup to import.

To list existing groups use MPInterface.oGetGroups

See also clsImportProjectGroups for project groups

Public classCode exampleclsImportItem
Store Item data via DI-API to OITM into the database given CompanyID. The DTW is using the import table MARIProjektImportOITM.

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Use MPInterface.bImportERPItem(clsImportItem, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportItemBooking
Import class to load item time bookings based on contract positions (Item at cost, Item at fixed price) linked to an employees into MARIProject. This class is very close to clsImportLine, but it covers the item bookings instead of time bookings

Use MPInterface.bImportItemBookingLine(clsImportItemBooking, clsImportBaseeImportMode) to import.

See also the usage in the web service: MARIWebService.ItemBookingLine

Public classCode exampleclsImportKnowledgeBaseEntry
Import for table MPKBArtikel: Support Module: Knowledge Base Header with the content of the main languange
Public classCode exampleclsImportKnowledgeBaseEntryLanguage
This class allows to import an additional language to an existing KB Item. User clsImportKnowledgeBaseEntry to create a new KB entry with the main language Import for table MPKBArtikelSprache: Support Module: Knowledge Base Languages
Public classCode exampleclsImportLine
Import class to load time bookings of employees into MARIProject.

Use MPInterface.bImportTimeKeepingLine(clsImportLine, clsImportBaseeImportMode) to import.

See also the usage in the web service: MARIWebService.TimeKeepingLine

Public classCode exampleclsImportMARIUser
Import a user to login to MARIPRoject (internal user, customer portal user)

User bImportMARIUser(clsImportMARIUser, clsImportBaseeImportMode) to import a new or update an existing user.

Public classclsImportNewsletterMaster
Import for table MPNewsletterMaster: Newsletter Campain Master
Public classCode exampleclsImportPayment
This Import Class can attach one single playment to a SBO document via DI-API

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Use MPInterface.bImportERPPayment(clsImportPayment, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportPhase
Import of one phase (branch or leave) to a phase tree.

Please concider the correct planning version. See PlanningVersion. The standard planning version is 3.

MS Access table: MARIProjektImportProjectPhases. See clsImportBase.eImportMode for tables in MS Access updated, when a phase is stored.

Use MPInterface.bImportPhase(clsImportPhase, clsImportBaseeImportMode) to import.

Public classclsImportPhasePredecessor
This import class allows to create a link between two phases.
  • A: Use this class stand alone to create a link to a pair of existing phases
  • B: Add this class to the clsImportPhase class. This only works, if the Predecessor Phase is already created.
Public classCode exampleclsImportPlanning
Import for single planning lines
Public classCode exampleclsImportProductTree
Store Bill of Material structures in the Product Tree table of SBO (OITT) into the given CompanyID used for the import table MARIProjektImportOITT and MARIProjektImportOITTLines.

Please make sure, that SAP Business One DI-API in 32 or 64 bit is installed according to the usage of this interface. The logon user in MARIProject has to have a corresponding user linked to the selected company database.

Use AddLine(clsImportProductTreeLine) to add lines

Use MPInterface.bImportERPProductTree(clsImportProductTree, clsImportBaseeImportMode) to import.

Public classclsImportProductTreeLine
Import Class for lines of a product tree (ITT1 table). Use this class only with the clsImportProductTree object.
Public classclsImportProductTreeStage
Import Class for of a product tree (ITT2 table). Use this class only with the clsImportProductTree object.
Public classCode exampleclsImportProject
Data holder to import the project master data into the MARIProject database.

Use MPInterface.bImportProject(clsImportProject, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportProjectContract
Data holder to import a sales contract linked to a project

import from the MS Access table MARIProjektImportProjectContracts

Use MPInterface.bImportContract(clsImportProjectContract, clsImportBaseeImportMode) to import.

>You can directly add clsImportProjectContractPosition to the property ListOfContractPositions addition contract positions.

Public classCode exampleclsImportProjectContractPosition
Data holder to import the contract positions to contracts.

Used by the MS Access Table MARIProjektImportProjectContractPositions

Used with clsImportProjectContract

See optionally the property CollectionAccountingPos to add directly accounting positions clsImportProjectContractPositionAccountingPos

Use MPInterface.bImportContractPosition(clsImportProjectContractPosition, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportProjectContractPositionAccountingPos
Import for table MPVKVertraegePositionenAkd: Contract Management: Contract positions accounting lines (due date, phase ...).

Can be used to define accounting conditions for one contract position. Add objects to clsImportProjectContractPosition.CollectionAccountingPos of the new position.

Reads from MS Access table: MARIProjektImportProjectContractPositionsAccCond

In addition a single accounting line can be added via MPInterface.bImportContractPositionAccountingPos(clsImportProjectContractPositionAccountingPos, clsImportBaseeImportMode).

Public classclsImportProjectGroups
Import for table MPProjektGruppen: Project Master: Project Groups. Class is simlar with clsImportGroups, but values are stored in another table.

See MPInterface.bImportProjectGroup(clsImportProjectGroups, clsImportBaseeImportMode)().

Public classclsImportProjectPurchaseProcesses
Data holder to import a puchase process:

import from the MS Access table MARIProjektImportPurchaseProcesses

Use MPInterface.bImportPurchaseProcess(clsImportProjectPurchaseProcesses, clsImportBaseeImportMode) to import.

Public classclsImportProjectPurchaseProcessPositions
Data holder to import the contract positions to purchase contracts.

Import by the MS Access Table: MARIProjektImportProjectContractPositions

Used with clsImportProjectPurchaseProcesses

See optionally class for accounting positions clsImportProjectContractPositionAccountingPos

Use MPInterface.bImportPurchaseProcessPosition(clsImportProjectPurchaseProcessPositions, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportPurchaseProcessDocument
Handling to import purchase process: purchase documents. The class reads from the MS Access table MARIProjektImportPurchaseProcessDocument.
Public classclsImportPurchaseProcessDocumentPositions
Data Holder for document positions of purchase process documents. See clsImportSalesContractsDocumentPositions for sales document positions. The class reads from the MS Access table MARIProjektImportPurchaseProcessDocumentPositions.

Purchase Document positions: View: MARIPurchaseProcessDocumentPositions: :Table: MPEKVertraegeBelegePositionen

Public classCode exampleclsImportQualification
Imports a qualification master data. Qualifications will be used to link them via qualification plans (clsImportQualificationPlan) to employees and plan recurring qualification tasks (clsImportQualificationTask).

MS Access Table: MARIProjektImportQualifications. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportQualification(clsImportQualification, clsImportBaseeImportMode) to import. MSAccess Import Table: MARIProjektImportWorkItemQualification.

Public classCode exampleclsImportQualificationPlan
Imports an employee qualification plan. This links a qualification (clsImportQualification) to an employees (clsImportEmployee).

MS Access Table: MARIProjektImportQualificationPlans. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportQualificationPlan(clsImportQualificationPlan, clsImportBaseeImportMode) to import. MSAccess Import Table: MARIProjektImportWorkItemQualificationPlan.

Public classCode exampleclsImportQualificationTask
A qualification task can be used to store the result of an external training or to organize an internal training.

Technically the qualifiation task is close to an internal service task

MS Access Table: MARIProjektImportQualificationTasks. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportQualificationTask(clsImportQualificationTask, clsImportBaseeImportMode) to import.

Use clsImportQualificationTaskPos to import training participants.

Use clsImportWorkItemServiceTaskResource to import the teacher or equpiment to be used in the qualification task

Use clsImportWorkItemServiceTaskResults to import results to a linked checklist

MS Access Table: MARIProjectImportWorkItemQualificationTask.

Public classCode exampleclsImportQualificationTaskPos
Info for table MPWorkItemPosition: Positions for a qualification task

Use MPInterface.bImportQualificationTasksPosition(clsImportQualificationTaskPos, clsImportBaseeImportMode) to import.

MS Access Table: MARIProjektImportWorkItemQualificationTaskPosition.

Public classclsImportQualificationTaskResource
Info for table MPWorkItemResources: Employees or Equipment necessary for a qualification task

MS Access table MARIProjektImportWorkItemQualificationTaskResource.

Use MPInterface.bImportBPAuditTaskResource(clsImportBPAuditTaskResource, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportQualityProcess
Import for table MPQualityProcess: QualityProcess Definition for logistic (goods receipts or goods delivery) and for the service module as check lists. See also the import of questions with clsImportQualityProcessQuestion and clsImportQualityProcessQuestionLimits. MS Access table MARIProjektImportQualityProcess. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportQualityProcess(clsImportQualityProcess, clsImportBaseeImportMode) to import.

Public classclsImportQualityProcessQuestion

Import for table MPQualityProcessQuestions: QualityProcess Definition Questionnaire. Import first clsImportQualityProcess.

MS Access table MARIProjektImportQualityProcessQuestions. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportQualityProcessQuestion(clsImportQualityProcessQuestion, clsImportBaseeImportMode) to import.

Public classclsImportQualityProcessQuestionLimits

Limit values for QualityProcessQuestions linked to an equipment category or an equipment category business partner catalog.

The Quality Checklist and the Questions must exist.

MS Access Table: MARIProjektImportQualityProcessQuestionLimits. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportQualityProcessQuestionLimits(clsImportQualityProcessQuestionLimits, clsImportBaseeImportMode) to import.

Public classclsImportResourcePool
Data holder to import the resource pool core data into the MARIProject database

Use MPInterface.bImportResourcePool(clsImportResourcePool, clsImportBaseeImportMode) to import.

Public classclsImportResourcePoolCostRates
Public classclsImportSalesContractDocument
Data holder to import sales documents. This class reads from the MS Access table MARIProjektImportSalesContractDocument. See clsImportBase.eImportMode relative tables in MS-Access.
Public classclsImportSalesContractDocumentPositionBatch
Import Batch numbers as a sub class to clsImportSalesContractDocumentPositions Additional class to fill ColBatchNumbers with the required batch numbers.

This class can only be used as sub class to the document position

Public classclsImportSalesContractDocumentPositions

Data Holder for document positions of the sale contract documents. The class reads from the MS Access table: MARIProjektImportSalesContractDocumentPositions.

See clsImportPurchaseProcessDocumentPositions for purchase document positions.

Sales Documents positions: View: MARIContractDocumentPositions: :Table: MPVKVertraegeBelegePositionen

Public classclsImportSalesContractDocumentPositionSerialNumber
Additional class to fill ColSerialNumbers with the required serial numbers
Public classCode exampleclsImportService
Data holder to import services master data with linked items from the ERP System. Use multiple line for more than one company or the ListOfServicePositions to add all companies in one step

Used by MS Access table: MARIProjektImportService

Use MPInterface.bImportService(clsImportService, clsImportBaseeImportMode) to import.

Public classclsImportServicePoolLink
Import for table MPLeistungPool: Service Master: Master Data Pool link. Class Used as helper class for the service master clsImportService.

Pool Master data can be imported via clsImportResourcePool.

Public classclsImportServicePosition
This class holds the details to a service master. For each company linked an item for hours and an item for day invoicing can be created.

The class clsImportService offers by default properties for the first company linked. With this class additional company linkes can be defined

The details to a service position are stored in MPVKVertraegePositionen. For each company linked to the service master one header line in MPVKVertraege with MPVKVertraege.Vertragsart = 6 clsImportProjectContracteContractTypes=ServicesDefinition

The property ServiceCode joins this position class with its parent

Public classclsImportSetupBUSettings
Data holder to import the Business Unit Settings: (MS Access Table: MARIProjektImportSetupBUSettings)
Public classclsImportSetupBUSettingsMatrix
Data holder to import the internal service charges settings: MARIProjektImportSetupBUSettingsMatrix
Public classclsImportSetupBusinessUnits
Data holder to import the business units into MARIProject

Used by MS Access table: MARIProjektImportSetupBusinessUnits

Use MPInterface.bImportBusinessUnit(clsImportSetupBusinessUnits, clsImportBaseeImportMode) to import.

Public classclsImportSetupCompanySettings
Data holder to import special settings based on companies: MARIProjektImportSetupCompanySettings
Public classclsImportSetupFormRights
Data holder to import and export form access rights from one database to an other: MARIProjektImportSetupFormRights
Public classclsImportSetupMenuRights
Data holder to import and export menu user rights: MARIProjektImportSetupMenuRights
Public classclsImportSetupUserGroups
Data holder to import user groups for Access Rights into MARIProject: (Access table: MARIProjektImportSetupUserGroups)
Public classCode exampleclsImportSkill
Import for table MPSkills: Skill . Use MPInterface.bImportSkill(clsImportSkill, clsImportBaseeImportMode) to import. Reads the MARIProjektImportData.mdb and the tables MARIProjektImportSkills.
Public classCode exampleclsImportSupportIssue
Data holder to import the support issue (ticket) data into the MARIProject database. Additional dimensions (ToToTask, Idea, DevelopmentTask, HRTask) can be handled in addition.

Using the table MARIProjektImportSupportIssue out of the access import database.

Use MPInterface.bImportSupportIssue(clsImportSupportIssue, clsImportBaseeImportMode) to import.

See also the usage in the web service: MARIWebService.MARITicketCreate

Public classCode exampleclsImportSupportIssueAttachment
Data holder to import additional attachments, notes to an existing support ticket into the MARIProject database.

Use MPInterface.bImportSupportIssueAttachment(clsImportSupportIssueAttachment, clsImportBaseeImportMode) to import.

Public classclsImportSysCustomerLanguages

Import/Update MARIProject Languages with the ISO settings. Used for notifications and sales/purchase invoices.

Stored in table MARISysCustomerLanguages/MPSysKundenSprachen: System: Languages in MARIProject.

They are linked to the languages in the SBO databases via clsImportSysCustomerLanguagesCompany

Public classclsImportSysCustomerLanguagesCompany

Import for the mapping tables between SBO Languages and MARIProject Languages and ISO Languages

Import for table MARISysCustomerLanguagesCompany/MPSysKundenSprachenMandant: System: MARIProject Languages linked to SBO company languages.

Use the collection clsImportSysCustomerLanguages.CustomerLanguageCompanyMapping to import the mappings with the language definition.

Public classCode exampleclsImportSysMasterProperties

Properties can be used for SBO Contact Person, Employees, Event paritipants and also for events and service tasks.

This class imports the property master. They can be linked to the other dimensions with. The link is managed by clsImportSysMasterPropertyLink.

Import for table MARISysMasterProperties/MPSysMasterProperties: Property Settings for master data. (ClassID.SysMasterProperty=564)

Public classclsImportSysMasterPropertyLink

This class will link the following dimensions to the Properties defined in clsImportSysMasterProperties:

Can be used for the following ClassID:

Import for table MPSysMasterPropertyLink: Link between Dimension (ClassID) and a SysMasterProperty. See MPSysMasterProperty.UsageFlag for the used linked dimensions.
Public classclsImportSysMasterPropertyStack
Import for table MPSysMasterPropertyStack: Contract Management: Contract positions (also service master positions)
Public classclsImportSysUserQueryGroup
Import for table MPSysUserQueryGruppe: System: User Defined Groups for Queries
Public classclsImportTenantAction
Import for table MPTenantActions: Action table to store (CreateUser, ChangeUser) Actions in the master database. To be consumed via web service or MARIService
Public classCode exampleclsImportTenantBatchLog
Import for table MPTenantBatchLog: Bucket to store events from batches locally or remote
Public classCode exampleclsImportTenantCustomer
Import for table MPTenantTenants: Management of MARIProject/SBO client installations: Create a tenant customer
Public classclsImportTenantDatabase
Import for table MPTenantDatabases: Management of MARIProject/SBO client datatabases
Public classCode exampleclsImportTenantEnvironment
Import for table MPTenantEnvironments: Base client enviornment (master for over all clients)
Public classclsImportTenantMonitorAppInstallation
Import for table MPTenantMonitorAppInstallations: Bucket to store installation data at client location: installed apps
Public classclsImportTenantMonitorAppUser
Import for table MPTenantMonitorAppUsers: Bucket to store installation data at client location: assigned users
Public classclsImportTenantMonitorAppUserGroup
Import for table MPTenantMonitorAppUserGroups: Bucket to store installation data at client location: installed user groups
Public classclsImportTenantMonitorDatabase
Import for table MPTenantMonitorDatabases: Bucket to store installation data at client location: used databases
Public classclsImportTenantMonitorEnvironment
Import for table MPTenantMonitorEnvironments: Bucket to store installation data at client location: Information from SLD
Public classclsImportTenantMonitorMachine
Import for table MPTenantMonitorMachines: Bucket to store installation data at client location: database servers, RDP Servers, Clients
Public classclsImportTenantMonitorSysLogDebug
Import for table MPTenantMonitorSysLogDebug: Bucket to store installation data at client location: last 10 Sys Logs
Public classclsImportTenantRemoteAction
Result of the client action to be process in the master database (of MARINGO or the partner)
Public classclsImportTenantUser
Import for table MPTenantUsers: Management of MARIProject/SBO client installation users
Public classclsImportTenantUsersDBLink
Import for table MPTenantUsersDBLink: Management of MARIProject/SBO client installation licenses, rights
Public classclsImportTextModules
Import Text Modules (document header, footer, contract positions, hotline text) in to PM
Public classCode exampleclsImportTrainingParticipant
Import for table MPTrainingParticipant: Training Module: List Of Participants
Public classCode exampleclsImportTrainingRegistration
Public classclsImportTrainingRegistrationContractLink
Import for table MPTrainingRegistrationContractLink: Training Module: Selection of billable contract positions (Contract from registration)

Use as sub class for clsImportTrainingRegistration. Add lines to ListOfContractPositions

Public classclsImportTrainingRegistrationOptionLink
Import for table MPTrainingRegistrationOptionLink: Training Module: Selectable options (formaly phases)

Use as sub class for clsImportTrainingRegistration. Add lines to ListOfSelectedOptions

Public classclsImportTravelCategory
Data holder to import the travel category data into the MARIProject database
Public classclsImportTravelCategoryAccount
Data holder to import the travel category account data into the MARIProject database
Public classCode exampleclsImportUserDefinedField
Creates a User Definied Field into selected tables of the MARIProject Database.

Please use first the GetListUserDefinedFields of each dimension to check if the User Definied Field is already created.

Public classclsImportUserDefinedFieldDefinition
Information about a user defined field of a master data table. See GetListUserDefinedFields.

To create new user defined fields use clsImportUserDefinedField.

Public classclsImportWorkItemBase
This class is only for documentation of the field WorkItemType in the table:

View: MARIWorkItem: :Table: MPWorkItem

This class is used, because the following classes are sharing the same tables and enums:

Public classclsImportWorkItemPosBase
shared properties service task positions and qualification tasks.

Used by clsImportWorkItemServiceTaskPosition Service task, internal service task andn results task positions.

Used by clsImportQualificationTaskPos qualification task positions.

Used by clsImportWorkItemTrainingCoursePos cost positions to training cources.

Public classclsImportWorkitemResBase
Public classclsImportWorkItemScheduleDatesBase
Info for table MPWorkItemScheduleDates: Recurring Work Items. base Class used by clsImportWorkItemServicePlanScheduleDate
Public classCode exampleclsImportWorkItemServicePlan
Info for table MPWorkItem: Service Plan for one customer service object or Equipment.

Access Table MARIProjektImportWorkItemServicePlan. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportServicePlan(clsImportWorkItemServicePlan, clsImportBaseeImportMode) to import.

Use clsImportWorkItemServicePlanPosition to import positions to the service plan (Spare parts, services).

Public classCode exampleclsImportWorkItemServicePlanPosition
Info for table MPWorkItemPosition: Positions for Service Plans. The positions can contain standard spare parts and standard services. Access table: MARIProjektImportWorkItemServicePlanPositions

Use MPInterface.bImportServicePlanPosition(clsImportWorkItemServicePlanPosition, clsImportBaseeImportMode) to import.

Public classclsImportWorkItemServicePlanScheduleDate
Plan dates for future scheduled services.
Public classCode exampleclsImportWorkItemServicePlanTemplate
Info for table MPWorkItem: Service Plan Template

MS-Access table: MARIProjektImportWorkItemServicePlanTemplate. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportServicePlanTemplate(clsImportWorkItemServicePlanTemplate, clsImportBaseeImportMode) to import.

Use clsImportWorkItemServicePlanTemplatePosition to import positions to the service template (Spare parts, services and template for).

Public classCode exampleclsImportWorkItemServicePlanTemplatePosition
Info for table MPWorkItemPosition: Positions for Service Plan Templates.

Access table MARIProjektImportWorkItemServicePlanTemplatePos

Use MPInterface.bImportServicePlanTemplatePosition(clsImportWorkItemServicePlanTemplatePosition, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportWorkItemServiceTask
Import headers for Service Tasks, Internal Service Tasks and Result Tasks

MS Access Table: MARIProjektImportWorkItemServiceTask. See clsImportBase.eImportMode relative tables in MS-Access.

Use MPInterface.bImportServiceTask(clsImportWorkItemServiceTask, clsImportBaseeImportMode) to import.

Use clsImportWorkItemServiceTaskPosition to import positions to the task.

Use clsImportWorkItemServiceTaskResource to import the teacher or equpiment to be used in the qualification task.

Use clsImportWorkItemServiceTaskResults to import results to a linked checklist.

Public classCode exampleclsImportWorkItemServiceTaskPosition
Info for table MPWorkItemPosition: Positions for Service Task, internal Service Task and result task.

For additional properties review the base class clsImportWorkItemPosBase

Use MPInterface.bImportServiceTasksPositions(clsImportWorkItemServiceTaskPosition, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportWorkItemServiceTaskResource
Info for table MPWorkItemResources: Employees or Equipment necessary for the service tasks, internal service tasks, result tasks

MS Access table MARIProjektImportWorkItemServiceTaskResources.

Use MPInterface.bImportServiceTasksResources(clsImportWorkItemServiceTaskResource, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportWorkItemServiceTaskResults
Info for table MPWorkItemResults: Results of quality process questionnaire.

MS Access table: MARIProjektImportWorkItemServiceTaskResults.

Use MPInterface.bImportServiceTasksResources(clsImportWorkItemServiceTaskResource, clsImportBaseeImportMode) to import.

Public classclsImportWorkItemServiceTaskStatus
Allows to change the status of an existing service task, work task or result task.

Use MPInterface.bImportServiceTaskStatus(clsImportWorkItemServiceTaskStatus, clsImportBaseeImportMode) to import.

Public classCode exampleclsImportWorkItemTrainingCourse
A training course or event will organize internl resouces (employees, equipment) and used material (catering, material) and participants

A training course is stored in the same tables as service tasks. For MARIInterface different classes are used, to explain the different usage of details

After creating the main trainings course, add positions resources and options:

Use the bImportTrainingCourse(clsImportWorkItemTrainingCourse, clsImportBaseeImportMode) function to import the trainigs course.

Public classclsImportWorkItemTrainingCoursePos
Info for table MPWorkItemPosition: Positions for registration fees and items to be used in the event (light, projectors, beverages) (For your own projectors use the resources and link an equipment to the training course).

For additional properties review the base class clsImportWorkItemPosBase

Use MPInterface.bImportTrainingCoursePosition(clsImportWorkItemTrainingCoursePos, clsImportBaseeImportMode) to import.

Public classclsImportWorkItemTrainingCourseScheduleDate
Follow up trainig courses linked to a main training course
Public classclsImportWorkItemTrainingOption
Public classCode exampleclsImportWorkItemTrainingResources
Info for table MPWorkItemResources: Employees or Equipment necessary for the event or trainig course.

Use MPInterface.bImportTrainingCourseResources(clsImportWorkItemTrainingResources, clsImportBaseeImportMode) to import.

Public classclsInterfaceBase
Base class for some classes
Public classclsKeyPair
Used by InfoClasses to list objects, like projects, phases, contracts, contract positions etc.
Public classclsKeyValue
Small helper class to return a visible key and the internal key. For example Project and Matchcode or ContractID and ContractNumber. Used in MARIContractPos.UserFields.
Public classclsNewsletterTopic
Description of a selectable newsletter topic and the select status of the receipient. clsImportSysMasterProperties for the definition of possible Properties, with the dimension flag ClassID553NewsLetterTopic
Public classclsOpenItem
Small Helper class to show the open items for customers or suppliers. Created by oGetListOpenItems
Public classclsPublicEnums
Small helper class to show use full enumerations for the database table description
Public classclsSBODMSDocumentList4OneObject
Response to the request to list all linked documents to one dataset (Journalentry, sales/Purchase document...)
Public classclsSBOWebClientHandler
Small help class to read information for the SAP WebCleint via MARIRestService to provide data
Public classclsSBOWebCustomerInfo
Data from MARIProject for the selected business partner
Public classclsSBOWebCustomerInfoProject
One line representing the linked projects to a business partners
Public classclsSBOWebCustomerInfoTickets
Public classclsSBOWebDocumentInfo
MARIProject Information linked to a SBO document (OINV, OPOR...)
Public classclsSBOWebDocumentInfoclsSBOWebLinkedDocument
Small information about the corresponding document in MARI, which orgianyally created the SBO docuent
Public classclsSpecial8UnitTest
Internal helper class for Unit Tests
Public classclsTask
Helper class to send an event for each step in the importing process to show a process bar
Public classclsTaskMeterInitEventArgs
Event Parameter for the process bar initialisation
Public classclsTaskMeterUpdateEventArgs
Event Parameter for the process bar initialisation
Public classclsTrainingCourseHandshakeBillingOptions
Small helper class to describe the possible billing options, when registering to an event.

See TrainingCourseSelectableBillingPositions

Public classclsTrainingCourseHandshakeRegistrationStatus
Small helper class to describe a status and the numer of partcipants with that status.

See TrainingCourseNumberOfParticipantsPerStatus

Public classclsTrainingCourseHandshakeRequest

Request object for the MARIInterface.TrainingCourseWebFrontEndHandshake(clsTrainingCourseHandshakeRequest) function.

Request object for the MARIWebService function: MARIWebService.TrainingCourseWebFrontEndHandshake

Different Processes

  • Training Cources:
    • Register to a training course (event) based on the hyper link in the invitation email
    • Free registration process for a public event. (Send email with confirmation link, Compleate in step 2)
  • Newsletter self service:
    • Change my newsletter settings based on a permanent newsletter token
    • Apply for receiving newsletters, by a email with link handshake.

See clsTrainingCourseHandshakeRequesteAction for the different actions and the samlpe php files.

Public classclsTrainingCourseHandshakeResult
Result class used by Web Service to get information, register or unregister from an event, training course, qualification task, BP audit task, service task. Use TrainingCourseWebFrontEndHandshake(clsTrainingCourseHandshakeRequest) to get this information or use it to set information.

The results are depending on the clsTrainingCourseHandshakeRequest.clsTrainingCourseHandshakeRequesteAction

Public classclsTrainingcoursHandshakeRequestParticipant

Helper object for the MARIInterface.ListOfParticipants and ListOfParticipants property.

Public classCode exampleclsUpdateEmployee
Class to update MARIProject employee data.

For the descriptions of the properties see also clsImportEmployee.

Public classclsUpdateEmployeePeriod
Class to update employee period data. Class is replaced by clsImportEmployeePeriod
Public classMARIContractPos
Helper object for updating contract BOM structures. Used by MARIWebService

See MARIWebService.MARIContractPositionUpdate

Public classMARIContractPosReturnInfo
Data class to return the result for the contract position creation process.

See MARIWebService.MARIContractPositionUpdate

Public classCode exampleMPInterface
The main interface to handle all actions in MARIInterface
Public classProjectTypeExtentions
Extention Module for the Project Type Enum.
Public classSerializableDictionaryTKey, TValue
Small helperclass to serialize the user defined fields stored in a dictionary
Interfaces
  InterfaceDescription
Public interfaceIclsCommingGoing
Delegates
Enumerations
  EnumerationDescription
Public enumerationclsBatchImportDimensioneImportMethod
Handling for the dimension, when importing the data from to the database. This setting depends from the source.

Import methods

  • Import: Adds new lines to the database. Ignores existing data, by simply adding new
  • Synchronize: tries to synchronize the existing data with the new data. This mode is only avaliable for some dimesions
  • Update: Chanegs existing data. This mode is only avaliable for some dimesions

Public enumerationclsCommingGoingeMI_ActionType
This Class is only to display Information about the attendance process. See clsImportAttendanceDayActivity.eAttendanceActivityType for the current enumeration.
Public enumerationclsEmployeeAttendanceDayInfoeDayErrorCode
Error Status as a day summary
Public enumerationclsEmployeeAttendanceDayInfoeDayStatus
Current Day Status considering all activities of the day. Used for the current status in the day
Public enumerationclsEmployeeAttendanceDayInfoeDayType
Type of day. When only vacation start and vacation stop are activities, the day is a vacation day.
Public enumerationclsEmployeeAttendanceDayInfoeProjectTimeTolerance
Status, when compairing projec time and attendance time
Public enumerationclsImportAttendanceDayActivityeActivityErrorCodes
Internal codes created, when an activity does not match the rules.
Public enumerationclsImportAttendanceDayActivityeAttendanceActivityType
Public enumerationclsImportAttendanceDayActivityeSourceTypes
Source of the activity. Type of software used to make the entry.
Public enumerationclsImportBaseeCoreDataClassID
Identifier for each core data dimension. Used in many tables as ClassID.

Overview of ClassIDs by table

Public enumerationclsImportBaseeImportLogErrWarningLevel
Public enumerationclsImportBaseeImportMode
Import mode for the core data import
Public enumerationclsImportBaseeValidate
Small enumeration to indicate the return value of the validation process
Public enumerationclsImportBookPageElementBaseeContentType
Type of content on a page
Public enumerationclsImportBPAddresseAdresType
Only two address types can be added
Public enumerationclsImportBPAuditPlaneAuditPlanStatus
Status of a Audit Plan for new audit plans
Public enumerationclsImportBPAuditTaskeAuditTaskStatus
Status of a audit task. Review the table

View: MARISupportSettings: :Table: MPHotlineSettings WHERE Setting=18

Public enumerationclsImportBPAuditTemplateeAuditTemplateStatus
Status of a Audit Template for new audit plans
Public enumerationclsImportBPContactPersoneGender
Public enumerationclsImportBPGroupeBPGroupType
Type of the group to use this ibject cur different dimensions.
Public enumerationclsImportBusinessPartnereCardType
Tybe of business partner
Public enumerationclsImportBusinessPartnereVatSTatus
VatStatus Y=Liable, N=Excempt, E=EU in OCRD.VatStatus
Public enumerationclsImportClassNotificationeEventOptionFlag
Extra Options for each event
Public enumerationclsImportClassNotificationeMethodTypes
Channel to distribute the notification. Three options and combinations
Public enumerationclsImportClassNotificationTexteEMailRenderMethod
Rendering method of the notification text. Used in EMailFormat.
Public enumerationclsImportClassNotificationTexteImageHandling
ImageHandling of the embedded images in the html source. Used in ImageHandling.
Public enumerationclsImportCommissionInitialeCommissionImportType
Distinguishes between the destination areas of the commission import.
Public enumerationclsImportCustomerLocationTreeElementeCreationMode
Should parents be created, when LevelName1,2,3... not exists?
Public enumerationclsImportCustomerLocationTreeElementeSearchMode
Hierarchy Search Mode If Search Mode != ElementName (0), than you have to fill LevelSearchKeys
Public enumerationclsImportCustomerServiceObjecteCSOStatus
Public enumerationclsImportCustomerServiceObjectPartePosType
Selection of used Values in the field PosTyp in table:

View: MARIWorkItemPosition: :Table: MPWorkItemPosition

For the full list see clsImportWorkItemBase.eWorkItemPosType.

Public enumerationclsImportDocumenteDocumentType
Type of the document
Public enumerationclsImportDocumenteLinkType
Type of link
Public enumerationclsImportDraftDocumenteDraftDocumentType
MARIProject Internal DocumentType Enum for prerecorded purchase documents
Public enumerationclsImportDraftDocumenteDraftStatus
Public enumerationclsImportDraftDocumentPoseDraftPositionType
Position type for the prerecorded document positions
Public enumerationclsImportEmployeeeCostRateType
Type of the cost rate (per employee, per project)
Public enumerationclsImportEmployeeeEmployeeStatus
Enumeration of the employee status. Can be changed for each ValidFrom period.
Public enumerationclsImportEmployeeeExchangeSyncMode
Employee Individual mode for the planning to exchange calender. See ExchangeSyncMode.
Public enumerationclsImportEmployeeePersonalType Obsolete.
Public enumerationclsImportEmployeeeUserLevel
Internal level to manage the content driven authorizations. (I can open the project master. But I do not see details for all projects)
Public enumerationclsImportEmployeeeUserType
Public enumerationclsImportEmployeeAbsenceLineeAbsenceType
Type of absence. The enumeration correspondence to the project linked to the employee. clsImportEmployeeProjectLinkeProjectTemplateType
Public enumerationclsImportEmployeeMastereEmployeeExchangeSyncMode
Employee Individual mode for the planning to exchange calender. See ExchangeSyncMode.
Public enumerationclsImportEmployeeMastereOutOfOfficeStatus
EMail forwarding type
Public enumerationclsImportEmployeeMastereServiceHandling
The linked list of services can be used to manage the behaviour of the data entry screen
Public enumerationclsImportEmployeePeriodeEmployeeCostRateType
Type of the cost rate (per employee, per project)
Public enumerationclsImportEmployeePeriodeEmployeeMasterStatus
Enumeration of the employee status. Can be changed for each ValidFrom period.
Public enumerationclsImportEmployeePoolLinkePoolLinkPlanningType
Enumeration of the planning types
Public enumerationclsImportEmployeeProjectLinkeProjectTemplateType
Project Template Type for the project linked to the employee
Public enumerationclsImportEquipmentCategoryeEquipmentCategoryAccessMode
Set rights to see equipment in the category
Public enumerationclsImportEquipmentCategorySubjecteCategorySubjectCostMode
Each cost type will have an item, cost price and sales price. This can be stored by business unit or by company.
Public enumerationclsImportEquipmentCategorySubjecteUnitHandling
Manage the handling of the subject
Public enumerationclsImportEquipmentLocationeLocationMode
A location transaction can move an equipment from a warehouse to a project or from a project to a warehouse. Setup the mode for the new location
Public enumerationclsImportEquipmentMastereEquipmentMasterStatus
Equipment Status Type
Public enumerationclsImportEquipmentMastereEquipmentMasterType
Type of Equipment (new in V5.1)
Public enumerationclsImportEquipmentMasterAssemblyLinkeEquipmentLinkType
Standard are equipment linked in an assembly. Special is an assembly in an assembly
Public enumerationclsImportERPDocumentclsERPDocumentPositioneLineTypes
Document Line Types
Public enumerationclsImportERPDocumentclsERPDocumentPositioneTaxType
Simplyfied tax types
Public enumerationclsImportERPDocumentDownPaymentType
Down Payment Type of SAP Business One
Public enumerationclsImportERPDocumenteERPDocTypes
Internal object ids from SAP Business One document tables (OINV...)
Public enumerationclsImportERPResourceResourceTypeEnum
Enum for resource type as in DI-API
Public enumerationclsImportGroupseGroupType
Internal Group type to manage different group for different dimensions. Used in the tables:

View: MARIGroups.GroupTypeTable: MPGruppen.GruppenArt

View: MARIProjectGroups.GroupTypeTable: MPProjektGruppen.GruppenArt

Public enumerationclsImportGroupseLeafType
Veaves of a tree in the hierarchy
Public enumerationclsImportItemeBoManageMethod
Enumeration according ti DI-API Items.SRIAndBatchManageMethod
Public enumerationclsImportItemeEvalSystem
price evaluation mode
Public enumerationclsImportItemeIssueMthd
Enumeration according ti DI-API Items.SRIAndBatchManageMethod
Public enumerationclsImportItemePlaningSys
MRP Mode for the field OITM.PlaningSys
Public enumerationclsImportItemeSerialNumberBatchMode
internal enumeration to define ManBtchNum or ManSerNum
Public enumerationclsImportItemeTreeType
Public enumerationclsImportItemBookingeSourceType
Referency Types in time booking, item booking, equipment booking tables
Public enumerationclsImportKnowledgeBaseEntryeItemType
Type of the KBItem
Public enumerationclsImportLineeSourceReferenceType
Enumeration to manage the source link. Describing the creation module of a time keeping line.
Public enumerationclsImportMARIUsereAuthUserLevel
Internal level to manage the content driven authorizations. (I can open the project master. But I do not see details for all projects)
Public enumerationclsImportMARIUsereLicenseModule
A MARIProject Standard user must be linked to a license
Public enumerationclsImportMARIUsereMPUserType
Setting for two user types
Public enumerationclsImportPaymentePaymentDirection
Incomming or Outgoing
Public enumerationclsImportPaymentePaymentType
Public enumerationclsImportPhaseeAutoPlanningMode
Definition of the phase for planning changes. Property of a single phase. Technically it will only work on Leaves.
Public enumerationclsImportPhaseePhaseStatus
A phase could be active or inactive. A parend phase could be inbetween, when the childs has mixed statuses
Public enumerationclsImportPhaseePhaseType
Type of a phase in the tree
Public enumerationclsImportPhasePredecessoreRelationShipType
Defines the type of relation shop
Public enumerationclsImportPlanningeCalendarMode
Mode when moving a plan bar in the GANTT.
Public enumerationclsImportPlanningePlanningResourceType
Used ressource in planning.
Public enumerationclsImportPlanningePlanningType
Type of the planning in the database
Public enumerationclsImportPlanningeTimeUnit
Public enumerationclsImportProductTreeBoItemTreeTypes
Public enumerationclsImportProductTreeLineBoIssueMethod
Issue method
Public enumerationclsImportProductTreeLineProductionItemType
ProductionItemType (MARINGO internal numbering)
Public enumerationclsImportProductTreeStageBoIssueMethod
Issue method
Public enumerationclsImportProductTreeStageProductionItemType
ProductionItemType (MARINGO internal numbering)
Public enumerationclsImportProjecteProjectAbsenseType
Special type for ProjectType=AbsenseProjects
Public enumerationclsImportProjecteProjectStatus
Actual Status in the project. The history of the status is stored in View: MARIProjectStatus: :Table: MPProjektstatus
Public enumerationclsImportProjecteProjectTemplateSettings
Project Template Flags (bit flags)
Public enumerationclsImportProjecteProjectType
The Project type sets defines different functionality in MARIProject.
Public enumerationclsImportProjecteProjektActiveType
The active type defines, if the project is open for time boocking
Public enumerationclsImportProjectContracteAccountingType
The accounting type is definig the way the contract is selected in the contract collector. This settings can be overwritten by the contact positions
Public enumerationclsImportProjectContracteContractTypes
Types of a contract, service, preliminary definition
Public enumerationclsImportProjectContracteCurrencyHandling
Manage the currency handling, when documents are created out of the contract.
Public enumerationclsImportProjectContracteServiceRangeTemplate
A contract setting can default the calculation of the invoice service date range. Used vor XInvoice ZUGFeRD time rage periode
Public enumerationclsImportProjectContracteVolumeHandling
Action tacken, when the sales amound will exceed the volume of a contract
Public enumerationclsImportProjectContractPositioneAccuntingPositionSplitType
Defines handling of more than one line in CollectionAccountingPos. Used in StandardAccountingType.
Public enumerationclsImportProjectContractPositioneCommisionMode
Mode to calculate the commision for this item. Set in MARIItemProperties
Public enumerationclsImportProjectContractPositioneContractPositionType
Type of the contract position used in the property PositionTyp.

Each type does require different key fields depending on the main dimensions:

View: MARIContractPositions.PositionType: :Table: MPVKVertraegePositionen.PosTyp

Public enumerationclsImportProjectContractPositioneImportModeSBOBOMSource
When ItemCode is a Production bill of material OITM.TreeType='P'. This setting can define the behaviour, when importing this line
Public enumerationclsImportProjectContractPositioneItemMasterHandling
Handling options for importing the linked clsImportItem object
Public enumerationclsImportProjectContractPositioneMaintenanceDueDateType
Calculation method for the due date based on MaintenancePeriodic.
Public enumerationclsImportProjectContractPositioneMaintenancePeriodic
Periodic type for Maintenance Positions
Public enumerationclsImportProjectContractPositioneMaintenanceType
Type of the link between a license item and a maintenance item.
Public enumerationclsImportProjectContractPositionePositionInvoicingType
Organize the invoice creation handling for this contract position. Used in InvoicingType
Public enumerationclsImportProjectContractPositionePurchaseMode
Method of Delivery: Purchase Method to distinguish the processes
Public enumerationclsImportProjectContractPositionePurchasePriceType
Handling of the purchase price
Public enumerationclsImportProjectContractPositioneQuantityType
Handling of quantities. The enum is very specific for different position types. If empty a default will be used.
Public enumerationclsImportProjectContractPositioneSalesPriceType
Handling of the sales price in the contract. Used in the property SalesPriceType
Public enumerationclsImportProjectContractPositioneYesNoDefault
Small enum to offer not to overwrite the default: 0=false, 1/-1=true, all others indicate not to use this setting
Public enumerationclsImportProjectContractPositionAccountingPosePosAccountingStatus
Status on the accounting pos. Will be closed by invoice created.
Public enumerationclsImportProjectContractPositionAccountingPosePosAccountingType
Sets the handling of the accounting position.
Public enumerationclsImportQualificationeQualificationStatus
Status of a qualification for new qualification plans
Public enumerationclsImportQualificationPlaneQualificationPlanStatus
Status of a qualificationplan
Public enumerationclsImportQualificationTaskeTaskStatus
Status of a qualification task. Review the table

View: MARISupportSettings: :Table: MPHotlineSettings WHERE Setting=8

Public enumerationclsImportQualificationTaskPoseQualityTaskPositionTyp
Public enumerationclsImportQualityProcesseAutoPrintReportSaveMode
Type of automatic print/pdf creation when saving check list results
Public enumerationclsImportQualityProcesseQualityProcessType
The quality process table is used for purchase and sales logistic transactions and for the service module: service templates, plans, tasks...
Public enumerationclsImportQualityProcesseSignatureMode
Source for the signature picture.
Public enumerationclsImportQualityProcessQuestioneAnswerType
The results will be stored in the table View: MARIWorkItemResults: :Table: MPWorkItemResults. The data type of the stored results is defined in the AnswerType.
Public enumerationclsImportQualityProcessQuestioneDependencyType
The visibility of a question can depend on an answer of a question above. Measure the diameter of the other side of a hose flunsh makes only sense, if the other side has another diameter.
Public enumerationclsImportQualityProcessQuestioneLimitHandling
Define the result test for a question based on the entered value
Public enumerationclsImportQualityProcessQuestioneLimitVisibility
Show the user the lower and upper minimum for the question (or addtional limits). Only on nummeric questions
Public enumerationclsImportQualityProcessQuestioneRetestOption
Some values must not be mesuered every time. Retest is a second test of the same object (customer service object or equipment) can show or hide the previous result.
Public enumerationclsImportQualityProcessQuestionLimitseQPLimitLinkType
Link type to link the limits
Public enumerationclsImportResourcePoolePoolCostRateType
Type of the cost rate (per standard employee, per cost table)
Public enumerationclsImportResourcePoolePoolType
Enumeration of the Pool types
Public enumerationclsImportSalesContractDocumenteDocTypes
MARIProject InternalDocumentType Enum for contracts or purchase processes
Public enumerationclsImportSalesContractDocumenteFilterBalanceMode
Public enumerationclsImportSalesContractDocumentPositionseBaseType
Internal Object Type of SAP Business One
Public enumerationclsImportSalesContractDocumentPositionsePosTypes
MARIProject internal line type to match the SBO Position line types.
Public enumerationclsImportSetupFormRightseFormRigtsUserType
Enum for the Property UserType.
Public enumerationclsImportSupportIssueeHotlineClassType
Five different dimensions to be hosted in one table set. The dimension can not be easly change, becuase the IssueType, Status, Priority, Medium are depending on the dimension
Public enumerationclsImportSupportIssueeIssueTyp
Enumeration of the Issue types. The enumaeration is extensible by customer.

See Table SELECT ID FROM MPHotlineSettings WHERE Setting=2

See View SELECT ID FROM MARISupportSettings WHERE Setting=2

The selection by dimension (HotlineClassType) is stored in the viw table MARISupportSettingsClassType / table MPHotlineSettingsClassType

Public enumerationclsImportSupportIssueeParentType
For a special set of tickets you can link one ParentTicket to several customers facing the same issue. The link to the customer is done via the Type ChildTicket
Public enumerationclsImportSupportIssueeSupportTicketMedium
Enumeration of the Issue Medium. The enumaeration is extensible by customer

See Table SELECT ID FROM MPHotlineSettings WHERE Setting=5

See View SELECT ID FROM MARISupportSettings WHERE Setting=5

The selection by dimension (HotlineClassType) is stored in the viw table MARISupportSettingsClassType / table MPHotlineSettingsClassType

Public enumerationclsImportSupportIssueeSupportTicketPriority
Enumeration of the Issue priorities. The enumaeration is extensible by customer.

See Table SELECT ID FROM MPHotlineSettings WHERE Setting=3

See View SELECT ID FROM MARISupportSettings WHERE Setting=3

The selection by dimension (HotlineClassType) is stored in the viw table MARISupportSettingsClassType / table MPHotlineSettingsClassType

Public enumerationclsImportSupportIssueeSupportTicketResponsibleType
Enumeration of the issue responsible types
Public enumerationclsImportSupportIssueeSupportTicketSolutionApproach
Enumeration of the Issue solution approachs The enumaeration is extensible by customer

See Table SELECT ID FROM MPHotlineSettings WHERE Setting=4

See View SELECT ID FROM MARISupportSettings WHERE Setting=4

The selection by dimension (HotlineClassType) is stored in the viw table MARISupportSettingsClassType / table MPHotlineSettingsClassType

Public enumerationclsImportSupportIssueeSupportTicketStatus
Enumeration of the Issue states. The enumaeration is extensible by customer.

See Table SELECT ID FROM MPHotlineSettings WHERE Setting=1

See View SELECT ID FROM MARISupportSettings WHERE Setting=1

The selection by dimension (HotlineClassType) is stored in the viw table MARISupportSettingsClassType / table MPHotlineSettingsClassType

Public enumerationclsImportSupportIssueAttachmenteAttachmentTyp
Enumeration of the attachment types
Public enumerationclsImportSysCustomerLanguageseLanguageMode
Flag to distinguish between standard languages created with every new MARIProject database and additional langauges
Public enumerationclsImportSysMasterPropertieseSysMasterPropertyUsageDimensionFlag
Define the use of the property. (This only applies for leaves. Branches of the tree inherits the flags from the leaves)
Public enumerationclsImportSysMasterPropertieseSysMasterPropertyUsageType
Destinguish between a proeprty (indent0 or 1) and a header (indent 0)
Public enumerationclsImportSysUserQueryGroupeUserQueryGroupType
Type of group for MARIProject Queries and for SBO Queries (Rights to be used out of MARI)
Public enumerationclsImportTenantActioneTenantActionStatus
Public enumerationclsImportTenantBatchLogeTenantErrorCode
Three error levels
Public enumerationclsImportTenantDatabaseeTenantAppType
Public enumerationclsImportTenantDatabaseeTenantDatabaseServerType
Public enumerationclsImportTenantDatabaseeTenantUseType
Public enumerationclsImportTenantMonitorEnvironmenteMonitorDimensionType
Additional Information to be stored attached to the environment
Public enumerationclsImportTenantMonitorMachineeTenantMachineType
Public enumerationclsImportTenantUsersDBLinkeTenantUserType
Public enumerationclsImportTextModuleseTextModuleTypes
Public enumerationclsImportTrainingParticipanteParticipantType
Three different types of participants can visit a training or event
Public enumerationclsImportTravelCategoryeTravelCatType
Type of the travel expense categorie
Public enumerationclsImportTravelCategoryAccounteCompanyMode
Used for all business units/companies
Public enumerationclsImportTravelCategoryAccounteDefaultType
Public enumerationclsImportTravelCategoryAccounteGLAccountType
Type of the account definition
Public enumerationclsImportTravelCategoryAccounteProfitCenterHandling
Select source of the profic center
Public enumerationclsImportTravelCategoryAccounteProjectCodeHandling
Source for the project code
Public enumerationclsImportUserDefinedFieldeComboboxConnectionType
Connection Types for SQL Queries
Public enumerationclsImportUserDefinedFieldeComboboxDataType
Combobox Data Types
Public enumerationclsImportUserDefinedFieldeFieldType
Type of the user defined field.
Public enumerationclsImportWorkItemBaseeWorkItemPosType
Documentation for the field View: MARIWorkItemPosition.PosType: :Table: MPWorkItemPosition.PosType

Not all Positiontypes can be used with all service types. Please review the differenz classes designed for the different opjects on the MPWorkitem table.

Public enumerationclsImportWorkItemBaseeWorkItemType
Public enumerationclsImportWorkitemResBaseeResourceType
Link resource to fullfill the task.
Public enumerationclsImportWorkItemScheduleDatesBaseeLineStatus
Enumeration for the schedule plan date status.
Public enumerationclsImportWorkItemServicePlaneCycleType
Type of the recurring service value
Public enumerationclsImportWorkItemServicePlaneHandlingOnMovementMode
Defines the schedule behaviour, when material is returned with the return wizard.
Public enumerationclsImportWorkItemServicePlaneScheduleType
Defines the scheduling behaviour of the due dates for service plans. Predefiend in the template and used in the service plan
Public enumerationclsImportWorkItemServicePlaneServiceObjectType
Link of the service plan to a customer service object or an equipment
Public enumerationclsImportWorkItemServicePlanTemplateePlanTemplateCycleType
Type of the recurring service value
Public enumerationclsImportWorkItemServicePlanTemplateePlanTemplateScheduleType
Defines the scheduling behaviour of the due dates for service plans. Predefiend in the template and used in the service plan
Public enumerationclsImportWorkItemServicePlanTemplateeTemplateSource
The template can be linked to item groups, items or quipment categories
Public enumerationclsImportWorkItemServicePlanTemplatePositionePlanTemplateContractPosType
Setting for the handling after adding new positions.
Public enumerationclsImportWorkItemServicePlanTemplatePositionePlanTemplatePosType
Public enumerationclsImportWorkItemServiceTaskeServiceTaskType
Three different types of services can be imported with this class. See also other values in the field WorkItemType:

For the full list see clsImportWorkItemBase.eWorkItemPosType.

Public enumerationclsImportWorkItemServiceTaskeWorkItemStatus
Status of a service task. The Status can have additional user defined "child" statuses. Review the table

View: MARISupportSettings: :Table: MPHotlineSettings WHERE Setting=8

Public enumerationclsImportWorkItemServiceTaskPositionePositionTyp
Public enumerationclsImportWorkItemTrainingCourseeAddressType
Setting to disginguish an onsite location with real address and an online meeting with URL (user password)
Public enumerationclsImportWorkItemTrainingCourseeInvoiceOption
Handling for the invoice cration wizard
Public enumerationclsImportWorkItemTrainingCourseeRegisterOptions
Option for the online selection of options
Public enumerationclsImportWorkItemTrainingCourseeRegisterProcess
Defines the type of registraion for this training.
Public enumerationclsImportWorkItemTrainingCourseeTrainingSubType
Differenciation between a Course and a follow up course scheduled by the standard training course
Public enumerationclsImportWorkItemTrainingCourseeTrainngCourseStatus
Status of a Training Course (event) task. Review the table

View: MARISupportSettings: :Table: MPHotlineSettings WHERE Setting=22

Public enumerationclsImportWorkItemTrainingCourseeVisibilityPortal
Defines the visibility of a training course for the external web page
Public enumerationclsImportWorkItemTrainingCoursePoseInvoicePositionMode
Option to select the way, a position is presented to the participant
Public enumerationclsImportWorkItemTrainingCoursePosePositionSelectionVisibleMode
Setting for the registration fee positions, if the positions are visible in the online portal
Public enumerationclsImportWorkItemTrainingCoursePoseTrainingCoursePositionTyp
Position Types for trainig courses/events. Used by the property WorkPosType of the base class.

For the full list of WorkItemPosTypes see clsImportWorkItemBase.eWorkItemPosType.

Public enumerationclsPublicEnumseContractDownPaymentLineType
Down Payment Line Types
Public enumerationclsPublicEnumseContractInstallmentPlanLineType
Installment Line Types
Public enumerationclsPublicEnumseContractType
Public enumerationclsPublicEnumseDocumentType
MARIProject Document Types
Public enumerationclsPublicEnumseS_Languages
System Languages
Public enumerationclsPublicEnumsMARIEditControlTyp
User defined User Interface Controls
Public enumerationclsTrainingCourseHandshakeBillingOptionseSelectOption
Definition of the display in the web frontend of the billing position.
Public enumerationclsTrainingCourseHandshakeRequesteAction
Public enumerationclsTrainingCourseHandshakeResulteOptionsBillingPosSelectionMode
Setting in the training course to enable a selection of options and or selection of billing positions
Public enumerationclsTrainingCourseHandshakeResulteRegistrationStatus
Information about the registration status. This List can be changed in the settings. This enumeration is the default.

See select * FROM MPHotlineSettings WHERE Setting=24

Public enumerationclsUpdateEmployeePeriodeCostRateType
Type of the cost rate (per employee, per project)
Public enumerationclsUpdateEmployeePeriodePersonalType
Enumeration of the employee types
Public enumerationMARIContractPosePOPriceMode
Public enumerationMARIContractPosePurchaseType
Public enumerationMARIContractPosReturnInfoeReturnStatus
Public enumerationMARIContractPosReturnInfoeValidationMode
Public enumerationMPInterfaceeOpenItemType
Parameter for oGetListOpenItems