Search Results ar_mc_cash_receipts




Overview
Explore in AI Chat

Overview

AR_MC_CASH_RECEIPTS is a Receivables (AR) module table in the Oracle E-Business Suite schema AR. It stores currency-related information about receipts for each reporting set of books. The "MC" prefix denotes a Multiple Reporting Currencies (MRC) context, so this table is populated only when the Multiple Reporting Currencies feature is enabled, maintaining a translated or converted view of receipt currency attributes for each reporting set of books associated with a primary set of books.

In the documented physical schema for ETRM 12.2.2, AR_MC_CASH_RECEIPTS is owned by AR and consists of five columns. The primary key is defined by AR_MC_CASH_RECEIPTS_PK, on the combination of CASH_RECEIPT_ID and SET_OF_BOOKS_ID, and a unique index, AR_MC_CASH_RECEIPTS_U1, mirrors that same pair of columns. This confirms the table is a join entity. Under the heuristic Data Vault classification derived from the foreign-key structure, the table is modeled as a link: it resolves a many-to-many relationship between receipts and sets of books and carries descriptive exchange-rate attributes as link-level payload, rather than functioning as an independent hub or a standalone satellite.

Key Information Stored

All five documented columns are significant to the table's purpose. The composite key columns and the currency attributes they anchor are as follows:

  • CASH_RECEIPT_ID — Identifier of the receipt, shared with AR_CASH_RECEIPTS_ALL. This is the principal member of the AR_MC_CASH_RECEIPTS_PK primary key and of the unique index AR_MC_CASH_RECEIPTS_U1.
  • SET_OF_BOOKS_ID — Identifier of the reporting set of books for which the currency information applies. This is the second member of both AR_MC_CASH_RECEIPTS_PK and AR_MC_CASH_RECEIPTS_U1, and the column that makes the table MRC-specific.
  • EXCHANGE_RATE_TYPE — The rate type (for example, a corporate or spot rate) applied when converting the receipt amount into the reporting currency.
  • EXCHANGE_RATE — The conversion rate used for the receipt in the reporting set of books.
  • EXCHANGE_DATE — The effective date associated with the conversion rate.

The primary key is composite rather than surrogate, so no system-generated single-column surrogate key is documented. Because AR_MC_CASH_RECEIPTS_PK and AR_MC_CASH_RECEIPTS_U1 cover the identical column pair, the business key is the combination of CASH_RECEIPT_ID and SET_OF_BOOKS_ID, guaranteeing that each receipt has at most one currency record per set of books. The remaining three columns supply the exchange-rate payload.

Common Use Cases and Queries

Typical usage centers on reconciling foreign-currency receipts against their reporting set of books and validating that converted receipt amounts tie to the general ledger. A common query joins the MRC currency rows to the primary receipt and to the set-of-books definition:

  • Reporting exchange-rate detail for a given receipt: select CASH_RECEIPT_ID, EXCHANGE_RATE_TYPE, EXCHANGE_RATE, EXCHANGE_DATE from AR_MC_CASH_RECEIPTS where CASH_RECEIPT_ID = :receipt_id.
  • Auditing rate usage across books: select SET_OF_BOOKS_ID, EXCHANGE_RATE_TYPE, count(*) from AR_MC_CASH_RECEIPTS group by SET_OF_BOOKS_ID, EXCHANGE_RATE_TYPE to review rate types applied per reporting set of books.
  • Reconciling MRC to primary receipts: join AR_MC_CASH_RECEIPTS.CASH_RECEIPT_ID to AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID to compare primary and reporting-currency receipt values.
  • Resolving reporting books: join AR_MC_CASH_RECEIPTS.SET_OF_BOOKS_ID to GL_SETS_OF_BOOKS to report the set-of-books name and currency.

Because only the primary-key columns and exchange-rate attributes are stored, all amount and customer detail must be obtained from AR_CASH_RECEIPTS_ALL through the CASH_RECEIPT_ID join.

Related Objects

The following objects are most significant in relation to AR_MC_CASH_RECEIPTS, based on the documented foreign-key and primary-key relationships:

  • AR_CASH_RECEIPTS_ALL — Referenced by AR_MC_CASH_RECEIPTS.CASH_RECEIPT_ID; supplies the primary receipt record the MRC currency rows describe.
  • GL_SETS_OF_BOOKS — Referenced by AR_MC_CASH_RECEIPTS.SET_OF_BOOKS_ID; identifies the reporting set of books.
  • AR_MC_CASH_RECEIPT_AMOUNTS — The companion MRC table holding converted receipt amounts for the same set of books.
  • AR_MC_CASH_RECEIPT_HISTORY — The MRC history counterpart for receipt lifecycle records.
  • AR_CASH_RECEIPT_HISTORY_ALL — Holds the corresponding primary-set-of-books history rows.

To the extent that MRC processing and reports read these tables, the standard Receivables receipt APIs and concurrent programs that populate the MRC schema also depend on this object. In all cases, the join key remains the pair (CASH_RECEIPT_ID, SET_OF_BOOKS_ID).