Search Results taxable_accounted_dr




Overview
Explore in AI Chat

Overview

The view XLA_JL_BR_AR_BT_AEL_GL_V is a Subledger Accounting (XLA) reporting object that exposes accounting event line data together with its corresponding General Ledger transfer attributes. It is one of the regionalized localization views (indicated by the JL_BR_AR_BT naming convention, associated with the Brazilian Accounts Receivable and accounting event line reporting) that join XLA accounting event lines (AEL) to the GL-facing posting information. Its principal role is to present, in a single flattened structure, the entered and accounted debit/credit amounts, the taxable amounts relevant to tax reporting, the underlying transaction identifiers, and the GL transfer status.

The view is defined over the XLA accounting event line structure and is designed for reporting and integration consumers that need to reconcile subledger accounting against General Ledger, or that require taxable amount columns such as TAXABLE_ACCOUNTED_CR without navigating multiple base tables. According to the documented metadata, the object is not implemented in this database in the source environment, which indicates its availability is conditional on the localization or the version installed. The user search term taxable_accounted_cr maps directly to one of the view's tax reporting columns, confirming its purpose as a tax-aware accounting line view.

Underlying Base Objects

The documented ETRM metadata lists no explicit referenced base objects for this view. Based on the view text, the object is a union-style projection over XLA accounting event line data, drawing from the subledger accounting event line tables (notably the XLA_AE_LINES/XLA_AEL family) and, for the Brazilian localization, the AR-related accounting tables prefixed JL_BR_AR_BT. The AEL_TABLE and AE_LINE_REFERENCE columns are carried through the projection precisely so that consumers can trace each row back to the originating event and source transaction table.

The presence of SOURCE_TABLE, SOURCE_ID, TRX_HDR_TABLE, and TRX_HDR_ID reflects the view's composition over the accounting event model that links a subledger transaction header to its accounting entry lines. Several GL-side columns are represented as literal NULL values — including AEH_ID, TRANSFER_STATUS_DETAIL_NAME, TRANSFER_SYSTEM, ACCOUNTING_COMPLETE, and GL_TRANSFER_FROM_TO_NAME — which suggests the view is structured to conform to a standard reporting column layout while only partially populating GL transfer detail.

Key Columns

Common Use Cases and Queries

The view is typically used to produce tax-aware subledger accounting reports, reconcile taxable versus non-taxable activity, and audit the transfer of accounting entries to GL. A representative query to isolate taxable credited amounts by transaction is:

SELECT TRX_NUMBER_DISPLAYED,
       ACCOUNTING_DATE,
       CURRENCY_CODE,
       TAX_CODE,
       TAXABLE_ACCOUNTED_CR,
       ACCOUNTED_CR,
       GL_TRANSFER_STATUS_NAME
FROM   APPS.XLA_JL_BR_AR_BT_AEL_GL_V
WHERE  TAXABLE_ACCOUNTED_CR <> 0
  AND  SET_OF_BOOKS_ID = :ledger_id
ORDER BY ACCOUNTING_DATE, TRX_NUMBER_DISPLAYED;

A second common pattern aggregates taxable accounted credits by tax code for period reporting:

SELECT TAX_CODE,
       SUM(TAXABLE_ACCOUNTED_CR) taxable_credit,
       SUM(ACCOUNTED_CR) accounted_credit
FROM   APPS.XLA_JL_BR_AR_BT_AEL_GL_V
WHERE  ACCOUNTING_DATE BETWEEN :start_date AND :end_date
GROUP BY TAX_CODE;

Because the object is documented as not implemented in the reference database, availability should be verified with DBA_OBJECTS or DBA_VIEWS prior to reliance, and any dependent custom reports should confirm that the required Chinese localization or patch level is present. Where the view is absent, equivalent results can be obtained by querying the underlying XLA accounting event line tables directly and applying the same taxable amount columns.