Results for “system_invoice_no”

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

Overview

JAI_RGM_SETTLEMENTS is a transactional table owned by the JA schema within the Oracle E-Business Suite Asia/Pacific Localizations module. It stores settlement information organized by tax regime, serving as the central repository for recording the periodic remittance and reconciliation of taxes to government authorities. In the context of the ETRM localization framework, this table captures the lifecycle of a tax settlement — from invoice generation through payment and balance reconciliation — against the regime that governs the applicable fiscal rules.

Based on the mined foreign key structure, the metadata suggests a hub-leaning Data Vault classification. JAI_RGM_SETTLEMENTS is referenced by five downstream tables (JAI_AP_RGM_PAYMENTS, JAI_RGM_DIS_SRC_HDRS, JAI_RGM_REFS_ALL, JAI_RGM_STL_BALANCES, and JAI_RGM_TRX_RECORDS) through the SETTLEMENT_ID column, while itself referencing four upstream objects. This pattern indicates the table behaves as a business hub keyed on SETTLEMENT_ID, with satellites and links extending it for payments, balances, and transaction records.

Key Information Stored

The surrogate primary key is SETTLEMENT_ID, defined by the unique index JAI_RGM_SETTLEMENTS_PK, which is the sole documented business-key candidate. The 24 documented columns capture the operational and financial attributes of each settlement. The most significant columns are:

• SETTLEMENT_ID – Surrogate primary key uniquely identifying each settlement record.
• REGIME_ID – Foreign key to JAI_RGM_DEFINITIONS, identifying the tax regime under which the settlement is filed.
• PRIMARY_REGISTRATION_NO – Taxpayer registration number associated with the settlement.
• SETTLEMENT_DATE and LAST_SETTLEMENT_DATE – Dates the settlement was made and last updated.
• STATUS – Lifecycle state of the settlement (for example, open, paid, reversed).
• SYSTEM_INVOICE_NO and MANUAL_INVOICE_NO – Invoice identifiers, system-generated versus manually entered.
• TAX_AUTHORITY_ID and TAX_AUTHORITY_SITE_ID – References to HZ_PARTIES and HZ_PARTY_SITES identifying the government authority and site.
• CALCULATED_AMOUNT and PAYMENT_AMOUNT – Tax amounts computed versus actually paid.
• CHALLAN_NO and CHALLAN_DATE – Government challan reference and date of remittance.
• INVOICE_ID – Foreign key to AP_INVOICES_ALL linking the settlement to its payable invoice.
• REVERSE_CHARGE_FLAG and ITEM_CLASSIFICATION – Flags and classification controlling reverse-charge treatment.
• OBJECT_VERSION_NUMBER – Optimistic locking column for concurrent updates.

Common Use Cases and Queries

Typical reporting scenarios include tracking outstanding tax liabilities by regime, reconciling calculated versus paid amounts, and auditing settlement history for a tax authority. A representative query joining settlement data to the regime definition and tax authority follows:

• SELECT s.SETTLEMENT_ID, s.SETTLEMENT_DATE, s.CHALLAN_NO, s.CALCULATED_AMOUNT, s.PAYMENT_AMOUNT, d.REGIME_NAME, s.STATUS FROM JA.JAI_RGM_SETTLEMENTS s, JA.JAI_RGM_DEFINITIONS d, HZ_PARTIES p WHERE s.REGIME_ID = d.REGIME_ID AND s.TAX_AUTHORITY_ID = p.PARTY_ID AND s.STATUS = 'OPEN';
• Balance reconciliation joins JAI_RGM_STL_BALANCES on SETTLEMENT_ID to compare settled amounts against maintained balances.
• Payment reconciliation joins JAI_AP_RGM_PAYMENTS on SETTLEMENT_ID to verify settlement against actual disbursements.
• Aging reports filter on SETTLEMENT_DATE and CHALLAN_DATE to identify overdue remittances.

Related Objects

The following objects are the most significant dependencies, based on documented foreign key relationships:

• JAI_RGM_DEFINITIONS – Parent regime definition; joined on JAI_RGM_SETTLEMENTS.REGIME_ID.
• HZ_PARTIES – Tax authority party; joined on TAX_AUTHORITY_ID.
• HZ_PARTY_SITES – Tax authority site; joined on TAX_AUTHORITY_SITE_ID.
• AP_INVOICES_ALL – Payables invoice; joined on INVOICE_ID.
• JAI_AP_RGM_PAYMENTS – Settlement payments; references SETTLEMENT_ID.
• JAI_RGM_STL_BALANCES – Settlement balance records; references SETTLEMENT_ID.
• JAI_RGM_TRX_RECORDS – Transaction records; references SETTLEMENT_ID.
• JAI_RGM_REFS_ALL and JAI_RGM_DIS_SRC_HDRS – Reference and distribution source headers; both reference SETTLEMENT_ID.