Trading Partner Item Interface

An open interface table for the identifier used by a trading partner to refer to an internal item, such as customer item or competitor item.

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

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

Identifier of the batch in which this interface record is to be processed

BatchName

string

An attribute value that represents the name of the batch.

CreationDateTime

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

Who column: indicates the date and time of the creation of the row.

EndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date and time on which a Trading Partner Item ends or is no longer effective.

InterfaceTableUniqueId

long

Unique identifier of interface record.
  • Primary Key

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 row.

NewTradingPartnerItemNumber

string

This attribute refers to new trading partner item number that user will specify while updating an existing trading partner item number.

ProcessStatus

long

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.

StartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date and time on which a Trading Partner Item begins or is effective.

TradingPartnerItemDescription

string

Trading Partner Item Description

TradingPartnerItemNumber

string

An attribute value that represents the Trading Partner Item number.

TradingPartnerItemStatusValue

string

An attribute value that represents the status of a trading partner item.

TradingPartnerNumber

string

An attribute value that represents the description for a Trading Partner Item.

TradingPartnerTypeValue

string

An attribute value that represents a type of trading partner. The values include COMPETITOR, CUSTOMER, SUPPLIER and MANUFACTURER.

TransactionType

string

The attribute value which incates the action type for the Trading Partner Item transaction. The values includes CREATE, UPDATE, or DELETE.

UOMName

string

An attribute value for the standardized quantity of a physical property, used as a factor to express occurring quantities of that property.

UnitPriceAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

An attribute that value is the unit purchase price of the trading partner item.

UnitPriceCurrencyCode

string

A unique identifier that is the currency for the unit price.