Results for “source_id_secondary”

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

Overview

AR_DISTRIBUTIONS_ALL is the core accounting distribution table in the Oracle Receivables (AR) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the subledger accounting records generated for receipts, receipt applications, adjustments, miscellaneous cash receipts, and chargebacks. Every time Receivables creates accounting entries that will ultimately be transferred to the General Ledger, the individual debit and credit lines are persisted in this table. It is owned by the AR schema and holds a status of VALID.

Because the table records the fully exploded accounting lines that flow to GL, it is central to period-end close, subledger reconciliation, revenue reporting, and any reconciliation between Receivables activity and General Ledger balances. Its 45 documented columns capture the entered and accounted currency amounts, the natural account via CODE_COMBINATION_ID, and the polymorphic lineage of each transaction through the SOURCE_ID / SOURCE_TABLE / SOURCE_TYPE construct.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. The heuristic suggests that AR_DISTRIBUTIONS_ALL behaves primarily as a descriptive satellite attached to multiple hubs (receipts, receivable applications, adjustments, and transactions), rather than as a hub itself or a pure link table. Modelers should treat SOURCE_ID and SOURCE_TABLE as the conceptual drivers linking back to the originating business entities.

Key Information Stored

The surrogate primary key documented for the table is AR_DISTRIBUTIONS_PK, composed of SOURCE_ID, SOURCE_TABLE, SOURCE_TYPE. A second unique index, AR_DISTRIBUTIONS_U2, is defined on LINE_ID, making LINE_ID a business-key candidate and the most reliable single-row identifier for referencing an individual distribution.

The most significant columns include:

• SOURCE_ID, SOURCE_TABLE, SOURCE_TYPE — the polymorphic discriminator fields identifying the originating transaction and the parent table that produced the distribution.
• LINE_ID — unique line identifier; the AR_DISTRIBUTIONS_U2 business key and the target of cross-module references.
• CODE_COMBINATION_ID — the GL account flexfield combination the distribution posts to; a foreign key to GL_CODE_COMBINATIONS.
• AMOUNT_DR, AMOUNT_CR — entered-currency debit and credit amounts.
• ACCTD_AMOUNT_DR, ACCTD_AMOUNT_CR — accounted (ledger) currency debit and credit amounts.
• TAXABLE_ENTERED_DR / CR and TAXABLE_ACCOUNTED_DR / CR — taxable portions of the entered and accounted amounts, used for tax reporting.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE — currency and conversion metadata.
• TAX_LINK_ID, TAX_GROUP_CODE_ID, TAX_CODE_ID — tax associations linking distributions to tax lines and tax group codes.
• THIRD_PARTY_ID, THIRD_PARTY_SUB_ID — third-party customer and site references for subledger accounting.
• ORG_ID — operating unit, supporting multi-org reporting.
• REF_DIST_CCID, REF_CUST_TRX_LINE_GL_DIST_ID, REF_CUSTOMER_TRX_LINE_ID, REF_LINE_ID, REF_ACCOUNT_CLASS — reference and reversal lineage fields.
• REVERSED_SOURCE_ID — identifies the distribution this row reverses.

Common Use Cases and Queries

Typical uses include reconciling Receivables to GL for a given period, auditing which account combinations received receipt-related activity, and tracing tax distributions. A representative query locating receipt distributions joined to the account flexfield is:

• SELECT d.line_id, d.source_id, d.source_type, g.segment1 CONCATENATED_ACCOUNT, d.amount_dr, d.amount_cr, d.acctd_amount_dr, d.acctd_amount_cr FROM ar_distributions_all d, gl_code_combinations g WHERE d.code_combination_id = g.code_combination_id AND d.source_table = 'AR_CASH_RECEIPT_HISTORY_ALL'.
• Filtering by REVERSED_SOURCE_ID IS NOT NULL isolates reversal entries for period-close analysis.
• Aggregating ACCTD_AMOUNT_DR and ACCTD_AMOUNT_CR by CODE_COMBINATION_ID produces subledger account activity for GL tie-out.
• Joining on SOURCE_ID to AR_RECEIVABLE_APPLICATIONS_ALL or AR_ADJUSTMENTS_ALL reveals the originating application or adjustment for drill-down reporting.

Related Objects

The table participates in an extensive foreign-key network. The most significant related objects and join columns are:

• AR_CASH_RECEIPT_HISTORY_ALL — referenced via SOURCE_ID for receipt accounting activity.
• AR_RECEIVABLE_APPLICATIONS_ALL — referenced via SOURCE_ID for application distributions.
• AR_ADJUSTMENTS_ALL — referenced via SOURCE_ID for adjustment distributions.
• AR_MISC_CASH_DISTRIBUTIONS_ALL — referenced via SOURCE_ID for miscellaneous cash receipts.
• AR_TRANSACTION_HISTORY_ALL — referenced via SOURCE_ID for transaction history events.
• GL_CODE_COMBINATIONS — referenced via CODE_COMBINATION_ID and REF_DIST_CCID, supplying the account flexfield.
• AR_TAX_GROUP_CODES_ALL — referenced via TAX_GROUP_CODE_ID.
• RA_CUSTOMER_TRX_LINES_ALL — referenced via TAX_LINK_ID and REF_CUSTOMER_TRX_LINE_ID.
• RA_CUST_TRX_LINE_GL_DIST_ALL — referenced via REF_CUST_TRX_LINE_GL_DIST_ID.
• HZ_CUST_ACCOUNTS / HZ_CUST_SITE_USES_ALL — referenced via THIRD_PARTY_ID and THIRD_PARTY_SUB_ID.
• AR_MC_DISTRIBUTIONS_ALL — a dependent table referencing AR_DISTRIBUTIONS_ALL.LINE_ID, holding multi-currency mirror distributions.

Together these relationships make AR_DISTRIBUTIONS_ALL the definitive subledger record set linking Receivables transactions to General Ledger accounting.