Understanding the Matching Tables
Payables uses several of Oracle Purchasing tables for matching. To implement matching in Payables, you need to load these tables with the data from your non-Oracle purchasing application.
- PO_DISTRIBUTIONS_AP_V (view of PO_DISTRIBUTIONS)
- PO_RELEASES (Blanket Purchase Orders)
AutoInstall automatically installs these and other necessary Oracle Purchasing application tables when you install Payables.
PO_HEADERS
Each record in this table represents a purchase order, which is an order for goods or services from a single supplier. Each purchase order may have multiple lines (PO_LINES).
In addition, each blanket purchase order may have multiple blanket releases (PO_RELEASES), which release an amount from the blanket.
PO_LINES
Each record in this table represents a purchase order line, which identifies the items and unit price for the goods ordered on a purchase order. Each purchase order line may have multiple shipments (PO_LINE_LOCATIONS).
PO_LINE_LOCATIONS
Each 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 shipment may have multiple accounting distributions (PO_DISTRIBUTIONS).
PO_DISTRIBUTIONS/PO_DISTRIBUTIONS_AP_V
Each record in this table/view represents a purchase order distribution, which identifies the account charged for the items on a purchase order shipment.
PO_RELEASES
Each record in this table represents a blanket release for a purchase order. A blanket release may create multiple shipments.
Each purchase order shipment can be matched to multiple invoices (AP_INVOICES), and a single invoice may be matched to multiple purchase order shipments.
When you match an invoice to a purchase order shipment, Payables creates an invoice distribution (AP_INVOICE_DISTRIBUTIONS) from each purchase order distribution on the shipment. When you match an invoice to a single purchase order distribution, Payables creates a single invoice distribution from the purchase order distribution.
