JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHubtotalstotalComponents

SalesOrdersForOrderHubtotalstotalComponents

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHubtotalstotalComponents
TotalsOrderTotalId [KEY] Long TotalsOrderTotalId of SalesOrdersForOrderHubtotalstotalComponents
OrderTotalId Long OrderTotalId of SalesOrdersForOrderHubtotalstotalComponents
OrderTotalComponentId [KEY] Long OrderTotalComponentId of SalesOrdersForOrderHubtotalstotalComponents
OrderChargeComponentId Long OrderChargeComponentId of SalesOrdersForOrderHubtotalstotalComponents
HeaderCurrencyCode String HeaderCurrencyCode of SalesOrdersForOrderHubtotalstotalComponents
HeaderCurrencyName String HeaderCurrencyName of SalesOrdersForOrderHubtotalstotalComponents
HeaderCurrencyExtendedAmount Double HeaderCurrencyExtendedAmount of SalesOrdersForOrderHubtotalstotalComponents
PriceElementCode String PriceElementCode of SalesOrdersForOrderHubtotalstotalComponents
PriceElement String PriceElement of SalesOrdersForOrderHubtotalstotalComponents
PriceElementUsageCode String PriceElementUsageCode of SalesOrdersForOrderHubtotalstotalComponents
PriceElementUsage String PriceElementUsage of SalesOrdersForOrderHubtotalstotalComponents

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