CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ShipmentsouterPackingUnitsinnerPackingUnits

Records details about inner packing units contained within outer packing units, supporting hierarchical packing structures.

Columns

Name Type Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the outer packing unit and inner packing unit in a shipment, used for tracking delivery progress.
OuterpackingunitsLPNId [KEY] Long License Plate Number (LPN) identifier for the outer packing unit, used for tracking and managing the packaging in the warehouse or during shipment.
LPNId [KEY] Long LPN identifier for the inner packing unit, used to uniquely identify and track smaller units inside the outer packing unit.
LicensePlateNumber String LPN assigned to the packing unit (either outer or inner), used to track and manage shipment packaging.
TrackingNumber String Tracking number assigned to the inner packing unit, which is used for monitoring and tracking the movement of the unit in transit.
MasterSerialNumber String Master serial number assigned to the inner packing unit, used to track individual items in the unit or to verify items during shipment.
SealNumber String Seal number assigned to the packing unit for security and integrity, ensuring that the unit remains unaltered during transportation.
InventoryItemId Long Identifier for the inventory item within the packing unit, linking the item to the product catalog and inventory system.
ContainerItem String Item contained in the packing unit, used for classifying and identifying the contents of the inner packing unit.
ContainerItemDescription String Description of the container item, providing further details about the product or material inside the packing unit.
ContainerVolume Decimal Volume of the container (inner packing unit) in the shipment, used for determining storage space and calculating shipping costs.
ContainerVolumeUOMCode String Code for the unit of measure (UOM) used for the container volume, such as cubic meters or liters, helping standardize volume measurement.
ContainerVolumeUOM String UOM for the volume of the container, specifying how the container volume is quantified (for example, cubic meters, liters).
FOBCode String Code representing the Free On Board (FOB) terms for the shipment, indicating who is responsible for the shipping cost and when ownership is transferred.
FOB String Free On Board (FOB) terms for the shipment, providing clarity on the responsibilities and costs for shipping and handling the goods.
GrossWeight Decimal Total weight of the packing unit, including both the contents and the packaging, used for freight and shipping cost calculation.
GrossWeightUOMCode String Code for the UOM used for the gross weight, such as kilograms or pounds, ensuring consistency in weight reporting.
GrossWeightUOM String UOM for the gross weight of the packing unit, specifying how the total weight is expressed (for example, kg, lbs).
TareWeight Decimal Weight of the packaging material alone, used to calculate the net weight by subtracting the tare weight from the gross weight.
TareWeightUOMCode String Code for the UOM used for tare weight, such as kilograms or pounds, ensuring consistency when calculating shipping costs.
TareWeightUOM String UOM for the tare weight of the packing unit, indicating how the weight of the packaging is quantified.
NetWeight Decimal The weight of the actual contents of the packing unit, calculated by subtracting the tare weight from the gross weight.
NetWeightUOMCode String Code for the UOM used for net weight, helping ensure consistent weight measurements for goods.
NetWeightUOM String UOM for the net weight, expressing the weight of the actual goods inside the packing unit (for example, kg, lbs).
PackingUnitCategoryCode String Code for the category of the packing unit, used to classify different types of packing based on their size, contents, or other attributes.
PackingUnitCategory String Category for the packing unit, classifying it according to its type (for example, box, crate, pallet) or contents.
UnitHeight Decimal Height of the packing unit, providing essential information for stacking and storage in the warehouse or during transit.
UnitLength Decimal Length of the packing unit, used to calculate storage space requirements and optimize shipping arrangements.
UnitWidth Decimal Width of the packing unit, required for calculating overall packing dimensions and for storage in warehouse systems.
DimensionUOMCode String Code for the UOM used for the dimensions of the packing unit, ensuring consistency in measurements.
DimensionUOM String UOM for the dimensions of the packing unit, specifying how the length, width, and height are expressed (for example, cm, inches).
ParentLPNId Long LPN identifier for the parent packing unit, linking inner packing units to their respective outer packing units for tracking.
ParentPackingUnit String Parent packing unit identifier, referring to the outer packaging that contains the inner packing unit for organizational purposes.
OutermostPackingUnitId Long Identifier for the outermost packing unit, used to track the largest level of packaging in the shipment.
OutermostPackingUnit String Name or identifier for the outermost packing unit, which encapsulates all smaller units or items within a shipment.
PercentageFilled Long Percentage of the packing unit's capacity that is filled with goods, helping to track how efficiently space is utilized.
VolumeFilled Long Volume of the packing unit that is filled with goods, used for tracking how much space is occupied in relation to the total available volume.
ShipFromLocationId Long Identifier for the location from which the shipment is being sent, used to organize logistics and track goods from origin.
ShipToLocationId Long Identifier for the location to which the shipment is being delivered, used for managing destination points in the logistics chain.
CarrierId Long Unique identifier for the carrier responsible for transporting the packing unit, used for tracking shipment responsibility.
Carrier String Name of the carrier responsible for shipping the packing unit, allowing for identification and coordination of logistics.
CarrierNumber String Carrier's identification number assigned to the shipment for tracking and coordination purposes.
ServiceLevelCode String Code for the service level used for the shipment, indicating the speed and type of service (for example, standard, expedited).
ServiceLevel String Description of the service level for the shipment, specifying the type of shipping service (for example, next-day delivery, standard shipping).
ModeOfTransportCode String Code representing the mode of transport used for the shipment (for example, truck, air, sea).
ModeOfTransport String Description of the mode of transport for the shipment, specifying how goods are being moved (for example, air freight, ground transport).
ShipFromAddress1 String First line of the address for the location from which the shipment is being dispatched.
ShipFromAddress2 String Second line of the address for the shipment origin, used for more detailed address information.
ShipFromAddress3 String Third line of the address for the shipment origin, providing additional address details.
ShipFromAddress4 String Fourth line of the address for the shipment origin, completing the full address details.
ShipFromCity String City from which the shipment is being sent, used for geographic identification and planning.
ShipFromCounty String County or district from which the shipment is dispatched, used for addressing and logistical routing.
ShipFromState String State or province from which the shipment originates, important for geographic and regulatory compliance.
ShipFromRegion String Region from which the shipment is dispatched, used for grouping deliveries by broader areas.
ShipFromCountry String Country from which the shipment is being sent, used for international logistics and customs processing.
ShipFromPostalCode String Postal code of the shipment origin, important for accurate delivery routing.
ShipToAddress1 String First line of the address for the location where the shipment is being delivered.
ShipToAddress2 String Second line of the address for the shipment destination.
ShipToAddress3 String Third line of the address for the shipment destination, providing further address details.
ShipToAddress4 String Fourth line of the address for the shipment destination.
ShipToCity String City where the shipment is being delivered, essential for geographic routing.
ShipToCounty String County or district where the shipment is being delivered.
ShipToState String State or province where the shipment destination is located.
ShipToRegion String Region to which the shipment is being delivered.
ShipToCountry String Country to which the shipment is being sent.
ShipToPostalCode String Postal code for the delivery address of the shipment.
BaseItem String Primary item associated with the packing unit for shipment, typically the most relevant product in the shipment.
DeliveryId Long Identifier for the delivery associated with the packing unit.
EndAssemblyItemNumber String Assembly item number of the end product, useful for tracking the completion of product assembly.
Finder String Search keyword or reference used to find the packing unit in the system.
IntegrationStatus String Current status of the integration for the packing unit, ensuring the packing unit data is synchronized with other systems.
Item String Specific item or product linked to the packing unit for tracking and management.
LineStatus String Status of the line item for the packing unit, indicating whether it is in progress, shipped, or delivered.
OrderNumber String Order number linked to the packing unit, ensuring it corresponds with the sales order.
OrderType String Type of order linked to the packing unit, such as a sales order or a purchase order.
OrderTypeCode String Code representing the type of order for the packing unit.
PickWave String Identifier for the pick wave assigned to the packing unit, helping in warehouse picking and packing activities.
QuickShipStatus String Indicates if the packing unit is subject to expedited shipping, ensuring fast processing.
RcvShipmentLineId Long Line identifier for the received shipment associated with the packing unit.
Shipment String Identifier for the shipment, used for organizing and tracking the entire shipment process.
ShipmentSet String Shipment set identifier for organizing related shipments together.
ShipToCustomer String Customer receiving the packing unit, useful for shipment destination tracking.
ShipToPartyId String Unique identifier for the party receiving the packing unit.
SourceOrder String Source order identifier for the packing unit.
SourceOrderFulfillmentLine String Fulfillment line for the source order of the packing unit.
SourceOrderFulfillmentLineId String Unique identifier for the source order fulfillment line.
SourceOrderLine String Line number for the source order associated with the packing unit.
SourceSystemId String Identifier for the system that originated the source order data.
TradeComplianceStatus String Status of trade compliance for the packing unit, ensuring compliance with international regulations.
TransportationPlanningStatus String Current status of transportation planning for the packing unit, helping to track the logistics process.

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