PO Base Tables

1. PO_HEADERS_ALL
2. PO_LINES_ALL
3. PO_DISTRIBUTIONS_ALL
4. PO_LINE_LOCATIONS_ALL
5. PO_VENDOR_SITES_ALL
6. PO_RELEASES_ALL
7. PO_VENDOR_CONTACTS
8. PO_ACTION_HISTORY

PO_HEADERS_ALL

This is the header table in the Purchase Order Module.
In this table, we can have information like PO_NUMBER, PO_TYPE, VENDOR_ID, VENDOR_SITE_ID, CURRENCY, And PO_STATUS.
SEGMENT1 -- Po Number
Important Columns -- PO_HEADER_ID, SEGMENT1, TYPE_LOOKUP_CODE, VENDOR_ID, VENDOR_SITE_ID, CLOSED_CODE
You can uniquely identify a row in PO_HEADERS_ALL using ORG_ID, SEGMENT1, and TYPE_LOOKUP_CODE, or using PO_HEADER_ID

This is the Lines table in the PO Module.
In this table, we can have information like Item_id, Quantity, Item_description, UOM(Unit Of Measures), Unit_Price, and other details related to ordered items.
Important Columns -- PO_LINE_ID, PO_HEADER_ID, LINE_TYPE_ID, LINE_NUMBER, ITEM_ID, ORG_ID,CLOSED_CODE

PO_DISTRIBUTIONS_ALL

This is the Distribution table.
In this table, we can have information like GL Account Details and also Ship To and Bill To Details.
Important Columns -- PO_DISTRIBUTION_ID, PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, CODE_COMBINATION_ID, REQ_DISTRIBUTION_ID

This table is similar to PO_LINES_ALL Table.
In this table, we can have all information which is available in Lines Table along with the Received Quantity and Invoiced Quantity also and Ship and Bill To Details also will be available in this table.
Important Columns -- LINE_LOCATION_ID, PO_HEADER_ID, PO_LINE_ID,QUANTITY, QUANTITY_RECEIVED, QUANTITY_ACCEPTED, QUANTITY_REJECTED, QUANTITY_BILLED, QUANTITY_CANCELLED, TAXABLE_FLAG, ORG_ID, SHIP_TO_ORGANIZATION_ID