JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinescoveredProductReferences

SalesOrdersForOrderHublinescoveredProductReferences

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinescoveredProductReferences
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinescoveredProductReferences
SourceOrderId String SourceOrderId of SalesOrdersForOrderHublinescoveredProductReferences
SourceOrderNumber String SourceOrderNumber of SalesOrdersForOrderHublinescoveredProductReferences
SourceOrderSystem String SourceOrderSystem of SalesOrdersForOrderHublinescoveredProductReferences
OrderNumber String OrderNumber of SalesOrdersForOrderHublinescoveredProductReferences
DisplayLineNumber String DisplayLineNumber of SalesOrdersForOrderHublinescoveredProductReferences
SourceLineId String SourceLineId of SalesOrdersForOrderHublinescoveredProductReferences
SourceLineNumber String SourceLineNumber of SalesOrdersForOrderHublinescoveredProductReferences
CoveredItemNumber String CoveredItemNumber of SalesOrdersForOrderHublinescoveredProductReferences
CoveredFulfillLineId Long CoveredFulfillLineId of SalesOrdersForOrderHublinescoveredProductReferences
HeaderId Long HeaderId of SalesOrdersForOrderHublinescoveredProductReferences

Pseudo-Columns

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

Name Type Description
FromDate Date FromDate
OrderKey String OrderKey
SourceTransactionNumber String SourceTransactionNumber
SourceTransactionSystem String SourceTransactionSystem
ToDate Date ToDate
Finder String finder

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