Related Item Relationship

An view object that represents a related item.

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

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

CreatedBy

string

Who column: An attribute which indicates the user that created the 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 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.

FromItemApprovalStatusValue

string

An attribute value that represents the status of the approval for the from item.

FromItemClass

string

An attribute value that provides metadata that are common to all items and that shares the category of the from item.

FromItemDescription

string

An attribute value that defines the from item.

FromItemLifecyclePhaseValue

string

An attribute value that represents the lifecycle phase of the from item.

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.

FromItemPrimaryUOMValue

string

An attribute value that defines the primary unit of measurement used to measure quantities of the from item.

FromItemStatusValue

string

An attribute that defines codes used to control the transaction activity of the from item.

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.

LastUpdateLogin

string

Who column: An attribute which indicates the user that logged in last for the item relationship.

LastUpdatedBy

string

Who column: An attribute which indicates the user that last updated 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.

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.

PlanningEnabledFlag

boolean

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

Rank

long

Rank of the related item relationship.

ReciprocalFlag

boolean

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

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.

RequestId

long

This is the request id generated at import. Its use case is to verify import, the items will be published based on RequestID.

StartDate

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

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

ToItemApprovalStatusValue

string

An attribute value that represents the status of the approval for the to item.

ToItemClass

string

An attribute value that provides metadata that are common to all items and that shares the category of the to item.

ToItemDescription

string

An attribute value that defines to item.

ToItemLifecyclePhaseValue

string

An attribute value that represents the lifecycle phase of the to item.

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.

ToItemPrimaryUOMValue

string

An attribute value that defines the primary unit of measurement used to measure quantities of the to item.

ToItemStatusValue

string

An attribute that defines codes used to control the transaction activity of the to item.