EBS Reference
Purchasing
Supply chainPurchase orders, requisitions, and supplier records across the procure-to-pay cycle
10 tables
Tables
Master · 2
- AP_SUPPLIER_SITES_ALLSupplier sites — the purchasing/pay/RFQ site records per supplier, one row per site per operating unit, with the site code and control flags; where supplier data meets MOAC stripingSchema: APmaster
- AP_SUPPLIERSThe R12 supplier master — one global row per supplier with the supplier number, type, and control flags, backed by the trading community architecture through its party idSchema: APmaster
Transaction · 7
- PO_DISTRIBUTIONS_ALLPO accounting distributions — how each shipment schedule's quantity charges out: destination type, receiving inventory org and subinventory, charge account (CCID), and the requisition distribution it fulfillsSchema: POtransaction
- PO_HEADERS_ALLPurchasing document headers — one row per purchase order, agreement, quotation, or RFQ (seven document types share the table), with supplier, buyer, currency, approval status, and closure state; operating-unit stripedSchema: POtransaction
- PO_LINE_LOCATIONS_ALLPO shipment schedules — one row per delivery schedule per line with need-by/promised dates and the running received/billed/cancelled quantity counters; blanket price-break rows share the tableSchema: POtransaction
- PO_LINES_ALLPurchasing document lines — the item, category, unit price, and ordered quantity per line across the same seven document types; shipment schedules and accounting live one and two levels downSchema: POtransaction
- PO_RELEASES_ALLBlanket and planned PO releases — one row per release with its number, date, buyer, and approval status; the shipment schedules a release creates point back hereSchema: POtransaction
- PO_REQUISITION_HEADERS_ALLRequisition headers — the requisition number, preparer, type (purchase vs internal), and approval status; where demand enters purchasing before it becomes a POSchema: POtransaction
- PO_REQUISITION_LINES_ALLRequisition lines — item, quantity, price, need-by date, destination inventory org, and sourcing suggestion per line; carries the link to the PO shipment autocreate built from itSchema: POtransaction