JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinessalesCredits

SalesOrdersForOrderHublinessalesCredits

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinessalesCredits
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinessalesCredits
SalesCreditId [KEY] Long SalesCreditId of SalesOrdersForOrderHublinessalesCredits
SalespersonId Long Value that identifies the person who sold the item.
Salesperson String Name of person who sold the item.
Percent Double Value that specifies the sales credit percent for the salesperson.
SalesCreditTypeId Long Value that identifies the sales credit type.
SalesCreditType String Name of the sales credit type.
SourceTransactionSalesCreditIdentifier String Value that uniquely identifies the sales credit. The source application assigns this value.

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