Process Item Cross-reference Relationship Interface

An open interface table for the process operation for an item cross-reference relationship, such item AS72111 has the old part number of AD72111.

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

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

AllOrganizationsFlag

boolean

A flag that indicates that all organizations will be used in the Item cross reference.

BatchId

long

An unique identifier of the batch in which this interface record is to be processed. Not a required field.

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 Item relationship.

FromItemNumber

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 that will be used as the From Item in the Related Item Relationship.

InterfaceTableUniqueId

long

Unique identifier of interface record.
  • Primary Key

ItemTransactionId

long

Reference to the item record in the item interface table.

LastUpdateDateTime

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

Who column: indicates the date and time of the last update of the item relationship.

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

Read Only: An attribute value which represents the status of a interface record. A value of 3 represents an error and value of 7 represents a successful import.

RelationshipDescription

string

An attribute value that represents a type of related items for item relationships. The value is setup in a lookup type.

SpokeSystemItem

string

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

SubTypeValue

string

An attribute value that represents a type of related items for item relationships. The value is setup in a lookup type.

ToItemNumber

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 that will be used as the To Item in the Related Item Relationship.

TransactionType

string

The attribute value which indicates the action type for the Item Interface transaction. The values includes CREATE, UPDATE, or SYNC.