ItemsV2ItemRevisionItemRevisionTranslation
ItemsV2ItemRevisionItemRevisionTranslation
Columns
Name | Type | Description |
ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemRevisionItemRevisionTranslation |
ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemRevisionItemRevisionTranslation |
ItemrevisionInventoryItemId [KEY] | Long | ItemrevisionInventoryItemId of ItemsV2ItemRevisionItemRevisionTranslation |
ItemrevisionOrganizationId [KEY] | Long | ItemrevisionOrganizationId of ItemsV2ItemRevisionItemRevisionTranslation |
ItemrevisionRevisionId [KEY] | Long | ItemrevisionRevisionId of ItemsV2ItemRevisionItemRevisionTranslation |
RevisionId [KEY] | Long | An unique identifier of a revision. |
Description | String | An attribute value that is the description for the item revision. |
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 revision. |
LastUpdateDateTime | Datetime | Who column: An attribute which indicates the date and time of the last update of the item revision. |
CreatedBy | String | Who column: An attribute which indicates the user that created the item revision translation. |
LastUpdateLogin | String | Who column: An attribute which indicates the user that logged in last for the item revision translation |
LastUpdatedBy | String | Who column: An attribute which indicates the user that last updated the item revision 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 |
ItemId | Long | ItemId |
ItemNumber | String | ItemNumber |
OrganizationCode | String | OrganizationCode |
OrganizationId | Long | OrganizationId |
VersionId | Long | VersionId |
Finder | String | finder |