Results for “interest_writeoff_rectrx_id”

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

Overview

JL_BR_AR_REC_MET_ACCTS_EXT_ALL is a Latin America Localizations (JL) table that stores the extended accounting and operational setup for Receipt Methods used in Brazilian Receivables processing. In Oracle E-Business Suite 12.1.1 and 12.2.2, it acts as the localization-specific counterpart to the standard AR_RECEIPT_METHOD_ACCOUNTS_ALL table, layering Brazil-specific attributes on top of standard receipt method configuration. The table carries 51 columns and is documented in ETRM with the description "Receipt Method accounts."

The primary key is JL_BR_AR_REC_MET_ACC_EXT_PK, defined over the composite of BANK_ACCT_USE_ID and RECEIPT_METHOD_ID. This composite structure means the row is keyed by the combination of a bank account usage and a receipt method, not by a single surrogate identifier. A unique index, JL_BR_AR_REC_MET_ACC_EXT_U1, enforces the same business-key candidate pair, confirming that the natural key is (bank account usage, receipt method). Under a heuristic Data Vault classification drawn from the foreign key topology, the table leans toward a satellite — its columns are largely descriptive and configurational attributes attached to the bank-account-use/receipt-method relationship rather than an independent business entity.

Key Information Stored

The most significant columns fall into several functional groups:

• Key columns: BANK_ACCT_USE_ID (FK to CE_BANK_ACCT_USES_ALL) and RECEIPT_METHOD_ID form the composite primary key. BANK_ACCOUNT_ID references AR_RECEIPT_METHOD_ACCOUNTS_ALL, and ORG_ID supports multi-org partitioning.
• Accounting flexfield references: Multiple CCID columns point to GL_CODE_COMBINATIONS, including BANK_CHARGES_CCID, COLL_ENDORSEMENT_CCID, INTEREST_REVENUE_CCID, CALCULATED_INTEREST_CCID, INTEREST_WRITEOFF_CCID, ABATEMENT_WRITEOFF_CCID, ABATEMENT_REVENUE_CCID, OTHER_CREDITS_CCID, FACTORING_DOCS_CCID, BILLS_COLLECTION_CCID, DISC_ENDORSEMENT_CCID, BILLS_DISCOUNT_CCID, FACTORING_CHARGES_CCID, and DISCOUNTED_BILLS_CCID.
• Receivables transaction references: CALCULATED_INTEREST_RECTRX_ID, INTEREST_WRITEOFF_RECTRX_ID, INTEREST_REVENUE_RECTRX_ID, ABATEMENT_WRITEOFF_RECTRX_ID, and ABATEMENT_REVENUE_RECTRX_ID, each pointing to AR_RECEIVABLES_TRX_ALL.
• Operational and tolerance attributes: PORTFOLIO_CODE, MIN_DOCUMENT_AMOUNT, MAX_DOCUMENT_AMOUNT, MIN_REMITTANCE_AMOUNT, MAX_REMITTANCE_AMOUNT, WRITEOFF_PERC_TOLERANCE, WRITEOFF_AMOUNT_TOLERANCE, FACTORING_RATE, and FACTORING_RATE_PERIOD.
• Banking/file format attributes: BANK_INSTRUCTION_CODE1, BANK_INSTRUCTION_CODE2, BANK_CHARGE_AMOUNT, COLL_REMITTANCE_MEDIA, FACTOR_REMITTANCE_MEDIA, MAX_COLLECTION_DOCS, and format program references (COLL_FORMAT_PGM_ID, FACTOR_FORMAT_PGM_ID, OCC_REP_FORMAT_PGM_ID, OCC_FILE_FORMAT_PGM_ID) to AP_PAYMENT_PROGRAMS.
• Batch and audit columns: BATCH_SOURCE_ID, GL_DATE_BANK_RETURN, FLOATING, and the standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

This table is queried primarily to retrieve Brazil-specific receipt method accounting and operational defaults during receipt entry, bank collection file generation, and interest/abatement processing. A typical lookup joins the localizations table to the standard receipt method accounts table on BANK_ACCOUNT_ID and RECEIPT_METHOD_ID:

• Resolve the GL accounts applied when a receipt is processed against a given bank account and receipt method.
• Retrieve the receivables transaction types used for calculated interest, interest write-off, and abatement postings.
• Determine tolerance thresholds (WRITEOFF_PERC_TOLERANCE, WRITEOFF_AMOUNT_TOLERANCE) and min/max document or remittance amounts for validation.
• Identify the remittance medium and format program used for collection, factoring, and OCC file generation.

A representative pattern joins GL_CODE_COMBINATIONS on the CCID columns to translate accounting flexfields into readable segment values for reconciliation reporting. Reports typically filter by ORG_ID to respect operating unit security.

Related Objects

• AR_RECEIPT_METHOD_ACCOUNTS_ALL — standard receipt method accounts; joined via BANK_ACCOUNT_ID and RECEIPT_METHOD_ID.
• CE_BANK_ACCT_USES_ALL — source of the BANK_ACCT_USE_ID component of the primary key.
• GL_CODE_COMBINATIONS — parent of all CCID accounting references in this table.
• AR_RECEIVABLES_TRX_ALL — parent of the five receivables transaction type references (interest and abatement).
• AR_BATCH_SOURCES_ALL — joined via BATCH_SOURCE_ID.
• AP_PAYMENT_PROGRAMS — parent of the collection and factoring format program references.
• JL_BR_AR_PAY_SCHED_AUX — child table referencing this object via BANK_ACCOUNT_ID.