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)

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.

Need the extract + dbt staging for PO_LINES_ALL?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us