JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinespriceAdjustments

SalesOrdersForOrderHublinespriceAdjustments

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinespriceAdjustments
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinespriceAdjustments
PriceAdjustmentId [KEY] Long PriceAdjustmentId of SalesOrdersForOrderHublinespriceAdjustments
AdjustmentName String AdjustmentName of SalesOrdersForOrderHublinespriceAdjustments
Amount Double Amount of SalesOrdersForOrderHublinespriceAdjustments
AdjustmentTypeCode String AdjustmentTypeCode of SalesOrdersForOrderHublinespriceAdjustments
AdjustmentType String AdjustmentType of SalesOrdersForOrderHublinespriceAdjustments
InvoicedFlag Bool InvoicedFlag of SalesOrdersForOrderHublinespriceAdjustments
OrigSystemAdjustmentReference String OrigSystemAdjustmentReference of SalesOrdersForOrderHublinespriceAdjustments

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