Examples of search templates
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 |
rateNumeric |
| Filters | |
| 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 |
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 |
currencyCode |
| The accounting chart reference ID attribute of the AccountingBookDefinition | accChartRef |
| The financial calendar reference ID attribute of the | finCalRef |
| Filters | |
| 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.