Process GTIN Relationship Interface

An open interface table for the process operation for a relationship between an item and one or more Global Trade Item Numbers. For example, AS72111, a Envoy Laptop is represented by GTIN bar code 1061414000415.

QName: {http://xmlns.oracle.com/apps/scm/productHub/itemImport/batches/itemInterfaceService/}GTINCrossReferenceInterface

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

Handled by

Item Batch Maintenance

Attributes

The following table describes attributes in the service data object.

Name Type Description

BatchId

long

An unique identifier of the batch in which this interface record is to be processed. Not a required field.

BatchName

string

An attribute value that represents the name of the batch.

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

long

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

GTIN

string

A Global Trade Item Number (GTIN) identifies any trade item and the standard product packaging for any item that may be priced, ordered, or invoiced at any point in the Supply Chain.

GTINDescription

string

An attribute value that represents the decription for the Global Trade Item Number for UCCNET.

InterfaceTableUniqueId

long

Unique identifier of interface record.
  • Primary Key

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.

ItemTransactionId

long

Reference to the item record in the item interface table.

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.

OrganizationCode

string

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

ProcessStatus

long

Read Only: An attribute value which represents the status of a interface record. A value of 3 represents an error and value of 7 represents a successful import.

RevisionCode

string

An attribute value that represents a revision.

SpokeSystemItem

string

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

TradingPartnerNumber

string

An attribute value for the number representing a Trading Partner.

TradingPartnerTypeValue

string

An attribute value that indicates the Trading Partner type for the GTIN Relationship. The value include; Customer, Manufacturer, Supplier and Null.

TransactionType

string

The attribute value which indicates the action type for the Item Interface transaction. The values includes CREATE, UPDATE, or SYNC.

UOMName

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.