Results for “export_currency_code”

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

Overview

PN_PAYMENT_ITEMS_EFC is a shadow table in the PN (Property Manager) schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. Its documented purpose is to support Euro functional currency reporting by maintaining a parallel set of payment item records denominated in the Euro currency. In Oracle EBS, "EFC" tables accompany their transactional base tables to store amounts converted to the Euro, which was required by certain regulatory and corporate reporting practices during the Euro transition period. This table mirrors structure held in PN_PAYMENT_ITEMS_ALL, which is the primary store of payment items used by Property Manager for disbursement and receipt activities.

Reflecting the mined foreign-key structure, this object behaves as a link table in Data Vault modeling terms: it connects parties (customers and sites) to payment instruments (payment items, payment terms) and carries measurable attributes such as amounts, rates, and flags. It is not a hub, since it holds no stable business key of its own beyond the surrogate identifier.

Key Information Stored

The table contains 26 documented columns. The most significant are:

• PAYMENT_ITEM_ID — The surrogate primary key and sole column of the unique index PN_PAYMENT_ITEMS_EFC_U1; also serves as the foreign key linking back to PN_PAYMENT_ITEMS_ALL.
• DUE_DATE — The scheduled due date for the payment item.
• SET_OF_BOOKS_ID — Identifies the ledger under which the item is recorded.
• CURRENCY_CODE and EXPORT_CURRENCY_CODE — The transaction currency and the corresponding Euro export currency.
• RATE — The conversion rate applied to translate the transaction amount into the export currency.
• ACTUAL_AMOUNT and ESTIMATED_AMOUNT — Realised and anticipated amounts for the payment item.
• EXPORT_CURRENCY_AMOUNT — The Euro-denominated amount, computed using RATE.
• PAYMENT_ITEM_TYPE_LOOKUP_CODE — Classifies the item type via a lookup.
• PAYMENT_TERM_ID — Foreign key to PN_PAYMENT_TERMS_ALL, defining terms associated with the item.
• CUSTOMER_ID and CUSTOMER_SITE_USE_ID — Foreign keys to HZ_CUST_ACCOUNTS and HZ_CUST_SITE_USES_ALL respectively, identifying the paying party and site.
• VENDOR_ID, VENDOR_SITE_ID — Supplier identities where disbursement is involved.
• EXPORT_TO_AP_FLAG, TRANSFERRED_TO_AP_FLAG, EXPORT_TO_AR_FLAG, TRANSFERRED_TO_AR_FLAG — Control flags governing posting to Payables or Receivables.
• AP_INVOICE_NUM, AR_TRX_NUM — Document references in the destination sub-ledgers.
• ORG_ID — Operating unit identifier, supporting multi-org access control.

Common Use Cases and Queries

Report developers commonly join this shadow table to PN_PAYMENT_ITEMS_ALL to compare base and Euro-denominated amounts, especially for pre-Euro transition reconciliations or audit trails. A typical reconciliation query:

SELECT a.PAYMENT_ITEM_ID, a.ACTUAL_AMOUNT, e.EXPORT_CURRENCY_AMOUNT, e.RATE
FROM PN_PAYMENT_ITEMS_ALL a, PN_PAYMENT_ITEMS_EFC e
WHERE a.PAYMENT_ITEM_ID = e.PAYMENT_ITEM_ID
AND e.SET_OF_BOOKS_ID = :ledger;

Operational queries frequently filter by EXPORT_TO_AP_FLAG or EXPORT_TO_AR_FLAG to identify items pending transfer, or aggregate EXPORT_CURRENCY_AMOUNT by DUE_DATE for cash-flow forecasting. Customer-facing reports join HZ_CUST_ACCOUNTS via CUSTOMER_ID to present party-level balances.

Related Objects

• PN_PAYMENT_ITEMS_ALL — Parent transactional table; joined on PAYMENT_ITEM_ID.
• PN_PAYMENT_TERMS_ALL — Referenced through PAYMENT_TERM_ID.
• HZ_CUST_ACCOUNTS — Referenced through CUSTOMER_ID.
• HZ_CUST_SITE_USES_ALL — Referenced through CUSTOMER_SITE_USE_ID.
• AP_INVOICES_ALL — Destination of items flagged for AP export via AP_INVOICE_NUM.
• RA_CUSTOMER_TRX_ALL — Destination of items flagged for AR export via AR_TRX_NUM.
• GL_SETS_OF_BOOKS — Joined on SET_OF_BOOKS_ID for ledger context.