JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ItemsV2ItemDFF

ItemsV2ItemDFF

Columns

Name Type Description
ItemsV2ItemId [KEY] Long ItemsV2ItemId of ItemsV2ItemDFF
ItemsV2OrganizationId [KEY] Long ItemsV2OrganizationId of ItemsV2ItemDFF
InventoryItemId [KEY] Long Value that uniquely identifies the part, item, product, or service.
OrganizationId [KEY] Long Value that uniquely identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
_FLEX_Context String Descriptive flexfield context name for items.
_FLEX_Context_DisplayValue String Context

Pseudo-Columns

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

Name Type Description
AcdType String AcdType
ChangeLineId Long ChangeLineId
InventoryOrganizationId Long InventoryOrganizationId
ItemId Long ItemId
ItemNumber String ItemNumber
OrganizationCode String OrganizationCode
VersionId Long VersionId
Finder String finder

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