Master data setup search templates

To retrieve information from master data setups, system-defined search templates are available. These search templates are predefined and delivered with IGFC. Using these search templates, you can retrieve master data setup information from dimension code assignment, general ledger mapping, and journal user fields.

These are the available system-defined search templates:

Search Template Description
getAcquirerAccountNumber Retrieves the destination ledger account number that is mapped to a given source entity, source accounting book, source ledger account, destination entity, and destination accounting book.
getAcquirerAccountNumberList Retrieves the destination ledger account number with its corresponding allocation rate that is mapped to a given source entity, source accounting book, source ledger account, destination entity, and destination accounting book.
getAcquirerAcctChart Retrieves the destination accounting chart that is mapped to a given source entity, source accounting book, destination entity, and destination accounting book.
getCurrencyRateType Retrieves the currency rate type that is mapped to a given source entity, source accounting book, source accounting journal type, destination entity, and destination accounting book.
getTargetAccountNumberBySourceAcctChart Retrieves the destination ledger account number that is mapped to a given source entity, source accounting book, source accounting chart, source ledger account, destination entity, and destination accounting book.
getTargetAccountNumberListBySourceAcctCha Retrieves the destination ledger account number with its corresponding allocation rate that is mapped to a given source entity, source accounting book, source accounting chart, source ledger account, destination entity, and destination accounting book.
getTargetAcctChartBySourceAcctChart Retrieves the destination accounting chart that is mapped to a given source entity, source accounting book, source accounting chart, destination entity, and destination accounting book.
getTargetCurrencyRateTypeBySourceAcctChart Retrieves the currency rate type that is mapped to a given source entity, source accounting book, source accounting chart, source accounting journal type, destination entity, and destination accounting book.
getDimensionCodeList Retrieves the dimension codes that are assigned to a given accounting chart, entity, accounting book, ledger account number, and transaction.
getDimensionCodeListbyTransType Retrieves the dimension codes that are assigned to a given accounting chart, entity, accounting book, ledger account number, transaction, and transaction type.
getJournalHeaderUserField Retrieves the user field values defined on the journal entry header .
getJournalLineUserField Retrieves the user field values defined on the journal entry line.

For the detailed configuration of the system-defined search templates, see System-defined search templates and IGFC scripting language guide.