Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentsouterPackingUnits

Tracks and manages details of outer packing units used in shipments, including dimensions and associated shipments.

Columns

Name Type Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the shipment's outer packing unit, used to track deliveries in the logistics system.
LPNId [KEY] Long Identifier for the License Plate Number (LPN) assigned to the shipment's outer packing unit, typically used for tracking and managing packaging.
LicensePlateNumber String LPN assigned to the outer packing unit for tracking, which can include a barcode or RFID tag.
TrackingNumber String Tracking number associated with the outer packing unit, used by the carrier to track the shipment through its transit stages.
MasterSerialNumber String Serial number for the master item within the outer packing unit, representing the highest-level identifier for inventory control.
SealNumber String Seal number associated with the shipment's outer packing unit, used for security and to verify that the packaging has not been tampered with.
InventoryItemId Long Identifier for the inventory item contained within the outer packing unit, used for inventory and shipping management.
ContainerItem String Description or identifier for the item in the outer packing unit, typically used to track the type of goods contained.
ContainerItemDescription String Description of the container item, providing additional details about the item within the outer packing unit.
ContainerVolume Decimal Volume of the outer packing unit, used to assess storage requirements and shipping space.
ContainerVolumeUOMCode String Unit of measure (UOM) code for the volume of the outer packing unit, used for consistency in tracking the size or capacity of the unit.
ContainerVolumeUOM String UOM for the container volume (for example, cubic meters, liters), providing a consistent metric for shipping calculations.
FOBCode String Freight on board code for the outer packing unit, specifying the point at which ownership and risk are transferred from the seller to the buyer.
FOB String Freight on board terms for the outer packing unit, indicating whether the seller or buyer is responsible for shipping and risk.
GrossWeight Decimal Gross weight of the outer packing unit, including the weight of both the goods and packaging, used for shipping and logistics purposes.
GrossWeightUOMCode String UOM code for the gross weight of the outer packing unit, used to standardize weight calculations across systems.
GrossWeightUOM String UOM for the gross weight (for example, kilograms, pounds), providing a consistent metric for shipping calculations.
TareWeight Decimal Weight of the packaging material of the outer packing unit, excluding the contents, used to calculate net weight and shipping costs.
TareWeightUOMCode String UOM code for the tare weight of the outer packing unit, used for weight standardization in the shipping process.
TareWeightUOM String UOM for the tare weight (for example, kilograms, pounds), used to track packaging weight independently of the contents.
NetWeight Decimal Net weight of the contents of the outer packing unit, excluding the weight of the packaging material.
NetWeightUOMCode String UOM code for the net weight of the outer packing unit, ensuring standardization in weight calculations.
NetWeightUOM String UOM for the net weight (for example, kilograms, pounds), used to track the actual weight of the goods.
PackingUnitCategoryCode String Code representing the category of packing unit, used to classify the type of packaging used for the shipment.
PackingUnitCategory String Category or type of packing unit, such as 'box', 'pallet', or 'crate', indicating how the items are grouped for shipment.
UnitHeight Decimal Height of the outer packing unit, providing dimensions for shipping and storage purposes.
UnitLength Decimal Length of the outer packing unit, essential for determining space requirements during shipment and storage.
UnitWidth Decimal Width of the outer packing unit, used to calculate total volume and determine storage space.
DimensionUOMCode String UOM code for the dimensions of the outer packing unit, standardizing how dimensions are tracked.
DimensionUOM String UOM for the dimensions (for example, meters, inches) to provide a consistent method of tracking packing unit size.
ParentLPNId Long Identifier for the parent LPN if this outer packing unit is part of a larger shipment grouping.
ParentPackingUnit String Identifier for the parent packing unit, indicating the larger container or unit under which this outer packing unit is categorized.
OutermostPackingUnitId Long Identifier for the outermost packing unit in the shipment, used to track the largest or final packaging for the goods.
OutermostPackingUnit String Identifier for the outermost packing unit, the final packaging layer in the shipment hierarchy.
PercentageFilled Long Percentage of the outer packing unit that is filled, used to monitor the efficiency of packaging and avoid overstocking.
VolumeFilled Long Volume of the outer packing unit that is occupied by the goods, used to optimize storage and shipping capacity.
ShipFromLocationId Long Identifier for the location from which the outer packing unit is shipped, useful for tracking the source of the goods.
ShipToLocationId Long Identifier for the destination location for the outer packing unit, critical for managing logistics and route planning.
CarrierId Long Identifier for the carrier responsible for transporting the outer packing unit, ensuring the correct logistics partner is selected.
Carrier String Name of the carrier responsible for transporting the outer packing unit, used for managing carrier relationships.
CarrierNumber String Carrier number assigned to the outer packing unit for reference by the carrier, often used in logistics and tracking systems.
ServiceLevelCode String Code for the service level selected for the shipment, indicating the speed or priority of delivery.
ServiceLevel String Description of the service level (for example, standard, expedited) chosen for shipping the outer packing unit.
ModeOfTransportCode String Code for the mode of transport used for the outer packing unit, such as air, sea, road, or rail.
ModeOfTransport String Description of the mode of transport (for example, air freight, ocean shipping), specifying how the shipment is being delivered.
ShipFromAddress1 String First line of the shipping address for the origin of the outer packing unit, used in logistics to determine the start point.
ShipFromAddress2 String Second line of the shipping address for the origin of the outer packing unit, used for additional address details.
ShipFromAddress3 String Third line of the shipping address for the origin of the outer packing unit, for more complex address structures.
ShipFromAddress4 String Fourth line of the shipping address for the origin of the outer packing unit, often used for location-specific details.
ShipFromCity String City of the origin address for the outer packing unit, essential for route planning and determining shipping origin.
ShipFromCounty String County of the origin address for the outer packing unit, used for more localized tracking of shipments.
ShipFromState String State or region of the origin address for the outer packing unit, needed for shipping logistics.
ShipFromRegion String Region of the origin address for the outer packing unit, providing additional location detail for logistics planning.
ShipFromCountry String Country of the origin address for the outer packing unit, indicating the country from which the goods are being shipped.
ShipFromPostalCode String Postal code of the origin address for the outer packing unit, necessary for detailed address verification.
ShipToAddress1 String First line of the shipping address for the destination of the outer packing unit, used for delivery address details.
ShipToAddress2 String Second line of the shipping address for the destination of the outer packing unit, providing additional address information.
ShipToAddress3 String Third line of the shipping address for the destination of the outer packing unit, used in complex address systems.
ShipToAddress4 String Fourth line of the shipping address for the destination of the outer packing unit, for further address specificity.
ShipToCity String City of the destination address for the outer packing unit, essential for final delivery planning.
ShipToCounty String County of the destination address for the outer packing unit, providing more localized destination information.
ShipToState String State or region of the destination address for the outer packing unit, used for final delivery planning.
ShipToRegion String Region of the destination address for the outer packing unit, used to ensure accurate delivery.
ShipToCountry String Country of the destination address for the outer packing unit, indicating where the shipment is being delivered.
ShipToPostalCode String Postal code of the destination address for the outer packing unit, required for final delivery address validation.
BaseItem String Primary item associated with the outer packing unit, typically the main product being shipped in the package.
DeliveryId Long Unique identifier for the delivery associated with the outer packing unit, used for tracking and verifying shipments.
EndAssemblyItemNumber String Identifier for the end-assembly item associated with the outer packing unit, indicating the finished goods.
Finder String Search keyword or query used to locate records of the outer packing unit in the system, enhancing search functionality.
IntegrationStatus String Current status of integration for the outer packing unit, indicating if it is properly synchronized with external systems.
Item String The specific item being shipped in the outer packing unit, linked to the inventory system for tracking.
LineStatus String Current processing status of the line item in the outer packing unit, such as 'pending', 'shipped', or 'delivered'.
OrderNumber String Unique identifier for the order that initiated the shipment of the outer packing unit, linked to the sales order.
OrderType String Type of order associated with the shipment, such as 'purchase order' or 'sales order'.
OrderTypeCode String Abbreviation or code representing the type of order associated with the shipment.
PickWave String Identifier for the picking wave associated with the outer packing unit, used in warehouse operations for managing picking processes.
QuickShipStatus String Indicates if the shipment of the outer packing unit is expedited under a 'quick ship' process.
RcvShipmentLineId Long Identifier for the received shipment line in the outer packing unit, used to track the line item during receipt.
Shipment String Identifier for the shipment associated with the outer packing unit, used for overall tracking.
ShipmentSet String Grouping of shipments, often used to manage multiple shipments as part of a batch for processing.
ShipToCustomer String Customer receiving the outer packing unit, providing context for the recipient.
ShipToPartyId String Unique identifier for the ship-to party for the outer packing unit, used to verify the destination.
SourceOrder String Original source order number that this outer packing unit is fulfilling.
SourceOrderFulfillmentLine String Line number in the source order that is being fulfilled by this shipment.
SourceOrderFulfillmentLineId String Unique identifier for the source order fulfillment line associated with the outer packing unit.
SourceOrderLine String Line number in the original order that the outer packing unit is fulfilling.
SourceSystemId String Identifier for the source system from which this shipment's details originate.
TradeComplianceStatus String Status of trade compliance checks for the shipment of the outer packing unit, ensuring legal requirements are met.
TransportationPlanningStatus String Current status of transportation planning for the outer packing unit, helping to track the shipment's logistics phase.

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