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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
AcdType | String | AcdType |
ChangeLineId | Long | ChangeLineId |
InventoryOrganizationId | Long | InventoryOrganizationId |
ItemNumber | String | ItemNumber |
OrganizationCode | String | OrganizationCode |
VersionId | Long | VersionId |
Finder | String | finder |