JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryTransactionTypes

InventoryTransactionTypes

Columns

Name Type Description
TransactionTypeId [KEY] Long TransactionTypeId of InventoryTransactionTypes
TransactionTypeName String TransactionTypeName of InventoryTransactionTypes
TransactionTypeDescription String TransactionTypeDescription of InventoryTransactionTypes
TransactionActionId String TransactionActionId of InventoryTransactionTypes
TransactionAction String TransactionAction of InventoryTransactionTypes
TransactionTypeDefinedByCode String TransactionTypeDefinedByCode of InventoryTransactionTypes
TransactionTypeDefinedBy String TransactionTypeDefinedBy of InventoryTransactionTypes
TransactionTypeStartDate Date TransactionTypeStartDate of InventoryTransactionTypes
TransactionTypeEndDate Date TransactionTypeEndDate of InventoryTransactionTypes
TransactionSourceTypeId Long TransactionSourceTypeId of InventoryTransactionTypes
TransactionSourceTypeName String TransactionSourceTypeName of InventoryTransactionTypes
TransactionSourceTypeDescription String TransactionSourceTypeDescription of InventoryTransactionTypes
TransactionSourceTypeDefinedByCode String TransactionSourceTypeDefinedByCode of InventoryTransactionTypes
TransactionSourceTypeDefinedBy String TransactionSourceTypeDefinedBy of InventoryTransactionTypes
TransactionSourceTypeStartDate Date TransactionSourceTypeStartDate of InventoryTransactionTypes
TransactionSourceTypeEndDate Date TransactionSourceTypeEndDate of InventoryTransactionTypes

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
BindTransactionTypeDescription String bindTransactionTypeDescription
BindTransactionTypeName String bindTransactionTypeName
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839