JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionProjectDFFs

TransferOrderstransferOrderLinestransferOrderDistributionstransferOrderDistributionProjectDFFs

Columns

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

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