JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ItemsV2ItemRevision

The Item Revisions resource manages item revision details.

Columns

Name Type Description
ItemsV2ItemId [KEY] Long ItemsV2ItemId of ItemsV2ItemRevision
ItemsV2OrganizationId [KEY] Long ItemsV2OrganizationId of ItemsV2ItemRevision
RevisionId [KEY] Long Value that uniquely identifies the revision of the item.
ItemId Long Value that uniquely identifies the part, item, product, or service.
OrganizationId [KEY] Long OrganizationId of ItemsV2ItemRevision
RevisionCode String Value that identifies the revision.
ItemRevisionDescription String Description of the item revision.
RevisionReasonValue String Reason for the revision. A list of accepted values is defined in the lookup type ORA_EGP_SAFETY_STK_PLN_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
EffectivityDate Datetime Date when the revision goes into effect.
ImplementationDate Datetime ImplementationDate of ItemsV2ItemRevision
EndEffectivityDate Datetime EndEffectivityDate of ItemsV2ItemRevision
RevisionExtensibleFlexfieldCategoryCode String Abbreviation that identifies the item class associated with the item revision extensible flexfield. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task.
CreationDateTime Datetime CreationDateTime of ItemsV2ItemRevision
LastUpdateDateTime Datetime LastUpdateDateTime of ItemsV2ItemRevision
CreatedBy String CreatedBy of ItemsV2ItemRevision
LastUpdateLogin String LastUpdateLogin of ItemsV2ItemRevision
LastUpdatedBy String LastUpdatedBy of ItemsV2ItemRevision
RequestId Long Value that uniquely identifies the request. This attribute is generated during import. This value is used to verify import, when items are published.
AcdType String AcdType of ItemsV2ItemRevision
ChangeLineId Long ChangeLineId of ItemsV2ItemRevision
Finder String Finder of ItemsV2ItemRevision
InventoryOrganizationId Long InventoryOrganizationId of ItemsV2ItemRevision
ItemNumber String ItemNumber of ItemsV2ItemRevision
OrganizationCode String OrganizationCode of ItemsV2ItemRevision
VersionId Long VersionId of ItemsV2ItemRevision

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062