JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinestransactionItemAttributes

SalesOrdersForOrderHublinestransactionItemAttributes

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinestransactionItemAttributes
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinestransactionItemAttributes
CharacterAttributeValue String Character value for the transaction item attribute (TIA).
DateAttributeValue Date Date value for the transaction item attribute (TIA).
NumberAttributeValue Double Number value for the transaction item attribute (TIA).
SourceTransactionLineAttributeId String Value that uniquely identifies the transaction item attribute on the fulfillment line. The source application assigns this value.
TimestampAttributeValue Datetime Time value for the transaction item attribute (TIA).
TransactionAttributeId [KEY] Long TransactionAttributeId of SalesOrdersForOrderHublinestransactionItemAttributes
TransactionAttributeName String Name of the transaction item attribute.
TransactionAttributeMetadataid Long Value that identifies the transaction item attribute (TIA) that stores the metadata.
TransactionItemAttributeId Long Value that identifies the transaction item attribute (TIA).

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