ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentTransactionRequestsshipmentsunpackedLinesserials

Maintains serial numbers for serial-controlled items in unpacked shipment lines, ensuring accurate tracking and management.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the shipment transaction request related to unpacked shipment line serials.
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 linked to serials.
TransactionInterfaceId [KEY] Long Unique identifier for the transaction interface associated with serialized items.
FromSerialNumber [KEY] String Starting serial number in a serialized range for an item under serial control.
ToSerialNumber String Ending serial number in a serialized range for an item under serial control.
Subinventory String Subinventory from which the item is fulfilled and shipped.
Locator String Concatenated inventory locator that provides the source location for shipped material.
CreatedBy String User or system process that created the unpacked shipment line serial record.
CreationDate Datetime Date and time when the serial record was created.
LastUpdatedBy String User or system process that last updated the unpacked shipment line serial record.
LastUpdateDate Datetime Date and time when the serial record was last updated.
Errors String Details of any errors encountered during processing of serial numbers.
AttributeDFF String Descriptive flexfield (DFF) attributes associated with the serialized shipment line.
StandardDFF String Standard flexfield attributes associated with the serialized shipment line.
Carrier String Name of the carrier responsible for transporting the serialized shipment.
ExternalSystemTransactionReference String Reference to the transaction in an external system.
Finder String Searchable reference field for locating serialized shipment 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 serialized item associated with the shipment.
ModeOfTransportCode String Code representing the mode of transport (for example, air, sea, land).
Order String Order number linked to the shipment containing this serial number.
PackingUnit String Packing unit associated with the serialized unpacked shipment.
ServiceLevelCode String Shipping service level code associated with the serialized shipment.
ShipFromOrganizationCode String Code identifying the organization that ships the serialized item.
Shipment String Unique identifier for the shipment containing the serialized item.
ShipmentLine Long Unique identifier for the shipment line associated with this serial number.
SoldToCustomer String Customer to whom the serialized shipment 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 serialized shipment record to the transaction request.

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