JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ShipmentTransactionRequestsshipmentsglobalDFF

ShipmentTransactionRequestsshipmentsglobalDFF

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentsglobalDFF
ShipmentsDeliveryInterfaceId [KEY] Long ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentsglobalDFF
DeliveryInterfaceId [KEY] Long DeliveryInterfaceId of ShipmentTransactionRequestsshipmentsglobalDFF
_FLEX_Context String __FLEX_Context of ShipmentTransactionRequestsshipmentsglobalDFF
_FLEX_Context_DisplayValue String __FLEX_Context_DisplayValue of ShipmentTransactionRequestsshipmentsglobalDFF

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Carrier String Carrier
ExternalSystemTransactionReference String ExternalSystemTransactionReference
FromActualShipDate Datetime FromActualShipDate
FromInitialShipDate Datetime FromInitialShipDate
Item String Item
ModeOfTransportCode String ModeOfTransportCode
Order String Order
PackingUnit String PackingUnit
ServiceLevelCode String ServiceLevelCode
ShipFromOrganizationCode String ShipFromOrganizationCode
Shipment String Shipment
ShipmentLine Long ShipmentLine
SoldToCustomer String SoldToCustomer
ToActualShipDate Datetime ToActualShipDate
ToInitialShipDate Datetime ToInitialShipDate
TransactionId Long TransactionId
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839