JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ShipmentTransactionRequestsshipmentsunpackedLinesDFF

ShipmentTransactionRequestsshipmentsunpackedLinesDFF

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentsunpackedLinesDFF
ShipmentsDeliveryInterfaceId [KEY] Long ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLinesDFF
UnpackedlinesDeliveryDetailInterfaceId [KEY] Long UnpackedlinesDeliveryDetailInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLinesDFF
DeliveryDetailInterfaceId [KEY] Long Value that uniquely identifies the candidate shipment line.
_FLEX_Context String Descriptive flexfield context name.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value.

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