Results for “transfer_sh_cess_amount”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view JAI_RG_FUND_TRF_AEL_V is an Oracle E-Business Suite accounting events view owned by the APPS schema and delivered under the JA (Asia/Pacific Localizations) product family. It exposes journal entries generated for Register Fund Transfer transactions, structured as an Accounting Events Line (AEL) view so that downstream Subledger Accounting (SLA) and reporting components can consume the fund-transfer accounting records alongside their descriptive attributes. Because the JA localization is primarily used by Indian and Asia/Pacific regulatory reporting such as the RG (Register) excise, cess, and value-added reporting framework, this view serves as the transactional bridge between the GL journal lines that physically hold the accounting and the RG transfer documents that created them.

The view carries a fixed EVENT_TYPE constant of 'RG FUND TRANSFER' and APPLICATION_ID of 7000, which is the General Ledger application identifier. This confirms its role as a unified, business-friendly projection of GL accounting activity filtered to fund transfers between organizations.

Underlying Base Objects

The documented metadata identifies sixteen referenced base objects. The GL side of the definition joins GL_JE_HEADERS, GL_JE_LINES, GL_JE_CATEGORIES, GL_JE_SOURCES, GL_DAILY_CONVERSION_TYPES, and GL_IMPORT_REFERENCES, supplying ledger, currency, category, source, and line-level accounting attributes. The reference string on GL_IMPORT_REFERENCES.REFERENCE_5 is parsed to classify each line as the excise account, cess account, or short cess account — this is the mechanism that produces the three amount columns.

Organizational context is drawn from HR_OPERATING_UNITS, HR_LOCATIONS, ORG_ORGANIZATION_DEFINITIONS, and the security-aware HR_SECURITY / HR_GENERAL packages, resolving operating unit and from/to organization names and locations. The JA-specific tables — JAI_CMN_RG_TRANSFERS, JAI_CMN_RG_23AC_II_TRXS, JAI_CMN_RG_BALANCES, JAI_CMN_RG_PLA_TRXS, and JAI_CMN_INVENTORY_ORGS — supply the Register transfer header, the RG transaction header key, and inventory organization details.

Key Columns

• EVENT_TYPE, APPLICATION_ID, TRX_CLASS, TRX_CLASS_NAME, TRX_HDR_TABLE, TRX_HDR_ID — AEL host and transaction identity.
• SET_OF_BOOKS_ID, JE_HEADER_ID, JE_LINE_NUM, JE_CATEGORY, USER_JE_CATEGORY_NAME, JE_SOURCE, USER_JE_SOURCE_NAME — GL header and line identity and naming.
• ACCOUNT_ID, ACCOUNT_DESCRIPTION (mapped from GL_JE_LINES.DESCRIPTION), ENTERED_DR/CR, ACCOUNTED_DR/CR, ACCOUNTING_DATE — the accounting line detail. The ACCOUNT_DESCRIPTION column returned by the user's search maps the GL line description rather than the concatenated flexfield description.
• ENTERED_CURRENCY, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_USER_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE — currency conversion metadata.
• OPERATING_UNIT, FROM_ORGANIZATION, FROM_LOCATION, TO_ORGANIZATION, TO_LOCATION, FROM_ORGANIZATION_ID — organizational routing.
• TRANSFER_ID, TRANSFER_DATE, REGISTER_TYPE, TRANSFER_EXCISE_AMOUNT, TRANSFER_CESS_AMOUNT, TRANSFER_SH_CESS_AMOUNT — Register transfer amounts and dates.
• SOURCE_TABLE ('JAI_CMN_RG_TRANSFERS') and GL_TRANSFER_STATUS ('Y') — provenance flags.

Common Use Cases and Queries

Typical usage covers RG fund-transfer reconciliation, excise/cess liability reporting, and AEL-based extract generation. Because ACCOUNT_DESCRIPTION is a requested column, the query below returns the description with the accounting amounts.

• Listing all fund-transfer journal lines with descriptions for a given ledger and period.
• Reconciling GL entries back to the RG transfer header by TRANSFER_ID.
• Isolating excise, cess, and short-cess components by amount column.

SELECT je_header_id, je_line_num, account_id, account_description, entered_dr, entered_cr, accounted_dr, accounted_cr, transfer_id, transfer_excise_amount, transfer_cess_amount FROM apps.jai_rg_fund_trf_ael_v WHERE set_of_books_id = :ledger_id AND accounting_date BETWEEN :start_date AND :end_date AND account_description IS NOT NULL;

Analysts often group by REGISTER_TYPE or FROM_ORGANIZATION/TO_ORGANIZATION to summarise transfers, and join the view back to JAI_CMN_RG_TRANSFERS when document-level attributes not exposed here are required.