Search Results ar_mc_cash_basis_dists_all




Overview
Explore in AI Chat

Overview

The AR_MC_CASH_BASIS_DISTS_ALL table is a core data structure within Oracle E-Business Suite Receivables (AR) that supports Multi-Currency (MRC) Cash Basis Accounting. Its primary role is to store the detailed accounting distributions for payments when an organization uses the cash basis accounting method, as opposed to the standard accrual basis. This table holds the currency-converted distribution amounts that are posted to specific revenue general ledger (GL) accounts. It is a critical component for ensuring accurate financial reporting in multi-ledger environments, as it maintains a separate record of distributions for each set of books (ledger) to which a transaction pertains, enabling compliance with different accounting standards per ledger.

Key Information Stored

The table's primary key is the combination of CASH_BASIS_DISTRIBUTION_ID and SET_OF_BOOKS_ID, which uniquely identifies a distribution record for a specific ledger. Key columns include CASH_BASIS_DISTRIBUTION_ID, which links to the base currency distribution in AR_CASH_BASIS_DISTS_ALL, and SET_OF_BOOKS_ID, which identifies the ledger. The CODE_COMBINATION_ID stores the GL account to which the revenue is posted. Currency and amount information is captured in CURRENCY_CODE (the transaction currency) and ACCTD_AMOUNT (the amount converted to the ledger's functional currency). Critical foreign key columns like PAYMENT_SCHEDULE_ID, RECEIVABLE_APPLICATION_ID, and POSTING_CONTROL_ID link the distribution to the underlying invoice, payment application, and posting batch control, respectively, creating a complete audit trail.

Common Use Cases and Queries

The primary use case is generating and auditing GL entries for cash-basis revenue recognition. When a payment is applied to an invoice in a cash-basis ledger, the system creates records in this table. Common queries involve tracing the revenue posted for a specific payment or invoice across ledgers. For example, to see all cash-basis distributions for a specific payment schedule in a given ledger, a query would join to AR_PAYMENT_SCHEDULES_ALL and GL_CODE_COMBINATIONS. Reporting use cases include reconciliation reports between Receivables transactions and GL journal entries for cash-basis ledgers, and analyzing revenue recognized by GL account and period. Data from this table is typically sourced for subledger accounting events to create the final accounting entries.

Related Objects

This table sits at the intersection of transactional, accounting, and multi-currency data. Its documented foreign key relationships are fundamental for joins in queries and reports:

  • AR_CASH_BASIS_DISTS_ALL: Linked via CASH_BASIS_DISTRIBUTION_ID. This is the base currency source table.
  • GL_SETS_OF_BOOKS: Linked via SET_OF_BOOKS_ID. Identifies the specific ledger.
  • AR_PAYMENT_SCHEDULES_ALL: Linked via PAYMENT_SCHEDULE_ID. Provides the invoice or charge being paid.
  • GL_CODE_COMBINATIONS: Linked via CODE_COMBINATION_ID. Provides the revenue GL account.
  • FND_CURRENCIES: Linked via CURRENCY_CODE. Defines the transaction currency.
  • AR_RECEIVABLE_APPLICATIONS_ALL: Linked via RECEIVABLE_APPLICATION_ID and RECEIVABLE_APPLICATION_ID_CASH. Ties the distribution to the specific application of a payment (receivable) or cash (cash receipt).
  • AR_POSTING_CONTROL: Linked via POSTING_CONTROL_ID. Associates the distribution with a posting batch for transfer to GL.