JDBC Driver for Oracle SCM

Build 22.0.8462

ItemsV2ItemRevision

The Item Revisions resource manages item revision details.

Columns

Name Type Description
ItemsV2ItemId String ItemsV2ItemId of ItemsV2ItemRevision
ItemsV2OrganizationId String ItemsV2OrganizationId of ItemsV2ItemRevision
RevisionId String An unique identifier of a revision.
ItemId String 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 String 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 String This is the request id generated at import. Its use case is to verify import, the items will be published based on RequestID.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462