JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs

TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs

Columns

Name Type Description
TransferOrdersHeaderId [KEY] Long TransferOrdersHeaderId of TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs
TransferorderlinesLineId [KEY] Long TransferorderlinesLineId of TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs
TransferorderdistributionsDistributionId [KEY] Long TransferorderdistributionsDistributionId of TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs
DistributionId [KEY] Long DistributionId of TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs
_FLEX_Context String __FLEX_Context of TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs
_FLEX_Context_DisplayValue String __FLEX_Context_DisplayValue of TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionDFFs

Pseudo-Columns

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

Name Type Description
HeaderId Long HeaderId
Finder String finder
PBatch String pBatch
PDestinationOrganization String pDestinationOrganization
PItemNumber String pItemNumber
PLineNumber String pLineNumber
PLineStatus String pLineStatus
PScheduledShipDate Datetime pScheduledShipDate
PSourceOrganization String pSourceOrganization
PTransactionOrigin String pTransactionOrigin
PTransferOrder String pTransferOrder

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