CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentTransactionRequestsshipmentsunpackedLineslots

Tracks lot numbers associated with items in unpacked shipment lines, enabling traceability for lot-controlled inventory.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the shipment transaction request related to unpacked shipment line lots.
ShipmentsDeliveryInterfaceId [KEY] Long Identifier for the interface managing shipment delivery in the transaction request.
UnpackedlinesDeliveryDetailInterfaceId [KEY] Long Unique identifier for the unpacked shipment line delivery details with lot tracking.
TransactionInterfaceId [KEY] Long Unique identifier for the transaction interface associated with the shipment lot.
Lot [KEY] String Lot number assigned to the item, used when the warehouse manages inventory with lot control.
Subinventory String Subinventory where the item is stored before being shipped.
Locator String Inventory locator path that specifies the exact location of the item within the warehouse.
Quantity Decimal Total quantity of the item allocated to this lot for shipment.
SecondaryQuantity Decimal Secondary unit of measure (UOM) quantity for the item in this lot.
CreatedBy String User or system process that created the unpacked shipment line lot record.
CreationDate Datetime Date and time when the lot record was created.
LastUpdatedBy String User or system process that last updated the unpacked shipment line lot record.
LastUpdateDate Datetime Date and time when the lot record was last updated.
Errors String Details of any errors encountered during lot processing for the unpacked shipment line.
Serials String Serialized tracking information linked to the lot for traceability.
Carrier String Name of the carrier responsible for transporting the shipment.
ExternalSystemTransactionReference String Reference to the transaction in an external system.
Finder String Searchable reference field for locating shipment lot records.
FromActualShipDate Datetime Start date range for the actual shipment departure.
FromInitialShipDate Datetime Start date range for the initially planned shipment departure.
Item String Name of the item associated with this lot.
ModeOfTransportCode String Code representing the mode of transport (for example, air, sea, land).
Order String Order number linked to the shipment containing this lot.
PackingUnit String Packing unit associated with the lot in the unpacked shipment.
ServiceLevelCode String Shipping service level code associated with the shipment lot.
ShipFromOrganizationCode String Code identifying the organization that ships the item.
Shipment String Unique identifier for the shipment containing this lot.
ShipmentLine Long Unique identifier for the shipment line associated with this lot.
SoldToCustomer String Customer to whom the shipment lot is sold.
ToActualShipDate Datetime End date range for the actual shipment arrival.
ToInitialShipDate Datetime End date range for the initially planned shipment arrival.
TransactionId Long Unique transaction ID linking this shipment lot record to the transaction request.

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