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.
- THRESHOLD_GRP_AUDIT_ID — surrogate primary key, enforced by the unique index JAI_AP_TDS_THGRP_AUDITS_PK. This is the only documented unique index; no separate composite business-key candidate is defined in the metadata.
- THRESHOLD_GRP_ID — foreign key to JAI_AP_TDS_THHOLD_GRPS; identifies which threshold group was modified.
- INVOICE_ID — foreign key to AP_INVOICES_ALL; the invoice whose processing triggered the group change.
- INVOICE_DISTRIBUTION_ID and INVOICE_LINE_NUMBER — pinpoint the distribution and line context of the change.
- OLD_THRESHOLD_SLAB_ID, TRX_THRESHOLD_SLAB_ID, and NEW_THRESHOLD_SLAB_ID — three foreign keys to JAI_AP_TDS_THHOLD_SLABS capturing the prior, transaction-time, and resulting slab.
- OLD_TAX_PAID, TRX_TAX_PAID, and NEW_TAX_PAID — the tax amounts across the same three states.
- OLD_INVOICE_AMOUNT, TRX_INVOICE_AMOUNT, and NEW_INVOICE_AMOUNT — the corresponding invoice amount states.
- OLD_THHOLD_CHANGE_TAX_PAID, TRX_THHOLD_CHANGE_TAX_PAID, and NEW_THHOLD_CHANGE_TAX_PAID — tax adjustments attributable to the threshold change itself.
- TDS_EVENT — the event type that produced the audit row.
- CALC_OLD_TAX_PAID, CALC_TRX_TAX_PAID, and CALC_NEW_TAX_PAID — system-calculated comparators for reconciliation against stored amounts.
- REMARKS — free-text annotation supplied with the change.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and OBJECT_VERSION_NUMBER — standard auditing and optimistic-locking columns.
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.
-
This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS.
-
This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS.
-
eTRM - JA Tables and Views 12.1.1
The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table.
-
eTRM - JA Tables and Views 12.2.2
The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.