JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinesoriginalOrderReference

SalesOrdersForOrderHublinesoriginalOrderReference

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinesoriginalOrderReference
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalOrderNumber String OriginalOrderNumber of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalSourceOrderNumber String OriginalSourceOrderNumber of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalSourceLineNumber String OriginalSourceLineNumber of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalFulfillLineId Long OriginalFulfillLineId of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalHeaderId Long OriginalHeaderId of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalItemNumber String OriginalItemNumber of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalSourceOrderId String OriginalSourceOrderId of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalSourceLineId String OriginalSourceLineId of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalSourceOrderSystem String OriginalSourceOrderSystem of SalesOrdersForOrderHublinesoriginalOrderReference
OriginalItemLineNumber String OriginalItemLineNumber of SalesOrdersForOrderHublinesoriginalOrderReference

Pseudo-Columns

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

Name Type Description
FromDate Date FromDate
HeaderId String HeaderId
OrderKey String OrderKey
OrderNumber String OrderNumber
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