JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SupplyRequestssupplyOrderLinesbuySupplydistributionDetails

SupplyRequestssupplyOrderLinesbuySupplydistributionDetails

Columns

Name Type Description
SupplyRequestsSupplyOrderReferenceNumber [KEY] String SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLinesbuySupplydistributionDetails
SupplyorderlinesSupplyLineId [KEY] Long SupplyorderlinesSupplyLineId of SupplyRequestssupplyOrderLinesbuySupplydistributionDetails
BuysupplySupplyTrackingLineId [KEY] Long BuysupplySupplyTrackingLineId of SupplyRequestssupplyOrderLinesbuySupplydistributionDetails
DistributionNumber String DistributionNumber of SupplyRequestssupplyOrderLinesbuySupplydistributionDetails
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