Search Results dr_cr_bfwd

Overview

XTR_GENERAL_LEDGER_SUMMARY_V is a Treasury (XTR) module database view in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes summarized General Ledger accounting information generated by the Treasury subledger accounting and GL transfer process. The view presents one row per company code, accounting period, GL transfer date, code combination, and currency, with debit and credit balances carried forward, transferred, and brought forward for each accounting period. Its principal role is to support reporting on foreign exchange, hedging, and revaluation activity that the Treasury module passes to the General Ledger, and to provide a queryable representation of the data consolidated in the underlying XTR_GENERAL_LEDGER_SUMMARY table.

The view is particularly relevant to users searching for the DEBIT_CREDIT column, which is the indicator that distinguishes debit-side entries from credit-side entries within a Treasury accounting period. Because Treasury journals combine debits and credits into a single summarized stream, the DEBIT_CREDIT field is essential for producing balanced GL transfer reports and for reconciling Treasury subledger balances to the General Ledger.

Underlying Base Objects

According to the documented metadata, the view is defined over a single base object, XTR_GENERAL_LEDGER_SUMMARY, as evidenced by the final clause FROM XTR_GENERAL_LEDGER_SUMMARY. No additional base tables, joins, or referenced objects are documented in the ETRM metadata for this view.

The view is a straightforward projection: it selects a defined set of columns from XTR_GENERAL_LEDGER_SUMMARY without apparent aggregation or filtering. As a result, the grain of the view matches the grain of the underlying summary table — one row for each combination of company code, accounting period, GL transfer date, code combination, currency, and debit/credit indicator. This makes the view a convenient, stable read-only interface that shields reporting queries from changes to the physical table's column ordering. Because the view is a Treasury-owned object, it should be queried with appropriate Treasury responsibilities or with database privileges that include SELECT access on XTR schema objects.

Key Columns

• COMPANY_CODE — Legal entity or company identifier for the summarized ledger activity.
• ACCOUNTING_PERIOD — The GL period to which the summarized amounts belong.
• GL_TRANSFER_DATE — Date the summarized amounts were transferred to the General Ledger.
• CODE_COMBINATION_ID — Foreign key to the GL code combination (accounting flexfield) used for posting.
• CURRENCY — Transactional currency of the summarized amounts.
• DEBIT_CREDIT — Indicator distinguishing debit entries from credit entries within the summary, central to balancing GL transfers.
• BALANCE_BFWD / DR_CR_BFWD — Balance brought forward at the start of the period and its debit/credit orientation.
• TRANSFER_AMOUNT — Amount transferred to the General Ledger for the period.
• HCE_TRANSFER_AMOUNT / HCE_TSFR_DR_CR — Transfer amount and orientation expressed in the reporting (HCE) currency.
• BALANCE_CFWD / DR_CR_CFWD — Closing balance and its debit/credit orientation.
• LATEST_BALANCE — Most recent running balance for the code combination and currency.
• TRANSFER_TO_EXTERNAL_GL — Flag indicating whether the amounts were transferred to an external General Ledger.
• OPEN_REVAL_RATE / CLOSE_REVAL_RATE / NET_REVALUATION — Opening and closing revaluation rates and the resulting net revaluation amount.
• HCE_TSFR_PLUS_REVAL, BALANCE_CFWD_HCE_DR_CR, HCE_BALANCE_CFWD — HCE-currency aggregation of transfer, revaluation, and closing balance with orientation.
• COMMENTS — Free-text annotation captured with the summarized row.

Common Use Cases and Queries

Typical uses include GL transfer reconciliation, revaluation reporting, and Treasury-to-GL balance verification. A common query filters by period and company while isolating debit and credit activity:

SELECT company_code, accounting_period, currency, code_combination_id,
  debit_credit, balance_bfwd, transfer_amount, balance_cfwd
FROM xtr_general_ledger_summary_v
WHERE accounting_period = :period
  AND company_code = :company
ORDER BY code_combination_id, currency, debit_credit;

To review HCE revaluation results for a period:

SELECT company_code, code_combination_id, currency,
  open_reval_rate, close_reval_rate, net_revaluation,
  hce_transfer_amount, hce_balance_cfwd
FROM xtr_general_ledger_summary_v
WHERE accounting_period = :period
  AND net_revaluation <> 0;

To identify rows not yet transferred to an external GL:

SELECT * FROM xtr_general_ledger_summary_v
WHERE transfer_to_external_gl = 'N';

Because the view carries no documented filter predicates, queries should always include period, company, or code combination predicates to limit result sets on high-volume Treasury implementations.