Results for “max_document_amount”

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

Overview

The table JL.JL_BR_AR_SELECT_ACCOUNTS_ALL is an Oracle E-Business Suite 12.1.1 / 12.2.2 localization table belonging to the JL – Latin America Localizations product family, specifically the Brazilian receivables (JL_BR) localization. It stores the bank account distribution criteria used to determine how receipt amounts are allocated to bank accounts when Bank Transfer batches are processed. Each row defines a selection rule that binds a selection control, a batch source, a portfolio, and one or more bank account identifiers to a set of monetary thresholds and percentage distribution values, so that the Brazilian Localization engine can route collections to the correct depository account.

From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification. The table carries descriptive selection criteria (dates, monetary limits, percentage distribution) and depends on a controlling parent (JL_BR_AR_SELECT_CONTROLS_ALL), positioning it as an attribute-bearing child rather than a pure hub. It also behaves as a link, resolving references across AP_BANK_ACCOUNTS_ALL, CE_BANK_ACCT_USES_ALL, and AR_BATCH_SOURCES_ALL.

Key Information Stored

The primary key is the surrogate column SELECT_ACCOUNT_ID, enforced by JL_BR_AR_SELECT_ACCOUNTS_PK and mirrored by the unique index JL_BR_AR_SELECT_ACCOUNTS_U1. The most significant business columns are:

• SELECTION_CONTROL_ID – links each distribution rule back to the parent selection control that governs the batch.
• BANK_ACCOUNT_ID – the AP bank account receiving the allocated funds.
• BANK_ACCT_USE_ID – the CE bank account use, providing operating-unit scoped account context.
• BATCH_SOURCE_ID – the AR batch source the rule applies to.
• ORG_ID – the multi-org operating unit discriminator.
• PORTFOLIO_CODE – identifies the receivables portfolio covered by the rule.
• MIN_DOCUMENT_AMOUNT / MAX_DOCUMENT_AMOUNT – document-level value bounds for inclusion.
• MIN_REMITTANCE_AMOUNT / MAX_REMITTANCE_AMOUNT – remittance-level value bounds.
• PERCENTAGE_DISTRIBUTION – the fractional share of the collection allocated to the account.
• GL_DATE, SELECTION_DATE, REMITTANCE_DATE, FORMAT_DATE, CANCELLATION_DATE – lifecycle timestamps for the selection.
• BANK_INSTRUCTION_CODE1 / BANK_INSTRUCTION_CODE2 and BANK_CHARGE_AMOUNT – Brazilian banking instruction and fee attributes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 – DFF extensibility.
• LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY – standard audit columns.

Common Use Cases and Queries

Because the requested search term was ap_bank_accounts_all, the most frequent access pattern joins this table to the AP bank account definition to resolve the account name and number associated with a distribution rule.

• Listing distribution rules per selection control:
  SELECT select_account_id, bank_account_id, percentage_distribution FROM jl_br_ar_select_accounts_all WHERE selection_control_id = :id;
• Resolving bank account details via the documented FK:
  SELECT s.select_account_id, a.bank_account_name, a.bank_account_num FROM jl_br_ar_select_accounts_all s, ap_bank_accounts_all a WHERE s.bank_account_id = a.bank_account_id;
• Value-band auditing using MIN_/MAX_DOCUMENT_AMOUNT and MIN_/MAX_REMITTANCE_AMOUNT to confirm that no overlapping ranges exist for a given BATCH_SOURCE_ID and ORG_ID.
• Reconciling distributed versus retained amounts by summing PERCENTAGE_DISTRIBUTION per SELECTION_CONTROL_ID and verifying the total equals 100.
• Operational reporting on GL_DATE and REMITTANCE_DATE windows to track which accounts received transfers during a period.

Related Objects

• JL_BR_AR_SELECT_CONTROLS_ALL – parent table joined on SELECTION_CONTROL_ID; defines the overall selection control.
• AP_BANK_ACCOUNTS_ALL – joined on BANK_ACCOUNT_ID; supplies bank account name and number.
• CE_BANK_ACCT_USES_ALL – joined on BANK_ACCT_USE_ID; provides operating-unit account usage context.
• AR_BATCH_SOURCES_ALL – joined on BATCH_SOURCE_ID; identifies the associated receivables batch source.
• JL_BR_AR_BORDEROS_ALL – child table referencing this table via SELECT_ACCOUNT_ID.
• JL_BR_AR_PAY_SCHED_AUX – auxiliary payment schedule table referencing SELECT_ACCOUNT_ID.

These relationships make JL_BR_AR_SELECT_ACCOUNTS_ALL the central distribution-criteria table within Brazilian bank transfer batch processing.