ItemsV2ItemRevision
ItemsV2ItemRevision
Columns
Name | Type | Description |
ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemRevision |
ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemRevision |
RevisionId [KEY] | Long | An unique identifier of a revision. |
ItemId | 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. |
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. |
RevisionCode | String | An attribute value that represents a revision. |
ItemRevisionDescription | String | The description for on item revision. |
RevisionReasonValue | String | An attribute value that represents the reason for a revision. |
EffectivityDate | Datetime | Revision effectively date |
ImplementationDate | Datetime | Date and time when the revision was implemented. |
EndEffectivityDate | Datetime | Date and time when the effectivity of the revision ends. |
RevisionExtensibleFlexfieldCategoryCode | String | An attribute value for the EFF category code for the Item revision. |
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. |
LastUpdateLogin | String | Who column: An attribute which indicates the user that logged in last for the item revision |
LastUpdatedBy | String | Who column: An attribute which indicates the user that last updated the item revision |
RequestId | Long | This is the request id generated at import. Its use case is to verify import, the items will be published based on RequestID. |
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 |