MRI Software Connector > Mappings and mapping tasks with MRI Software Connector > MRI Software sources in mappings and mapping tasks
  

MRI Software sources in mappings and mapping tasks

In a mapping, you can configure a Source transformation to represent a single MRI Software source.
The following table describes the MRI Software source properties that you can configure in a Source transformation:
Property
Description
Connection
Name of the source connection.
Source Type
Type of the source object. Select Single Object.
Object
Name of the source object for the mapping.
Filter
Filters records and reduces the number of rows that the Secure Agent reads from the source. You can use a basic filter or an advanced filter to read specific records.
The filter is mandatory for certain MRI Software objects. For more information, see Filtering records from MRI Software sources.

Filtering records from MRI Software sources

You can use a filter expression to reduce the number of rows that the Secure Agent reads from the source.
You can use a basic filter or advanced filter to select specific records from an MRI Software source.
Configuring a filter
Perform the following steps to configure a simple filter or advanced filter:
  1. 1. In the Query Options section, click Configure for the Filter property.
  2. 2. In the Filter Condition list, select Non Parameterized for a simple filter or Advanced for an advanced filter.
  3. 3. Configure the filter condition.
  4. For a simple filter, select the object, field, and operator and specify the filter value.
    The image shows the a simple filter condition
    For an advanced filter, select the object and field and specify the filter expression. You can create complex expressions that use AND, OR, or nested conditions.
    The image shows the adavanced filter expression
  5. 4. Click OK.
Data Pipeline API
The following table provides information on the filter fields for the objects that you can specify when you read data from Data Pipeline API:
Object
Filter support
Filter fields
MRI_S-DPLGL_JOURNAL
Yes
Optional
  • - LASTDATE
MRI_S-DPLAP_GLSUM
No
-
MRI_S-DPLAP_GHIS
Yes
Optional
  • - ENTITYID
  • - STARTPERIOD
  • - ENDPERIOD
MRI_S-DPLRM_NAME
Yes
Optional
  • - LASTDATE
MRI_S-DPLRM_RMBLDG
Yes
Optional
  • - LASTDATE
MRI_S-DPLRM_RMLEASE
No
-
MRI_S-DPLRM_RMLEASEHIST
No
-
MRI_S-DPLRM_RMRECC
No
-
MRI_S-DPLRM_RMLEDG
No
-
MRI_S-DPLRM_RMPROP
Yes
Optional
  • - LASTDATE
MRI_S-DPLCM_BSQF
Yes
Optional
  • - LASTDATE
MRI_S-DPLCM_SUIT
Yes
Optional
  • - LASTDATE
MRI_S-DPLCM_CMRECC
Yes
Optional
  • - LASTDATE
MRI_S-DPLCM_CMRECC_X5
Yes
Optional
  • - LASTDATE
MRI_S-DPLCM_BLDG
Yes
Optional
  • - LASTDATE
MRI_S-DPLCM_LEAS
No
-
MRI_S-DPLCM_SSQF
No
-
REST API
The following table provides information on the filter fields for the objects that you can specify when you read data from REST
Object
Filter support
Filter fields
MRI_S-PMCM_MasterOccupants
No
-
MRI_S-PMAP_JournalEntryGLSegment
Yes
Mandatory
  • - EntityID
  • - StartPeriod
  • - EndPeriod
MRI_S-PMGL_Accounts
Yes
Optional
  • - AccountType
  • - LastDate
MRI_S-PMGL_ChartsOfAccounts
Yes
Optional
  • - LedgerCode
  • - LastDate
MRI_S-PMGL_GLSummary
Yes
Mandatory
  • - StartPeriod
  • - EndPeriod
Optional
  • - EntityID
  • - Basis
  • - Department
  • - AccountName
  • - AccountNumber
MRI_S-PMAP_JournalEntries
Yes
Mandatory
  • - GHISWHERE
  • - JOURNALWHERE
MRI_S-PMGL_JournalEntries
Yes
Mandatory
  • - EntityID
  • - StartPeriod
  • - EndPeriod
Optional
  • - LastDate
MRI_S-PMGL_EntityListing
Yes
Optional
  • - EntityID
  • - PropertyType
  • - PropertySubType
  • - StateID
  • - DispositionDate
  • - LocationID
  • - LastDate
MRI_S-PMBASE_CurrencyExchangeRates
Yes
Mandatory
  • - CurrencyFrom
Optional
  • - CurrencyTo
MRI_S-PMBASE_CurrencyCodes
No
-
MRI_S-PMRM_GetLeaseSummary
Yes
Mandatory
  • - NameID
Optional
  • - LastUpdate
MRI_S-PMRM_LeaseHistory
Yes
Mandatory
  • - NameID
MRI_S-PMRM_Ledger
Yes
Mandatory
  • - StartDate
  • - EndDate
MRI_S-PMRM_RecurringCharges
Yes
Mandatory
  • - PropertyID
Optional
  • - BuildingID
  • - UnitID
  • - LeaseID
  • - LastUpdate
MRI_S-PMRM_RentRoll
Yes
Mandatory
  • - PropertyID
Optional
  • - BuildingID
  • - UnitID
MRI_S-PMRM_ResidentialBuildings
Yes
Mandatory
  • - RMPROPID
Optional
  • - LASTUPDATE
  • - RMBLDGID
MRI_S-PMRM_ResidentialUnits
Yes
Mandatory
  • - RMPROPID
Optional
  • - LastDate
  • - UnitID
MRI_S-PMRM_ResidentLeases
Yes
Mandatory
  • - PropertyID
Optional
  • - LASTUPDATE
MRI_S-PMRM_ResidentLedger
Yes
Mandatory
  • - PropertyID
  • - StartDate
  • - EndDate
Optional
  • - NameID
  • - TransactionID
MRI_S-PMRM_Residents
Yes
Mandatory
  • - LastUpdate
Optional
  • - NameID
  • - PropertyID
MRI_S-PMCM_EntityActivityTotalByAccount
Yes
Mandatory
  • - EntityID
  • - PeriodStart
  • - PeriodEnd
Optional
  • - AccountingBasis
  • - BudgetType
MRI_S-PMCM_CommercialLedger
Yes
Mandatory
  • - BuildingID
Optional
  • - LeaseID
MRI_S-PMCM_CommercialLeasesLeasByBuildingID
Yes
Mandatory
  • - MasterOccupantID
Optional
  • - LastUpdateDate
  • - LeaseID