JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinesholds

SalesOrdersForOrderHublinesholds

Columns

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

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