Search Results ap_payment_distributions_all




Overview
Explore in AI Chat

Overview

The AP_PAYMENT_DISTRIBUTIONS_ALL table is a core data object within the Oracle E-Business Suite Payables module (AP). It serves as the central repository for detailed accounting information related to payments made to suppliers. Each record in this table represents the accounting distribution for a specific payment line, linking the cash outflow to the corresponding liability account that was settled. Its primary role is to maintain the detailed accounting entries (debits and credits) generated during the payment process, ensuring accurate financial posting to the General Ledger. The table supports multi-organization architectures, as indicated by the '_ALL' suffix, meaning it stores data across all operating units accessible to a user.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which dictate the critical data it holds. The primary key is a composite of INVOICE_PAYMENT_ID and PAYMENT_LINE_NUMBER, uniquely identifying each payment distribution line. Essential columns include INVOICE_PAYMENT_ID, which links to the AP_INVOICE_PAYMENTS_ALL table to identify the parent payment transaction. The DIST_CODE_COMBINATION_ID column stores the identifier for the General Ledger account (typically the Accounts Payable liability account) that is being credited. Conversely, the ACCTS_PAY_CODE_COMBINATION_ID column stores the identifier for the cash or bank account that is being debited. Additional columns typically track the distribution amount, type, and associated invoice distribution details, forming a complete audit trail for the payment's accounting impact.

Common Use Cases and Queries

This table is fundamental for payment reconciliation, audit inquiries, and custom financial reporting. A common use case is tracing the exact General Ledger accounts impacted by a specific payment or batch of payments. Analysts often query this table to verify that payments were correctly accounted for before journal import to the GL. A typical query joins to AP_INVOICE_PAYMENTS_ALL and AP_CHECKS_ALL to retrieve payment details, and to GL_CODE_COMBINATIONS to get the actual account segments for reporting.

  • Sample Query Pattern: SELECT apd.payment_line_number, apd.amount, gcc_dist.concatenated_segments liability_account, gcc_cash.concatenated_segments cash_account FROM ap_payment_distributions_all apd JOIN gl_code_combinations gcc_dist ON apd.dist_code_combination_id = gcc_dist.code_combination_id JOIN gl_code_combinations gcc_cash ON apd.accts_pay_code_combination_id = gcc_cash.code_combination_id WHERE apd.invoice_payment_id = :p_inv_pay_id;

Related Objects

The AP_PAYMENT_DISTRIBUTIONS_ALL table is integral to the Payables accounting schema, with defined relationships to several key tables. As per the provided metadata, its primary foreign key relationships are:

  • AP_INVOICE_PAYMENTS_ALL: Linked via the INVOICE_PAYMENT_ID column. This is the direct parent table, containing the header-level information for the invoice payment.
  • GL_CODE_COMBINATIONS (for DIST_CODE_COMBINATION_ID): This relationship provides the General Ledger liability account (e.g., Accounts Payable) that is credited by the payment distribution.
  • GL_CODE_COMBINATIONS (for ACCTS_PAY_CODE_COMBINATION_ID): This relationship provides the General Ledger asset account (e.g., Cash, Bank) that is debited by the payment distribution.

These relationships ensure referential integrity and form the basis for all payment accounting within Oracle Payables.