When defining data load mapping details, you can define the data to extract, including whether to extract the amount type—monetary, statistical, or both monetary and statistical amounts.
You can extract only functional balances, which are stored in the base currency of the selected ledger or business unit. For example, if transactions are entered in multiple currencies, the total of all transaction balances is expressed in the functional currency.
To define the data load details:
The categories listed are those that you created in the ERP Integrator setup. See Defining Category Mappings.
Monetary
Statistical—The balance selection of entered or functional currency does not apply.
Monetary and Statistical
Select the Amount for Balance Sheet Accounts and Amount for Income Statement Accounts:
YTD—Year-to-date account balance, where account balances are accumulated from the beginning of the year to the current period. Typically, balance sheet accounts (assets, liabilities, and equities) are specified with a YTD balance.
Periodic—Account balance for the specific period. Typically, income statement accounts (revenues and expenses) are specified with a periodic balance.
In PeopleSoft, a business unit may have multiple ledger groups. In this list, ERP Integrator displays only the ledger groups associated with the ledger.
Optional: To select book code values, click
, select book code values, and then click OK.To clear a book code, click
. Then, in the Select Book Code dialog box, clear book codes, and then click OK.To select budget values, click
, select budget values, and then click OK. You specify the budget values if the ledger that you selected has the data table, “Ledger_Budg.”
To deselect budget values, click
. Then, in the Select Budget Scenario Values dialog box, clear values, and then click OK.Define target filter options. See Defining Target Options for E-Business Suite and PeopleSoft Source Systems.
After you define target filter options, run the data rule. See Running Data Load Rules.