JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryCompletedTransactionsserials

InventoryCompletedTransactionsserials

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId [KEY] Long InventoryCompletedTransactionsTransactionId of InventoryCompletedTransactionsserials
SerialNumber [KEY] String SerialNumber of InventoryCompletedTransactionsserials
SupplierSerialNumber String SupplierSerialNumber of InventoryCompletedTransactionsserials

Pseudo-Columns

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

Name Type Description
TransactionId Long TransactionId
BindInventoryItemId Long bindInventoryItemId
BindItem String bindItem
BindOrganization String bindOrganization
BindOrganizationId Long bindOrganizationId
BindPJCProjectId String bindPJCProjectId
BindPJCProjectNumber String bindPJCProjectNumber
BindPJCTaskId String bindPJCTaskId
BindPJCTaskNumber String bindPJCTaskNumber
BindTransactionDate Datetime bindTransactionDate
BindTransactionId Long bindTransactionId
Finder String finder

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