JDBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9434

ShipmentsouterPackingUnitspackingUnitPackingInstructions

Stores specific instructions for packing individual packing units, ensuring compliance with shipping and handling standards.

Columns

Name Type Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the packing unit packing instructions, used for tracking deliveries and their related packing details.
OuterpackingunitsLPNId [KEY] Long License Plate Number (LPN) identifier for the outer packing unit, used to identify and track the outer packaging of goods during transportation.
NoteId [KEY] Long Identifier for the note associated with the packing unit packing instructions, used to reference any special instructions or information related to the packing.
PackingInstructions String Detailed packing instructions for the packing unit, providing guidance on how to handle, pack, and ship the contents of the packing unit.
BaseItem String The primary item associated with the packing instructions, typically the most significant item in the shipment or packing unit.
DeliveryId Long Unique identifier for the delivery related to the packing unit, helping track the logistics and associated packing instructions for the shipment.
EndAssemblyItemNumber String The item number for the end assembly product, which is the final product or item in the assembly process linked to the packing instructions.
Finder String Searchable reference or keyword used to locate the packing unit packing instructions in the system, making it easier to retrieve specific records.
IntegrationStatus String Current status of the integration for the packing unit packing instructions, used to ensure synchronization between systems or databases.
Item String Specific item linked to the packing instructions, helping associate costs, quantities, and handling details with individual products in the packing unit.
LineStatus String Status of the packing instructions line item, indicating whether it is pending, approved, or completed, useful for tracking progress and updates.
OrderNumber String Order number associated with the packing unit packing instructions, used to reference the originating order linked to the packing and shipping process.
OrderType String Type of order associated with the packing unit packing instructions, such as 'sales order' or 'purchase order', for better classification and handling.
OrderTypeCode String Code representing the order type, offering a quick reference for identifying the type of order linked to the packing instructions.
ParentPackingUnit String Identifier for the parent packing unit, linking the packing unit packing instructions to a higher-level packaging structure or unit.
PickWave String Identifier for the pick wave associated with the packing unit, used to manage the process of picking goods from the warehouse for packing and shipping.
QuickShipStatus String Status indicating whether the packing unit is eligible for expedited shipping, helping to prioritize urgent shipments.
RcvShipmentLineId Long Identifier for the received shipment line linked to the packing unit packing instructions, used to match shipments with the packing instructions.
Shipment String Shipment identifier for the packing unit, used to track the shipment and ensure that it is handled according to the packing instructions.
ShipmentSet String Identifier for the shipment set containing the packing unit, used to group related shipments for more efficient handling and tracking.
ShipToCustomer String The customer receiving the packing unit, critical for customer service, delivery tracking, and logistics.
ShipToPartyId String Unique identifier for the party receiving the packing unit, helping to match the shipment to the correct customer or recipient.
SourceOrder String Source order number from which the packing unit packing instructions are derived, providing a reference back to the original order.
SourceOrderFulfillmentLine String Line number from the source order fulfillment linked to the packing unit, used to provide granular details for fulfillment and packing.
SourceOrderFulfillmentLineId String Unique identifier for the source order fulfillment line, linking the packing instructions to the specific fulfillment line.
SourceOrderLine String Line item from the source order corresponding to the packing unit, helping to trace packing and shipping costs back to the original order line.
SourceSystemId String Identifier for the source system that generated the packing unit packing instructions, ensuring consistency and data integrity across systems.
TradeComplianceStatus String Status of the trade compliance check for the packing unit, ensuring that the shipment adheres to relevant trade regulations and legal requirements.
TransportationPlanningStatus String Current status of transportation planning for the packing unit, used to manage and track the logistics and transportation planning process.

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