Each purchase order shipment may have multiple accounting distributions (PO_DISTRIBUTIONS). PO_LINE_LOCATIONSĮach record in this table represents a purchase order shipment, which identifies the quantity of an item shipped to a buyer location by the supplier. Each purchase order line may have multiple shipments (PO_LINE_LOCATIONS). PO_LINESĮach record in this table represents a purchase order line, which identifies the items and unit price for the goods ordered on a purchase order. In addition, each blanket purchase order may have multiple blanket releases (PO_RELEASES), which release an amount from the blanket. Each purchase order may have multiple lines (PO_LINES). PO_HEADERSĮach record in this table represents a purchase order, which is an order for goods or services from a single supplier.
#PO INSTALL#
PO_DISTRIBUTIONS_AP_V (view of PO_DISTRIBUTIONS)ĪutoUpgrade automatically installs these and other necessary Oracle Purchasing application tables when you install Payables. To implement matching in Payables, you need to load these tables with the data from your non-Oracle purchasing application. Payables uses several of Oracle Purchasing tables for matching. Purchasing Integration, Oracle Payables User Guide Understanding the Matching Tables Using Encumbrance Accounting with PurchasingĮntering Invoices with Matched Purchase Orders in the Invoice Workbench, Oracle Payables User Guide This discussion includes the following topics: For complete details on all the entities and relationships that Payables uses for matching, see: Table Definitions Payables Applications Technical Reference Manual. Important: We only include descriptions of the required tables and columns for matching to a non-Oracle purchasing system. This document explains the data necessary to integrate Payables with a non-Oracle purchasing system and describes how Payables uses the data to perform two-way, three-way and four-way matching to purchase orders. Note that you can match to receipts only if you use Oracle Purchasing. Payables is tightly integrated with Oracle Purchasing to facilitate paperless matching, but you can take advantage of matching to purchase orders even if you are using another purchasing system with Payables. Payables provides sophisticated purchase order matching features to ensure that you only pay for goods and services you ordered, received and accepted.
7/9 Purchase Order Matching Database Tables Purchase Order Matching Database Tables