Search Results check_currency_code

Overview

The APPS.POS_AP_INVOICE_PAYMENTS_V view is a Purchasing (PO) module reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated, denormalized picture of accounts payable invoice payments by joining payment records to their corresponding invoices and payment documents (checks). Its primary purpose is to expose the linkage between an AP invoice, the payment that settled it, and the disbursement instrument, so that Purchasing-side reporting, reconciliation, and integration routines can resolve invoice-to-payment relationships without directly navigating the underlying transactional tables.

The view carries a VALID status in the APPS schema. Because it joins three high-volume AP tables, it is best treated as a read-only reporting and integration surface rather than a base for transactional updates. The presence of the CHECK_CURRENCY_CODE column is significant: users searching for "check_currency_code" typically require the currency of the disbursement instrument itself, which can differ from the invoice currency. This view exposes that value directly, making it a natural target for currency-related reconciliation queries.

Underlying Base Objects

The ETRM metadata documents the view as being defined over four referenced objects:

• AP_CHECKS_ALL (SYNONYM) — the payment document header, aliased AC, providing CHECK_NUMBER, CHECK_ID, CURRENCY_CODE (exposed as CHECK_CURRENCY_CODE), and VENDOR_SITE_ID.
• AP_INVOICES_ALL (SYNONYM) — the invoice header, aliased AI, providing INVOICE_NUM, INVOICE_ID, and INVOICE_CURRENCY_CODE.
• AP_INVOICE_PAYMENTS_ALL (SYNONYM) — the invoice-to-payment intersection, aliased AIP, providing AMOUNT, DISCOUNT_TAKEN, ACCOUNTING_DATE, and INVOICE_PAYMENT_ID.
• FND_CURRENCY (PACKAGE) — used at runtime, specifically FND_CURRENCY.SAFE_GET_FORMAT_MASK, to derive the amount format mask from the check currency.

The join is an inner join: AIP.INVOICE_ID = AI.INVOICE_ID AND AIP.CHECK_ID = AC.CHECK_ID. Only invoice payments that resolve to both an invoice and a payment document are returned; orphaned or unmapped payment records are excluded.

Key Columns

• INVOICE_NUM / INVOICE_ID — the supplier invoice identifier and its surrogate key.
• INVOICE_CURRENCY_CODE — currency in which the invoice was entered.
• CHECK_NUMBER / CHECK_ID — the payment document number and key.
• CHECK_CURRENCY_CODE — the currency of the payment document. This is the column most directly relevant to the "check_currency_code" search term and supports bank/cash currency analysis.
• VENDOR_SITE_ID — the supplier site associated with the payment.
• AMOUNT / DISCOUNT_TAKEN — payment amount and discount, returned as TO_CHAR formatted using the check currency mask (default 30). These are character values, not numeric.
• ACCOUNTING_DATE — accounting date of the payment distribution.
• INVOICE_PAYMENT_ID — primary key of the payment line.

Common Use Cases and Queries

Typical uses include supplier payment reconciliation, cash-currency reporting, and integration extracts feeding downstream systems. Because AMOUNT is character-formatted, arithmetic should be performed against the base tables where numeric precision is required.

To retrieve payments in the check currency:

• SELECT invoice_num, check_number, check_currency_code, amount FROM apps.pos_ap_invoice_payments_v WHERE check_currency_code = 'USD';

To identify invoices where the check currency differs from the invoice currency (cross-currency or multi-currency settlement):

• SELECT invoice_num, check_number, invoice_currency_code, check_currency_code FROM apps.pos_ap_invoice_payments_v WHERE check_currency_code <> invoice_currency_code;

To reconcile all payments for a given invoice ID:

• SELECT check_number, amount, accounting_date FROM apps.pos_ap_invoice_payments_v WHERE invoice_id = :invoice_id ORDER BY accounting_date;