JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ShipmentTransactionRequestsshipmentsouterPackingUnitsDFF

ShipmentTransactionRequestsshipmentsouterPackingUnitsDFF

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentsouterPackingUnitsDFF
ShipmentsDeliveryInterfaceId [KEY] Long ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentsouterPackingUnitsDFF
OuterpackingunitsLPNInterfaceId [KEY] Long OuterpackingunitsLPNInterfaceId of ShipmentTransactionRequestsshipmentsouterPackingUnitsDFF
LPNInterfaceId [KEY] Long Value that uniquely identifies the candidate packing unit.
_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