Item Supplier Version 2

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/productModel/items/itemServiceV2/}ItemSupplierAssociation

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 Supplier Extensible FlexField

Contained by

Item Version 2

Handled by

Item Version 2

Handled by

Product Design Change Order Web Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

Address

string

An attribute that represents the street address where asset party is located.

AddressName

string

An attribute that represents the name of the supplier address.

AlternateSupplierNumber

string

This refers to Supplier number of Supplier in procurement.

AssociationId

long

An unique identifier for the item supplier association.

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

ItemId

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.
  • Primary Key

ItemSupplierEffCategory

Item Supplier Extensible FlexField

ItemService.ItemSupplierEffCategory

LastUpdateDateTime

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

Who column: An attribute which indicates the date and time of the last update of the item supplier.

ObjectVersionNumber

int

This value is set to value of '1" when the item is created and incremented every time the item is updated.

OrganizationId

long

An unique identifier for 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.
  • Primary Key

PartySiteNumber

string

An attribute value that represents the supplier site name for the supplier site association.

PrimaryFlag

boolean

A flag that indicates whether the association is primary for the item.

PublicationTransactionType

string

This attribute determines if the Supplier Association is being publishing from Production table or Audit Table.

RegistryId

string

Registry ID of a supplier party is a number that uniquely identifies a party. Review and update the value for this attribute using the Manage suppliers task.

RequestId

long

This is the request id generated at import. Its use case is to verify import, the items will be published based on RequestID.

SupplierExtensibleFlexfieldCategoryCode

string

An unique identifier for the EFF category code for the Item supplier.

SupplierId

long

Value that uniquely identifies a supplier.
  • Primary Key

SupplierItemNumber

string

This attribute is not used. Use ItemRelationshipService to obtain supplier items.

SupplierName

string

An attribute value for the vender that will supply the item.

SupplierNumber

string

An attribute value that represents the name of the Supplier.

SupplierSiteAssociationStatus

string

An attribute value for the status of the item supplier association.

SupplierSiteId

long

Value that uniquely identifies a supplier address.
  • Primary Key