Item Revision Version 2

The association of an item with a supplier who provides that item, such as the association of item CAR with supplier Zoom Incorporated.

QName: {http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/}ItemRevision

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Revision Attachments

Contains

Item Revision Extensible Flexfield

Contains

Item Revision Descriptive Flexfield

Contains

Item Revision Translation Version 2

Contained by

Item Version 2

Handled by

Item Version 2

Handled by

Product Design Change Order Web Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

CreatedBy

string

Who column: An attribute which indicates the user that created the item revision.

CreationDateTime

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Who column: An attribute that indicates the date and time of the creation of the item revision.

EffectivityDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Revision effectively date

EndEffectivityDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Date and time when the effectivity of the revision ends.

ImplementationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Date and time when the revision was implemented.

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.

ItemRevisionDFF

Item Revision Descriptive Flexfield

ItemService.ItemRevisionDFF

ItemRevisionDescription

string

The description for on item revision.

ItemRevisionEffCategory

Item Revision Extensible Flexfield

ItemService.ItemRevisionEffCategory

ItemRevisionTranslation

Item Revision Translation Version 2

An attribute value which is used to acccess the translated information for the item revision.

LastUpdateDateTime

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Who column: An attribute which indicates the date and time of the last update of 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

ObjectVersionNumber

int

This value is set to value of '1" when the item is created and incremented every time the item is updated.

OrganizationId

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.
  • Primary Key

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.

RevisionAttachment

Revision Attachments

ItemService.RevisionAttachment

RevisionCode

string

An attribute value that represents a revision.

RevisionExtensibleFlexfieldCategoryCode

string

An attribute value for the EFF category code for the Item revision.

RevisionId

long

An unique identifier of a revision.
  • Primary Key

RevisionReasonValue

string

An attribute value that represents the reason for a revision.