Fusion Reference
Procurement
Supply chainPurchase orders, requisitions, and supplier records across the procure-to-pay cycle
8 tables
Extraction map
The BICC extract data store (PVO) reaching each of this module’s tables — the bulk path out of the SaaS database. Full details, OTBI subject areas, and provenance links live on each table page.
| Table | BICC extract data store (PVO) |
|---|---|
| PO_DISTRIBUTIONS_ALL | FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentDistributionExtractPVO |
| PO_HEADERS_ALL | FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentHeaderExtractPVO |
| PO_LINE_LOCATIONS_ALL | FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentLineLocationExtractPVO |
| PO_LINES_ALL | FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentLineExtractPVO |
| POR_REQUISITION_HEADERS_ALL | FscmTopModelAM.PrcExtractAM.PorBiccExtractAM.RequisitionHeaderExtractPVO |
| POR_REQUISITION_LINES_ALL | FscmTopModelAM.PrcExtractAM.PorBiccExtractAM.RequisitionLineExtractPVO |
| POZ_SUPPLIER_SITES_ALL_M | FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierSiteExtractPVO |
| POZ_SUPPLIERS | FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO |
Tables
Master · 2
- POZ_SUPPLIER_SITES_ALL_MSupplier sites — the transactable endpoints purchase orders and payments point at, one row per supplier address per procurement business unit, with purchasing/pay/RFQ purpose flags and payment defaultsProduct: POZmaster
- POZ_SUPPLIERSThe supplier master — one row per supplier with the supplier number, type, business relationship level, and tax attributes, backed by the trading community architecture through its party idProduct: POZmaster
Transaction · 6
- PO_DISTRIBUTIONS_ALLPO accounting distributions — how each schedule's quantity charges out: destination type and org, deliver-to, the GL charge account, project costing columns, and the requisition distribution it fulfillsProduct: POtransaction
- PO_HEADERS_ALLPurchasing document headers — one row per purchase order or agreement (standard, blanket, contract), with supplier, buyer, currency, and the document status; striped by the procurement business unitProduct: POtransaction
- PO_LINE_LOCATIONS_ALLPO schedules — one row per shipment schedule (or blanket price break) with need-by/promised dates and the system-maintained received/accepted/rejected/billed quantity buckets; the workhorse grain for open-PO analyticsProduct: POtransaction
- PO_LINES_ALLPurchasing document lines — the item, category, unit price, and ordered quantity per line; the line quantity is the rollup of its schedules one level downProduct: POtransaction
- POR_REQUISITION_HEADERS_ALLRequisition headers — the requisition number, preparer, status, and justification; where demand enters procurement before it becomes a purchase orderProduct: PORtransaction
- POR_REQUISITION_LINES_ALLRequisition lines — item, quantity, price, need-by date, destination org, and suggested supplier per line; carries the keys of the resulting PO header, line, and schedule once sourcedProduct: PORtransaction