Oracle Fusion · Data dictionary
PO_DISTRIBUTIONS_ALL
ProcurementUsed in 18 subject areas32 reporting columns
Purchasing (PO), accounting distribution lines, the GL coding behind each transaction line.
Likely primary key: PO_DISTRIBUTION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): LINE_LOCATION_ID → PO_LINE_LOCATIONS_ALL · PO_DISTRIBUTION_ID → PO_DISTRIBUTIONS_DRAFT_ALL · REQ_DISTRIBUTION_ID → POR_REQ_DISTRIBUTIONS_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AMOUNT_BILLED | ● | Amount billed. | |
| AMOUNT_CANCELLED | ● | Amount cancelled. | |
| AMOUNT_DELIVERED | ● | Amount delivered. | |
| AMOUNT_ORDERED | ● | Amount ordered. | |
| BUDGET_DATE | ● | Budget date. | |
| CONSIGNMENT_QUANTITY | ● | Consignment quantity. | |
| DELIVER_TO_CUST_LOCATION_ID | ● | Identifier for the deliver to customer location. | |
| DESTINATION_TYPE_CODE | ● | Code identifying the destination type. | |
| DISTRIBUTION_NUM | ● | Distribution number. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| GL_CANCELLED_DATE | ● | General ledger cancelled date. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_LOCATION_ID | ● | Identifier for the line location. | |
| NONRECOVERABLE_TAX | ● | Nonrecoverable tax. | |
| PJC_EXPENDITURE_ITEM_DATE | ● | Pjc expenditure item date. | |
| PO_DISTRIBUTION_ID | PK? | ● | Identifier for the purchase order distribution. |
| PO_HEADER_ID | ● | Identifier for the purchase order header. | |
| PO_LINE_ID | ● | Identifier for the purchase order line. | |
| QUANTITY_BILLED | ● | Quantity billed. | |
| QUANTITY_CANCELLED | ● | Quantity cancelled. | |
| QUANTITY_DELIVERED | ● | Quantity delivered. | |
| QUANTITY_ORDERED | ● | Quantity ordered. | |
| RATE | ● | Rate. | |
| RATE_DATE | ● | Rate date. | |
| RECOVERABLE_TAX | ● | Recoverable tax. | |
| REQ_DISTRIBUTION_ID | ● | Identifier for the req distribution. | |
| REQ_HEADER_REFERENCE_NUM | ● | Req header reference number. | |
| REQ_LINE_REFERENCE_NUM | ● | Req line reference number. | |
| SHIPPING_UOM_QTY_DELIVERED | ● | Shipping unit of measure quantity delivered. | |
| SHIPPING_UOM_QUANTITY | ● | Shipping unit of measure quantity. | |
| SHIPPING_UOM_QUANTITY_CANCELED | ● | Shipping unit of measure quantity canceled. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Budgetary Control - Transactions Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Fiscal Document Capture Transactions Real Time
- Fixed Assets - Asset Source Lines Real Time
- Inventory - Inventory Supply Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Manufacturing - Purchased Item Usage Real Time
- Payables Invoices - Holds Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Procurement - Spend Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for PO_DISTRIBUTIONS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table