Trading Partner Item Relationship

A view object for the trading partner item relationship.

QName: {http://xmlns.oracle.com/apps/scm/productModel/items/itemRelationshipService/}TradingPartnerItemCrossReference

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	Linked MPN Relationships
Contains	Item Relationship Descriptive Flexfield
Contains	Item Relationship Translation
Contains	Linked Supplier Item Relationships
Handled by	Item Relationship Version 2

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
CompetitorItemRelationshipTypeValue	string	An attribute which defines the type of Competitor item relationship. The values are user defined and not seeded.
CreatedBy	string	Who column: An attribute which indicates the user that created the trading partner item relationship.
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	long	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.
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.
ItemRelationShipsDFF	Item Relationship Descriptive Flexfield	Descriptive Flexfield extensions for Item Relationships.
ItemRelationTranslation	Item Relationship Translation	An attribute which value is used to access the translated information.
ItemRelationshipId	long	An unique identifier for an item relationship. Primary Key
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.
LastUpdateLogin	string	Who column: An attribute which indicates the user that logged in last for the trading partner item relationship.
LastUpdatedBy	string	Who column: An attribute which indicates the user that last updated the trading partner item relationship.
LinkedMPNRelationships	Linked MPN Relationships	Title for the LinkedMPNRelationships resource, which is part of the tradingPartnerItemRelationships root resource.
LinkedSupplierItemRelationships	Linked Supplier Item Relationships	Title for the LinkedSupplierItemRelationships resource, which is part of the tradingPartnerItemRelationships root resource.
ObjectVersionNumber	int	This value is set to value of '1" when the item is created and incremented every time the item is updated.
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.
RelationshipDescription	string	The description for an item relationship.
RelationshipStatusValue	string	An attribute value that represents the status of a trading partner item relationship.
RequestId	long	An identifier for the item import scheduled process request which created or updated the item relationship
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.
TradingPartnerName	string	An attribute value that represents the name of the trading partner.
TradingPartnerNumber	string	An attribute value for the number representing a trading partner.
TradingPartnerType	string	An attribute value that represents a type of trading partner. The values include COMPETITOR, CUSTOMER, SUPPLIER and MANUFACTURER.