JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SupplyRequestssupplyOrderLinestransferSupplydistributionDetails

SupplyRequestssupplyOrderLinestransferSupplydistributionDetails

Columns

Name Type Description
SupplyRequestsSupplyOrderReferenceNumber [KEY] String SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLinestransferSupplydistributionDetails
SupplyorderlinesSupplyLineId [KEY] Long SupplyorderlinesSupplyLineId of SupplyRequestssupplyOrderLinestransferSupplydistributionDetails
TransfersupplySupplyTrackingLineId [KEY] Long TransfersupplySupplyTrackingLineId of SupplyRequestssupplyOrderLinestransferSupplydistributionDetails
DistributionNumber String DistributionNumber of SupplyRequestssupplyOrderLinestransferSupplydistributionDetails
ProjectDFF String projectDFF

Pseudo-Columns

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

Name Type Description
SupplyOrderReferenceNumber String SupplyOrderReferenceNumber
BindDestOrganizationCode String bindDestOrganizationCode
BindDocumentNumber String bindDocumentNumber
BindItemNumber String bindItemNumber
BindNeedByDate Datetime bindNeedByDate
BindSupplyOrderNumber String bindSupplyOrderNumber
BindSupplyOrderReferenceNumber String bindSupplyOrderReferenceNumber
BindSupplyOrderSource String bindSupplyOrderSource
BindSupplyRequestDate Datetime bindSupplyRequestDate
BindSupplyStatus String bindSupplyStatus
BindSupplyType String bindSupplyType
Finder String finder

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