JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinescoverageReferences

SalesOrdersForOrderHublinescoverageReferences

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinescoverageReferences
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinescoverageReferences
OrderNumber String OrderNumber of SalesOrdersForOrderHublinescoverageReferences
SourceOrderNumber String SourceOrderNumber of SalesOrdersForOrderHublinescoverageReferences
SourceLineNumber String SourceLineNumber of SalesOrdersForOrderHublinescoverageReferences
DisplayLineNumber String DisplayLineNumber of SalesOrdersForOrderHublinescoverageReferences
CoverageItemNumber String CoverageItemNumber of SalesOrdersForOrderHublinescoverageReferences
CoverageFulfillLineId Long CoverageFulfillLineId of SalesOrdersForOrderHublinescoverageReferences
HeaderId Long HeaderId of SalesOrdersForOrderHublinescoverageReferences

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