JDBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9434

ShipmentsouterPackingUnitspackingUnitsDFF

Offers a flexible framework to add custom attributes to packing units using flexfields.

Columns

Name Type Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the packing units in the descriptive flexfield (DFF), used to link packing instructions to the relevant delivery.
OuterpackingunitsLPNId [KEY] Long License Plate Number (LPN) identifier for the outer packing unit, essential for tracking the outermost package in the shipping process.
LPNId [KEY] Long LPN identifier for the packing unit, used to track individual units within the larger shipment.
_FLEX_Context String DFF context name for the packing units, which provides an additional layer of classification and context for the data.
_FLEX_Context_DisplayValue String Display value for the DFF context, offering a human-readable interpretation of the packing unit context.
BaseItem String The primary item associated with the packing unit, typically used to categorize or prioritize the packing process in the shipment.
DeliveryId Long Unique identifier for the delivery related to the packing unit, essential for linking the packing unit with its delivery schedule and destination.
EndAssemblyItemNumber String The item number of the final assembly or product in the packing unit, useful for tracking finished products in complex shipments.
Finder String Searchable reference or keyword used to locate the packing unit records within the system, helping users find specific packing details efficiently.
IntegrationStatus String Current status of the integration for the packing unit packing instructions, ensuring data synchronization across systems.
Item String The specific item linked to the packing unit, often used to track inventory, shipping details, and fulfillment requirements.
LineStatus String Status of the packing unit line item, indicating whether it is pending, approved, or processed, useful for shipment tracking and management.
OrderNumber String The order number associated with the packing unit, providing a direct link to the originating sales or purchase order.
OrderType String The type of order from which the packing unit is derived, such as 'sales order' or 'purchase order', helping categorize the packing unit's origin.
OrderTypeCode String Code that represents the order type, offering a quick reference for identifying different types of orders related to packing units.
ParentPackingUnit String Identifier for the parent packing unit, used to associate the current packing unit with a larger packaging structure.
PickWave String The identifier for the pick wave associated with the packing unit, used to manage the warehouse picking process and optimize packing schedules.
QuickShipStatus String Indicates whether the packing unit is eligible for expedited or priority shipping, helping prioritize urgent shipments.
RcvShipmentLineId Long Identifier for the received shipment line linked to the packing unit, providing a reference to the shipment line during the receiving process.
Shipment String The identifier for the shipment to which the packing unit belongs, enabling efficient shipment tracking and status updates.
ShipmentSet String The identifier for the shipment set containing the packing unit, used to group multiple shipments for easier handling and processing.
ShipToCustomer String The name of the customer who will receive the packing unit, essential for customer service and shipment delivery tracking.
ShipToPartyId String Unique identifier for the ship-to party, ensuring correct destination for the packing unit within the larger shipment process.
SourceOrder String The source order number from which the packing unit packing instructions are derived, providing a reference back to the originating order.
SourceOrderFulfillmentLine String The fulfillment line number from the source order that corresponds to the packing unit, linking the packing instructions with specific fulfillment lines.
SourceOrderFulfillmentLineId String Unique identifier for the fulfillment line from the source order, providing a direct reference to the specific line item of the order.
SourceOrderLine String Line item number from the source order, used to connect the packing unit with the relevant order line for inventory and order tracking.
SourceSystemId String The identifier for the source system that generated the packing unit packing instructions, ensuring consistency and data integration across systems.
TradeComplianceStatus String The trade compliance status for the packing unit, ensuring that the shipment meets all necessary legal and regulatory requirements before export or import.
TransportationPlanningStatus String The current status of transportation planning for the packing unit, tracking whether it has been scheduled, planned, or is awaiting further logistics coordination.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434