Process Linked Trading Partner Item Relationships Interface
An open interface table for a link defined between a supplier item relationship and an manufacturer part relationship.
QName: {http://xmlns.oracle.com/apps/scm/productHub/itemImport/batches/itemInterfaceService/}MpnSpnRelLinkageInterface
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 |
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. |
|
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Who column: indicates the date and time of the creation of the row. |
|
InterfaceTableUniqueId |
long |
Unique identifier of interface record.
|
|
InventoryItemId |
long |
An unique identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes. |
|
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 |
An unique identifier for interface record that is processed in the transaction. |
|
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Who column: indicates the date and time of the last update of the row. |
|
ManufacturerId |
long |
Value that uniquely identifies the linked manufacturer. |
|
ManufacturerNumber |
string |
Value that uniquely identifies the manufacturer party. |
|
ManufacturerPartId |
long |
Value that uniquely identifies the manufacturer trading partner item. |
|
ManufacturerPartNumber |
string |
Number that identifies a manufacturer part number. |
|
MasterOrganizationCode |
string |
An unique identifier that represents the root organization in a organizational hierarchy. |
|
MasterOrganizationId |
long |
An unique identifier that represents the root organization in a organizational hierarchy. |
|
PrimaryFlag |
string |
Value that identifies whether the linked MPN relationship is primary. The default value is False. |
|
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. |
|
SourceSystemCode |
string |
An unique indentifier for the system or applications instance which is the source of the collected data. |
|
SourceSystemId |
long |
An unique indentifier for the system or applications instance which is the source of the collected data. |
|
SourceSystemReference |
string |
The attribute that represents the name of the original system that data comes from. |
|
SupplierId |
long |
Value that uniquely identifies the linked supplier. |
|
SupplierItemId |
long |
Value that uniquely identifies the supplier trading partner item. |
|
SupplierItemNumber |
string |
Number that identifies a supplier part number. |
|
SupplierNumber |
string |
Value that uniquely identifies the supplier party. |
|
TransactionType |
string |
The attribute value which indicates the action type for the relationship linkage transaction. The values includes CREATE, UPDATE, or SYNC. |