JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ItemsV2ItemTranslation

ItemsV2ItemTranslation

Columns

Name Type Description
ItemsV2ItemId [KEY] Long ItemsV2ItemId of ItemsV2ItemTranslation
ItemsV2OrganizationId [KEY] Long ItemsV2OrganizationId of ItemsV2ItemTranslation
OrganizationId [KEY] Long An unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
ItemId [KEY] Long An unique identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.
ItemDescription String An attribute value that is the description for the item.
LongDescription String An attribute value that is the long description for the item consisting of a statement, picture in words, or account that describes the item.
HTMLLongDescription String Formated description in Rich or HTML text.
Language [KEY] String The languages that the worker speaks (will show flags representing languages spoken/understood).
SourceLanguage String Source language from which the translations are copied from.
CreationDateTime Datetime Who column: An attribute that indicates the date and time of the creation of the item translation.
LastUpdateDateTime Datetime Who column: An attribute which indicates the date and time of the last update of the item translation.

Pseudo-Columns

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

Name Type Description
AcdType String AcdType
ChangeLineId Long ChangeLineId
InventoryOrganizationId Long InventoryOrganizationId
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