Item Supplier Interface
An open interface table for the association of an item with a supplier who provides that item, such as the association of item CAR with supplier Zoom Incorporated.
QName: {http://xmlns.oracle.com/apps/scm/productHub/itemImport/batches/itemInterfaceService/}ItemAssociationsIntf
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 |
|---|---|---|
|
AssociationTransactionId |
long |
Unique identifier of interface record.
|
|
BatchId |
long |
An unique indentifier for a batch in which the supplier association is to be processed in. |
|
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. |
|
GlobalLocationNumber |
string |
An attribute value that represents the Global Location Number used to identify the supplier address to be associated with the specified Item. |
|
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: An attribute that indicates the date and time of the creation of the Item relationship. |
|
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. |
|
PrimaryFlag |
boolean |
A flag that indicates whether the association is primary for the item. |
|
ProcessStatus |
long |
Status of the interface record. 3 is error. 7 is successfully imported |
|
SpokeSystemItem |
string |
The attribute that represents the name of the original system that data comes from. |
|
StatusCodeValue |
string |
An attribute value for the status of the item supplier association. |
|
SupplierName |
string |
This column identifies to which supplier name the association is created for. References party_name from hz_parties for the party_id in ap_suppliers |
|
SupplierNumber |
string |
This column identifies the supplier number for which the association is created for. |
|
SupplierSiteName |
string |
An attribute value that represents the supplier site name for the supplier site association. |
|
TransactionType |
string |
Indicates the action user wants to perform on the Production Data |