ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentTransactionRequestsshipmentsouterPackingUnitsDFF

Stores additional custom attributes for outer packing units to capture user-defined information about shipping costs.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the shipment transaction request associated with outer packing unit descriptive flexfields (DFFs).
ShipmentsDeliveryInterfaceId [KEY] Long Identifier for the interface managing shipment delivery within the transaction request.
OuterpackingunitsLPNInterfaceId [KEY] Long Unique identifier for the License Plate Number (LPN) associated with the outer packing unit.
LPNInterfaceId [KEY] Long Unique identifier for the specific packing unit being processed.
_FLEX_Context String Context name for the DFF, used to categorize additional attributes.
_FLEX_Context_DisplayValue String Display value for the DFF context, providing a human-readable label.
Carrier String Name of the carrier responsible for transporting the shipment.
ExternalSystemTransactionReference String Reference ID linking the transaction request to an external system.
Finder String Searchable reference field for locating specific shipment records.
FromActualShipDate Datetime Start date range for the actual shipment date associated with the packing unit.
FromInitialShipDate Datetime Start date range for the originally planned shipment date.
Item String Identifier or name of the item associated with the outer packing unit.
ModeOfTransportCode String Code representing the mode of transport for the shipment (for example, air, sea, land).
Order String Order number associated with the shipment.
PackingUnit String Unique identifier or name of the packing unit containing 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 Customer to whom the shipment is sold.
ToActualShipDate Datetime End date range for the actual shipment date associated with the packing unit.
ToInitialShipDate Datetime End date range for the originally planned shipment date.
TransactionId Long Unique transaction ID linking this DFF data to the shipment transaction request.

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