ODBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

ShipmentsouterPackingUnitsshipmentLineslotAttributeDFF

Manages custom attributes for lots associated with shipment lines using descriptive flexfields (DFFs).

Columns

Name Type SupportedFinders Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the shipment.
OuterpackingunitsLPNId [KEY] Long License Plate Number (LPN) identifier for the outer packing unit.
ShipmentlinesShipmentLine [KEY] Long Unique identifier for the shipment line within the packing unit.
InventoryItemId [KEY] Long Unique identifier for the inventory item associated with the shipment.
OrganizationId [KEY] Long Unique identifier for the organization managing the shipment.
LotNumber [KEY] String Lot number assigned to the inventory item being shipped.
_FLEX_Context String Context-sensitive attribute used for flexible configurations.
_FLEX_Context_DisplayValue String Display value for the context-sensitive attribute.
BaseItem String FindByLineAttributes Primary item associated with the shipment line.
DeliveryId Long PrimaryKey Identifier for the delivery linked to the shipment line.
EndAssemblyItemNumber String FindByLineAttributes Final assembled item number for the shipped product.
Finder String Internal reference or tracking identifier for the shipment.
IntegrationStatus String FindByLineAttributes Current integration status of the shipment within external systems.
Item String FindByLineAttributes Item being shipped, identified by its unique product number.
LineStatus String FindByLineAttributes Current processing status of the shipment line.
OrderNumber String FindByLineAttributes Customer or internal order number linked to the shipment.
OrderType String FindByLineAttributes Type of order associated with the shipment, such as sales or transfer orders.
OrderTypeCode String FindByLineAttributes System-generated code representing the type of order.
ParentPackingUnit String FindByLineAttributes Parent packing unit containing this shipment line.
PickWave String FindByLineAttributes Identifier for the picking wave in which this shipment was processed.
QuickShipStatus String FindByLineAttributes Status indicator for expedited shipping processing.
RcvShipmentLineId Long FindByLineAttributes Receiving shipment line identifier for inbound processing.
Shipment String FindByShipmentName Reference identifier for the entire shipment.
ShipmentSet String FindByLineAttributes Grouping of shipments processed together as a set.
ShipToCustomer String FindByLineAttributes Name or identifier of the customer receiving the shipment.
ShipToPartyId String FindByLineAttributes Unique identifier for the party designated as the shipment recipient.
SourceOrder String FindByLineAttributes Originating order that generated this shipment.
SourceOrderFulfillmentLine String FindByLineAttributes Fulfillment line reference from the source order.
SourceOrderFulfillmentLineId String FindByFulfillmentLineId Unique identifier for the source order's fulfillment line.
SourceOrderLine String FindByLineAttributes Reference to the specific order line in the source order.
SourceSystemId String FindByFulfillmentLineId Identifier for the source system that created this shipment record.
TradeComplianceStatus String FindByLineAttributes Indicates whether the shipment complies with trade regulations.
TransportationPlanningStatus String FindByLineAttributes Current transportation planning status for the shipment.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770