Search Results match_tax_id

Overview

The JAI_BOE_MATCHING_TAXES table is a core transactional data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves a critical function in the localized financial processes for supported countries, specifically in the matching of Bank Order of Exchange (BOE) transactions with receipts. As indicated by its description, this table stores the detailed tax information associated with each BOE-to-receipt matching event. Its existence ensures that tax implications are accurately recorded and traceable when a BOE, a common instrument for international trade settlements, is reconciled with an incoming payment, thereby supporting compliant financial reporting and reconciliation.

Key Information Stored

The table's primary purpose is to hold tax line details for a BOE matching. The documented primary key is MATCH_TAX_ID, a unique identifier for each tax record. The most significant foreign key is MATCH_ID, which links each tax line to its parent BOE matching header record in the JAI_CMN_BOE_MATCHINGS table. While the full column list is not provided in the excerpt, a table of this nature in a tax context would typically store details such as the tax code or rate applied, the taxable amount, the calculated tax amount, the tax authority, and potentially indicators for recoverable or non-recoverable tax. This structure allows multiple tax components (e.g., Central Tax, State Tax) to be accurately recorded for a single BOE matching transaction.

Common Use Cases and Queries

This table is primarily accessed for generating detailed audit reports on the tax components of settled BOE transactions and for troubleshooting reconciliation issues. A common operational use case is verifying the tax breakdown of a matched BOE for accounting entries or customer communication. A typical query would join this table to its parent to retrieve a comprehensive view.

• Sample Query to Retrieve Tax Details for a Match:
  SELECT jbmt.match_tax_id, jbmt.tax_amount, jbmt.tax_code, jcbm.boe_number
FROM jai_boe_matching_taxes jbmt,
jai_cmn_boe_matchings jcbm
WHERE jbmt.match_id = jcbm.match_id
AND jcbm.boe_number = 'BOE123456';
• Reporting Use Case: Creating a report summarizing total tax amounts by tax type for all BOEs matched within a specific period, which is essential for period-end tax accruals and filings.

Related Objects

The JAI_BOE_MATCHING_TAXES table has a defined dependency within the JA localization schema. The documented foreign key relationship is fundamental to its operation.

• JAI_CMN_BOE_MATCHINGS: This is the primary parent table. The relationship is maintained through the foreign key column JAI_BOE_MATCHING_TAXES.MATCH_ID, which references a primary key in JAI_CMN_BOE_MATCHINGS. This link ensures every tax detail record is associated with a valid BOE matching header, enforcing data integrity. Queries will almost always involve joining these two tables to get a complete transaction view.