Search Results jai_ar_trx_cm_t




Overview
Explore in AI Chat

Overview

The JAI_AR_TRX_CM_T table is a core data repository within the Oracle E-Business Suite (EBS) Asia/Pacific Localizations module (product JA). Its primary function is to store detailed information related to statutory (ST) forms for Accounts Receivable (AR) credit memo transactions. This table acts as a critical junction, linking credit memo transaction lines back to their original invoice lines and to the overarching statutory form headers. Its existence is essential for compliance with regional tax and commercial documentation requirements, particularly in jurisdictions like India where statutory forms are mandated for inter-state movement of goods and related tax credit claims. The table is valid and operational in both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships explicitly define its core data structure. The table stores key identifiers that establish crucial links. The columns INV_TRX_ID and INV_TRX_LINE_ID hold references to the original invoice transaction and its specific line in the standard AR transaction tables (RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL). Conversely, the columns CM_TRX_ID and CM_TRX_LINE_ID store references to the corresponding credit memo transaction and line created against that invoice. Furthermore, the OE_ST_ID column links the record to a statutory form header in the JAI_CMN_STFORM_HDRS_ALL table, thereby associating the credit memo adjustment with the correct compliance document.

Common Use Cases and Queries

This table is primarily accessed for statutory reporting, audit trails, and reconciliation processes. A common operational use case is tracing which original invoice lines and associated statutory forms have been adjusted by a specific credit memo, or vice-versa. For reporting, it enables the generation of compliance documents detailing credit memos issued against invoices covered by statutory forms. A typical analytical query would join this table to both the invoice and credit memo transaction lines to assess volume and value of adjustments.

  • Linking Credit Memos to Original Invoices:
    SELECT cmt.*, inv_trx.trx_number original_inv, cm_trx.trx_number credit_memo
    FROM ja.jai_ar_trx_cm_t cmt,
    ar.ra_customer_trx_all inv_trx,
    ar.ra_customer_trx_all cm_trx
    WHERE cmt.inv_trx_id = inv_trx.customer_trx_id
    AND cmt.cm_trx_id = cm_trx.customer_trx_id;
  • Identifying Credit Memos for a Specific Statutory Form:
    SELECT * FROM ja.jai_ar_trx_cm_t WHERE oe_st_id = <form_header_id>;

Related Objects

JAI_AR_TRX_CM_T is centrally connected to several key EBS objects, as defined by its foreign keys. Its most direct relationships are with the standard AR transaction tables: RA_CUSTOMER_TRX_ALL (for both invoice and credit memo headers) and RA_CUSTOMER_TRX_LINES_ALL (for the corresponding line details). It is also a dependent child table of the statutory forms master, JAI_CMN_STFORM_HDRS_ALL. Any custom reports, interfaces, or extensions that need to analyze or process the linkage between credit memos, original invoices, and statutory forms will directly reference or join to this table. It is part of the underlying data model supporting the JA localization's form printing and tax credit reconciliation functionalities.