GTIN Cross-reference

A view object that represents the relationship between an item and one or more Global Trade Item Number.

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

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.

EPCGTINSerial

decimal

An attribute value that represents the EPC or GTIN Special identifier for the GTIN Relationship in Item Relationships.

GTIN

string

An attribute value that indicates the party type for the GTIN Cross Reference.

GTINDescription

string

The description for an item relationship.

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

RevisionCode

string

An attribute value that represents a revision.

TradingPartnerName

string

The name or number representing a Trading Partner.

TradingPartnerNumber

string

An unique value that represents the identity of the party.

TradingPartnerTypeValue

string

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

UOMCodeValue

string

An attribute that value represents the standardization of the measurement of a physical property, used as a factor to express occurring quantities of that property.