PO_LINE_LOCATIONS_ALL

ProcurementUsed in 46 subject areas85 reporting columns

Purchasing (PO) — transaction table (rows scoped across all operating units).

Likely primary key: LINE_LOCATION_ID (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

Column	Key	In reports	Description (inferred)
ACCRUE_ON_RECEIPT_FLAG		●	Indicator (Y/N) for the accrue on receipt.
ALLOW_SUBSTITUTE_RECEIPTS_FLAG		●	Indicator (Y/N) for the allow substitute receipts.
AMOUNT		●	Amount.
AMOUNT_ACCEPTED		●	Amount accepted.
AMOUNT_BILLED		●	Amount billed.
AMOUNT_CANCELLED		●	Amount cancelled.
AMOUNT_RECEIVED		●	Amount received.
AUTO_CLOSURE_MODE		●	Auto closure mode.
BACK_TO_BACK_FLAG		●	Indicator (Y/N) for the back to back.
CANCEL_DATE		●	Cancel date.
CLOSED_FOR_INVOICE_DATE		●	Closed for invoice date.
CLOSED_FOR_RECEIVING_DATE		●	Closed for receiving date.
CLOSED_REASON		●	Closed reason.
COUNTRY_OF_ORIGIN_CODE		●	Code identifying the country of origin.
CREATION_DATE		●	Date and time the row was created.
DAYS_EARLY_RECEIPT_ALLOWED		●	Days early receipt allowed.
DAYS_LATE_RECEIPT_ALLOWED		●	Days late receipt allowed.
DESCRIPTION		●	Description.
DESTINATION_TYPE_CODE		●	Code identifying the destination type.
END_DATE		●	End date.
ENFORCE_SHIP_TO_LOCATION_CODE		●	Code identifying the enforce shipment to location.
FUNDS_STATUS		●	Status of the funds.
INPUT_TAX_CLASSIFICATION_CODE		●	Code identifying the input tax classification.
INSPECTION_REQUIRED_FLAG		●	Indicator (Y/N) for the inspection required.
INVOICE_CLOSE_TOLERANCE		●	Invoice close tolerance.
LAST_ACCEPT_DATE		●	Last accept 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_INTENDED_USE		●	Line intended use.
LINE_LOCATION_ID	PK?	●	Identifier for the line location.
MATCH_OPTION		●	Match option.
MODE_OF_TRANSPORT		●	Mode of transport.
NEED_BY_DATE		●	Need by date.
NOTE_TO_RECEIVER		●	Note to receiver.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
PAYMENT_TYPE		●	Type of payment.
PO_HEADER_ID		●	Identifier for the purchase order header.
PO_LINE_ID		●	Identifier for the purchase order line.
PRICE_DISCOUNT		●	Price discount.
PRICE_OVERRIDE		●	Price override.
PRODUCT_CATEGORY		●	Product category.
PRODUCT_FISC_CLASSIFICATION		●	Product fisc classification.
PRODUCT_TYPE		●	Type of product.
PROMISED_DATE		●	Promised date.
PROMISED_SHIP_DATE		●	Promised shipment date.
QTY_RCV_EXCEPTION_CODE		●	Code identifying the quantity receiving exception.
QTY_RCV_TOLERANCE		●	Quantity receiving tolerance.
QUANTITY		●	Quantity.
QUANTITY_ACCEPTED		●	Quantity accepted.
QUANTITY_BILLED		●	Quantity billed.
QUANTITY_CANCELLED		●	Quantity cancelled.
QUANTITY_RECEIVED		●	Quantity received.
QUANTITY_SHIPPED		●	Quantity shipped.
RECEIPT_DAYS_EXCEPTION_CODE		●	Code identifying the receipt days exception.
RECEIPT_REQUIRED_FLAG		●	Indicator (Y/N) for the receipt required.
RECEIVE_CLOSE_TOLERANCE		●	Receive close tolerance.
RECEIVING_ROUTING_ID		●	Identifier for the receiving routing.
REQUESTED_SHIP_DATE		●	Requested shipment date.
RETAINAGE_RATE		●	Retainage rate.
RETAINAGE_RELEASED_AMOUNT		●	Retainage released amount.
RETAINAGE_WITHHELD_AMOUNT		●	Retainage withheld amount.
SALES_ORDER_NUMBER		●	Sales order number.
SCHEDULE_STATUS		●	Status of the schedule.
SECONDARY_QUANTITY		●	Secondary quantity.
SECONDARY_QUANTITY_CANCELLED		●	Secondary quantity cancelled.
SECONDARY_UOM_CODE		●	Code identifying the secondary unit of measure.
SERVICE_LEVEL		●	Service level.
SFO_AGREEMENT_NUMBER		●	Sfo agreement number.
SHIPMENT_CLOSED_DATE		●	Shipment closed date.
SHIPMENT_NUM		●	Shipment number.
SHIPMENT_TYPE		●	Type of shipment.
SHIPPING_UOM_CODE		●	Code identifying the shipping unit of measure.
SHIPPING_UOM_QUANTITY		●	Shipping unit of measure quantity.
SHIPPING_UOM_QUANTITY_ACCEPTED		●	Shipping unit of measure quantity accepted.
SHIPPING_UOM_QUANTITY_CANCELED		●	Shipping unit of measure quantity canceled.
SHIPPING_UOM_QUANTITY_RECEIVED		●	Shipping unit of measure quantity received.
SHIPPING_UOM_QUANTITY_SHIPPED		●	Shipping unit of measure quantity shipped.
SHIP_TO_CUST_ID		●	Identifier for the shipment to customer.
SHIP_TO_CUST_LOCATION_ID		●	Identifier for the shipment to customer location.
SHIP_TO_LOCATION_ID		●	Identifier for the shipment to location.
START_DATE		●	Start date.
SUPPLIER_ORDER_LINE_NUMBER		●	Supplier order line number.
TRX_BUSINESS_CATEGORY		●	Transaction business category.
UOM_CODE		●	Code identifying the unit of measure.
USER_DEFINED_FISC_CLASS		●	User defined fisc class.

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_LINE_LOCATIONS_ALL?

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

Talk to us