Results for “old_threshold_slab_id”

14 results




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

Overview

The JAI_AP_TDS_THGRP_AUDITS table is a repository object owned by the JA schema within the Asia/Pacific Localizations product family of Oracle E-Business Suite. Its documented purpose is to track the changes that occur against the JAI_AP_TDS_THHOLD_GRPS table, which governs Tax Deducted at Source (TDS) threshold grouping for withholding tax processing in the payables cycle. Each row records a discrete threshold-group mutation event, capturing the state of tax and amount attributes before, during, and after the change, together with the responsible user and timestamp information.

Under the heuristic Data Vault classification supplied in the metadata, this object is modeled as a link. That classification is consistent with its construction: the table is built around a surrogate key and a set of foreign-key relationships that connect threshold groups, withholding slabs, invoice headers, and invoice distributions. It functions as an associative audit record rather than as an independent business entity or a purely descriptive satellite, since it carries references to multiple hubs alongside its change-history payload.

Key Information Stored

The table contains 37 documented columns. The most operationally significant are grouped below, with the surrogate primary key distinguished from the business-key candidate.

Common Use Cases and Queries

The table supports TDS reconciliation, withholding threshold audit reporting, and dispute investigation. A typical retrieval of the change history for a single invoice joins the audit rows to the invoice header:

  • SELECT a.threshold_grp_audit_id, a.tds_event, a.old_tax_paid, a.new_tax_paid, a.remarks FROM jai_ap_tds_thgrp_audits a WHERE a.invoice_id = :p_invoice_id ORDER BY a.creation_date;
  • Reconciling stored against calculated tax values: compare OLD_TAX_PAID with CALC_OLD_TAX_PAID, TRX_TAX_PAID with CALC_TRX_TAX_PAID, and NEW_TAX_PAID with CALC_NEW_TAX_PAID to detect inconsistencies introduced by slab transitions.
  • Slab migration analysis: join OLD_THRESHOLD_SLAB_ID, TRX_THRESHOLD_SLAB_ID, and NEW_THRESHOLD_SLAB_ID to JAI_AP_TDS_THHOLD_SLABS to report how invoices moved between withholding slabs during a reporting period.
  • Threshold-group activity reporting: aggregate by THRESHOLD_GRP_ID and TDS_EVENT to quantify how frequently a given group mutates, and by CREATED_BY for user-level review of manual adjustments.

Related Objects

  • JAI_AP_TDS_THHOLD_GRPS — the parent table audited by this object; joined on THRESHOLD_GRP_ID.
  • JAI_AP_TDS_THHOLD_SLABS — referenced three times via OLD_THRESHOLD_SLAB_ID, TRX_THRESHOLD_SLAB_ID, and NEW_THRESHOLD_SLAB_ID.
  • AP_INVOICES_ALL — invoice header referenced by INVOICE_ID, supplying supplier, invoice number, and currency context.
  • AP_INVOICE_DISTRIBUTIONS_ALL — logically related through INVOICE_DISTRIBUTION_ID for line-level reconciliation.
  • JAI_AP_TDS_THGRP_AUDITS_PK — the unique index enforcing the surrogate primary key on THRESHOLD_GRP_AUDIT_ID.