CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentTransactionRequestsshipmentsouterPackingUnits

Manages detailed information about the outer packing units used in shipment processing, including their structure and relationship to shipment contents.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the shipment transaction request associated with outer packing units.
ShipmentsDeliveryInterfaceId [KEY] Long Identifier for the interface managing shipment delivery within the transaction request.
LPNInterfaceId [KEY] Long Unique identifier for the License Plate Number (LPN) interface handling packing units.
PackingUnit String Name or identifier of the outer packing unit used for shipment.
TrackingNumber String Unique tracking number assigned to the packing unit for shipment tracking.
MasterSerialNumber String Serial number that uniquely identifies the outer packing unit.
SealNumber String Security seal number used to verify that the packing unit remains unopened during transport.
PackingUnitType String Type of packing unit used to contain and protect the shipped items.
FOBCode String Code representing the ownership of items in transit, defined in the Freight on Board (FOB) lookup type.
Volume Decimal Total volume capacity of the packing unit.
VolumeUOMCode String Code representing the unit of measure (UOM) for the packing unit's volume.
VolumeUOM String UOM used to specify the packing unit's volume (for example, cubic meters, liters).
GrossWeight Decimal Total weight of the packing unit including its contents.
GrossWeightUOMCode String Code representing the UOM for the gross weight of the packing unit.
GrossWeightUOM String UOM used to specify the gross weight (for example, kilograms, pounds).
TareWeight Decimal Weight of the empty packing unit, excluding its contents.
TareWeightUOMCode String Code representing the UOM for the tare weight of the packing unit.
TareWeightUOM String UOM used to specify the tare weight (for example, kilograms, pounds).
CreatedBy String User or system identifier that created the packing unit record.
CreationDate Datetime Timestamp when the packing unit record was created.
LastUpdatedBy String User or system identifier that last updated the packing unit record.
LastUpdateDate Datetime Timestamp when the packing unit record was last modified.
Carrier String Name of the carrier responsible for transporting the shipment.
ExternalSystemTransactionReference String Reference ID linking the shipment transaction to an external system.
Finder String Reference field used to search for specific shipment records.
FromActualShipDate Datetime Start date range for the actual shipment date in the transaction request.
FromInitialShipDate Datetime Start date range for the initially planned shipment date.
Item String Identifier or name of the item associated with the packing unit.
ModeOfTransportCode String Code representing the mode of transport used for shipping (for example, air, sea, land).
Order String Order number associated with the shipment.
ServiceLevelCode String Code representing the level of service for the shipment (for example, express, standard).
ShipFromOrganizationCode String Code identifying the organization location from which the shipment originates.
Shipment String Unique identifier or name of the shipment.
ShipmentLine Long Line number corresponding to a specific item in the shipment.
SoldToCustomer String Name of the customer to whom the shipment is sold.
ToActualShipDate Datetime End date range for the actual shipment date in the transaction request.
ToInitialShipDate Datetime End date range for the initially planned shipment date.
TransactionId Long Unique transaction ID linking this packing unit record to the shipment transaction request.

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