Oracle Fusion · Data dictionary
PO_LINES_ALL
ProcurementUsed in 50 subject areas54 reporting columns
Purchasing (PO), line table, one row per line item under the header.
Likely primary key: PO_LINE_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): PO_LINE_ID → PO_LINES_DRAFT_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AGING_PERIOD_DAYS | ● | Aging period days. | |
| ALLOW_PRICE_OVERRIDE_FLAG | ● | Indicator (Y/N) for the allow price override. | |
| AMOUNT | ● | Amount. | |
| AMOUNT_RELEASED | ● | Amount released. | |
| CANCELLED_BY | ● | Cancelled by. | |
| CANCEL_DATE | ● | Cancel date. | |
| CANCEL_REASON | ● | Cancel reason. | |
| CLOSED_REASON | ● | Closed reason. | |
| COMMITTED_AMOUNT | ● | Committed amount. | |
| CONSIGNMENT_LINE_FLAG | ● | Indicator (Y/N) for the consignment line. | |
| CONTRACT_ID | ● | Identifier for the contract. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CREDIT_FLAG | ● | Indicator (Y/N) for the credit. | |
| DISCOUNT | ● | Discount. | |
| DISCOUNT_REASON | ● | Discount reason. | |
| DISCOUNT_TYPE | ● | Type of discount. | |
| EXPIRATION_DATE | ● | Expiration date. | |
| FROM_HEADER_ID | ● | Identifier for the from header. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| ITEM_ID | ● | Identifier for the item. | |
| ITEM_REVISION | ● | Item revision. | |
| 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_NUM | ● | Line number. | |
| LINE_REFERENCE_NUM | ● | Line reference number. | |
| LINE_START_DATE | ● | Line start date. | |
| LINE_STATUS | ● | Status of the line. | |
| LINE_TYPE_ID | ● | Identifier for the line type. | |
| LIST_PRICE | ● | List price. | |
| MANUFACTURER | ● | Manufacturer. | |
| MANUFACTURER_PART_NUM | ● | Manufacturer part number. | |
| MATCHING_BASIS | ● | Matching basis. | |
| MAX_RETAINAGE_AMOUNT | ● | Max retainage amount. | |
| MIN_RELEASE_AMOUNT | ● | Min release amount. | |
| NEGOTIATED_BY_PREPARER_FLAG | ● | Indicator (Y/N) for the negotiated by preparer. | |
| NOTE_TO_VENDOR | ● | Note to vendor. | |
| ORDER_TYPE_LOOKUP_CODE | ● | Lookup code for the order type. | |
| PO_HEADER_ID | ● | Identifier for the purchase order header. | |
| PO_LINE_ID | PK? | ● | Identifier for the purchase order line. |
| PRICE_BREAK_LOOKUP_CODE | ● | Lookup code for the price break. | |
| PURCHASE_BASIS | ● | Purchase basis. | |
| QUANTITY | ● | Quantity. | |
| QUANTITY_COMMITTED | ● | Quantity committed. | |
| SECONDARY_QUANTITY | ● | Secondary quantity. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SHIPPING_UOM_CODE | ● | Code identifying the shipping unit of measure. | |
| SHIPPING_UOM_QUANTITY | ● | Shipping unit of measure quantity. | |
| SUPPLIER_PART_AUXID | ● | Supplier part auxid. | |
| SUPPLIER_REF_NUMBER | ● | Supplier reference number. | |
| TAX_EXCLUSIVE_PRICE | ● | Tax exclusive price. | |
| UNIT_PRICE | ● | Unit price. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| VENDOR_PRODUCT_NUM | ● | Vendor product number. |
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 - Cost Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Costing - Where Used Details Real Time
- Costing - Work Order Costs Real Time
- Enterprise Contracts - Contracts Real Time
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transfer Order Real Time
- Inventory - Kanban Activity Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
Need the extract + dbt staging for PO_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table