Spoke System Relationship

A view object that represents a relationship between an item in the spoke system and in the system.

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

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

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 and time on which an item relationship ends or is no longer active.

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.

RequestId

long

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

SpokeSystemCode

string

An attribute that identifies the external spoke system.

SpokeSystemItem

string

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

SpokeSystemItemDescription

string

The description for an item relationship.

StartDate

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

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