RCV_SHIPMENT_LINES

ProcurementUsed in 39 subject areas42 reporting columns

Receiving (RCV) — line table — one row per line item under the header.

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

Columns

Column	Key	In reports	Description (inferred)
AMOUNT_RECEIVED		●	Amount received.
ASN_LINE_FLAG		●	Indicator (Y/N) for the advance shipment notice line.
BAR_CODE_LABEL		●	Bar code label.
COMMENTS		●	Comments.
CONSIGNED_FLAG		●	Indicator (Y/N) for the consigned.
CONSUMED_QUANTITY		●	Consumed quantity.
CONTAINER_NUM		●	Container number.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
DESTINATION_TYPE_CODE		●	Code identifying the destination type.
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	PK?	●	Line number.
PACKING_SLIP		●	Packing slip.
PO_DISTRIBUTION_ID		●	Identifier for the purchase order distribution.
PO_HEADER_ID		●	Identifier for the purchase order header.
PO_LINE_ID		●	Identifier for the purchase order line.
PO_LINE_LOCATION_ID		●	Identifier for the purchase order line location.
QUANTITY_ACCEPTED		●	Quantity accepted.
QUANTITY_DELIVERED		●	Quantity delivered.
QUANTITY_RECEIVED		●	Quantity received.
QUANTITY_REJECTED		●	Quantity rejected.
QUANTITY_RETURNED		●	Quantity returned.
QUANTITY_SHIPPED		●	Quantity shipped.
RA_EXPECTED_RECEIPT_DATE		●	Ra expected receipt date.
ROUTING_HEADER_ID		●	Identifier for the routing header.
SECONDARY_QTY_ACCEPTED		●	Secondary quantity accepted.
SECONDARY_QTY_DELIVERED		●	Secondary quantity delivered.
SECONDARY_QTY_REJECTED		●	Secondary quantity rejected.
SECONDARY_QTY_RETURNED		●	Secondary quantity returned.
SECONDARY_QUANTITY_RECEIVED		●	Secondary quantity received.
SECONDARY_QUANTITY_SHIPPED		●	Secondary quantity shipped.
SECONDARY_UOM_CODE		●	Code identifying the secondary unit of measure.
SHIPMENT_HEADER_ID	PK?	●	Identifier for the shipment header.
SHIPMENT_LINE_ID		●	Identifier for the shipment line.
SHIPMENT_LINE_STATUS_CODE		●	Code identifying the shipment line status.
SOURCE_DOCUMENT_CODE		●	Code identifying the source document.
TRUCK_NUM		●	Truck number.
UOM_CODE		●	Code identifying the unit of measure.

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

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

Talk to us