Process Related Item Relationship Interface

A collection of items and related information, such as supplier feed batch or legacy application consolidation batch, that is staged for import into a master product information repository.

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

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

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.

EndDate

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

The date on which an item relationship ends or is no longer active.

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.

MasterControlledFlag

boolean

Contains one of the following values: true or false. If true, then the relationship is master controlled. If false, the relationship is organization controlled. The default value is true.

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.

PlanningEnabledFlag

boolean

A flag that indicates that planning is enabled for Related Item.

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.

Rank

long

Rank of the related item relationship.

ReciprocalFlag

boolean

A flag to indicate that a reciprocal relationship exists in the item relationship.

RelatedSpokeSystemItem

string

Item identifier that represents the target spoke item to which the item is related as a part of the item relationships.

RelationshipDescription

string

The description for an item relationship.

RelationshipTypeValue

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.

StartDate

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

The date on which an item relationship begins and is active.

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.