JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHubholds

SalesOrdersForOrderHubholds

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHubholds
HoldInstanceId [KEY] Long HoldInstanceId of SalesOrdersForOrderHubholds
HoldName String HoldName of SalesOrdersForOrderHubholds
HoldCode String HoldCode of SalesOrdersForOrderHubholds
HoldComments String HoldComments of SalesOrdersForOrderHubholds
ApplyUser String ApplyUser of SalesOrdersForOrderHubholds
ApplyDate Datetime ApplyDate of SalesOrdersForOrderHubholds
HoldReleaseComments String HoldReleaseComments of SalesOrdersForOrderHubholds
HoldReleaseReasonCode String HoldReleaseReasonCode of SalesOrdersForOrderHubholds
HoldReleaseReason String HoldReleaseReason of SalesOrdersForOrderHubholds
ReleaseUser String ReleaseUser of SalesOrdersForOrderHubholds
ReleaseDate Datetime ReleaseDate of SalesOrdersForOrderHubholds
ApplySystem String ApplySystem of SalesOrdersForOrderHubholds
ActiveFlag Bool ActiveFlag of SalesOrdersForOrderHubholds
SourceRequestId String SourceRequestId of SalesOrdersForOrderHubholds

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