Examples of search templates

Example 1

A search template definition for CurrencyExchangeRateMaster to get the currency exchange rate between two currency codes during a specific date and time:

Search result

The rateNumeric attribute of the CurrencyExchangeRateMaster

p_sourceCur, p_targetCur and p_startDate are the search parameters that are compared against sourceCur, targetCur, startDate, and endDate attributes of the CurrencyExchangeRateMaster

sourceCur == p_sourceCur AND

targetCur == p_targetCur AND

startDate <= p_startDate AND

endDate >= p_startDate

Example 2

A search template definition for AccountingBookDefinition to get the currency code, and accounting chartreference, and the financial calendar reference of an accounting book ID:

Search result

The currrencyCode attribute of the AccountingBookDefinition

The accounting chart reference ID attribute of the AccountingBookDefinition accChartRef
The financial calendar reference ID attribute of the finCalRef
p_acctgBookId is the search paramater that are compared against acctgBookId attribute of the AccountingBookDefinition acctgBookId == p_acctgBookId

You cannot create a search template for transactional documents.

For accounting framework integration, there are predefined search templates for retrieving master data setup and journal user field information. They are called System-Defined search templates which are delivered with IGFC.

See Master data setup and BPA designer.

Search templates alone cannot be used to retrieve master data information. They are used in conjunction with expressions. During generation of the output, expressions are used to assign values to the attributes of the output business document.

See BPA designer.