Item Revision Interface

An open interface table for an object that consists of an incremenatal change to the item. All items have at least one revision.

QName: {http://xmlns.oracle.com/apps/scm/productHub/itemImport/batches/itemInterfaceService/}ItemRevisionInterface

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

Handled by

Item Batch Maintenance

Attributes

The following table describes attributes in the service data object.

Name Type Description

BatchId

long

Identifier of the batch in which this interface record should be processed

BatchName

string

An attribute value that represents the name of the batch.

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 trading partner item.

EffectivityDate

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

A date and time on which the item revision is schedule to be implemented.

ItemNumber

string

An attribute that is an identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.

ItemRevisionDescription

string

An attribute value that represents a revision.

ItemTransactionId

long

Reference to the item record in the item interface table.

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 trading partner item.

OrganizationCode

string

A name of 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.

ProcessStatus

long

Status of the interface record. 3 is error. 7 in successfully imported.

RevisionCode

string

An attribute value that represents a revision.

RevisionReasonValue

string

An attribute value that represents the reason for a revision.

RevisionTransactionId

long

Unique identifier of interface record.
  • Primary Key

SpokeSystemItem

string

An attribute value that represents an item in the spoke system that is being referenced.

TransactionType

string

The attribute value which incates the action type for the Item revision transaction. The values includes CREATE, UPDATE, or DELETE.