Item Cross-reference

A view object that represents the relationship between two items.

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

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

Item Relationship Descriptive Flexfield

Contains

Item Relationship Translation

Handled by

Item Relationship Version 2

Attributes

The following table describes attributes in the service data object.

Name Type Description

ApplicableOrganizationCode

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.

ApplyToAllOrganizationFlag

boolean

Flag to identify if this relationship is applicable across all organizations.

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.

CrossReferenceTypeValue

string

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

CrossReferenceValue

string

An attribute value that is entered based on the Type value. For example the Type could be "Old Part Numer" and the Value could "ASC345" for the cross reference.

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 indentifier for an item relationship.
  • Primary Key

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.

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

An attribute value that represents the root organization in a organizational hierarchy.

RelationshipDescription

string

The description for an item relationship.

RequestId

long

An identifier for the item import scheduled process request which created or updated the item relationship