ODBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9434

ShipmentTransactionRequestsshipmentsshipmentDFF

Captures additional user-defined details for shipments using descriptive flexfields (DFFs) to enhance shipment data customization.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the shipment transaction request related to shipment DFFs.
ShipmentsDeliveryInterfaceId [KEY] Long Identifier for the interface managing shipment delivery within the transaction request.
DeliveryInterfaceId [KEY] Long Unique identifier for the shipment candidate being processed.
_FLEX_Context String Name of the DFF context that applies to this shipment.
_FLEX_Context_DisplayValue String Display value of the DFF context for shipments.
Carrier String Name of the carrier responsible for transporting the shipment.
ExternalSystemTransactionReference String Reference to the shipment transaction in an external system.
Finder String Searchable reference field for locating the shipment transaction.
FromActualShipDate Datetime Start date range for when the shipment was actually shipped.
FromInitialShipDate Datetime Start date range for the initially planned shipment date.
Item String Name of the item included in the shipment.
ModeOfTransportCode String Code representing the mode of transport (for example, air, sea, land).
Order String Order number associated with the shipment.
PackingUnit String Packing unit associated with the shipment.
ServiceLevelCode String Code representing the shipping service level (for example, standard, express).
ShipFromOrganizationCode String Code identifying the organization shipping the items.
Shipment String Unique identifier for the shipment.
ShipmentLine Long Unique identifier for a specific shipment line.
SoldToCustomer String Customer to whom the shipment is sold.
ToActualShipDate Datetime End date range for the actual shipment date.
ToInitialShipDate Datetime End date range for the initially planned shipment date.
TransactionId Long Unique transaction ID linking this shipment data to the shipment transaction request.

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