Process Trading Partner Item Relationship Interface

An open interface table for the process operation for a trading partner item relationship, such as Item AS72111 supplied by the Entrich supplier has an supplier part number of 1064567.

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

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.

CompetitorItemRelationshipTypeValue

string

An attribute which defines the type of Competitor item relationship. The values are user defined and not seeded.

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

CustomerItemRelationshipRank

string

An attribute value that represents the ordering or ranking of the customer item relationships.

EndDate

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

The date on which a trading partner item relationship ends.

InterfaceTableUniqueId

long

Unique identifier of interface record.
  • Primary Key

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.

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 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

The description for an item relationship.

RelationshipStatusValue

string

An attribute value that represents the status of a trading partner item relationship..

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

TradingPartnerItemNumber

string

An attribute value that represents the item from a trading partner.

TradingPartnerNumber

string

An attribute value for the number representing a trading partner.

TradingPartnerTypeValue

string

An attribute value that represents a type of trading partner. The values include COMPETITOR, CUSTOMER, SUPPLIER and MANUFACTURER.

TransactionType

string

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