Item Supplier Extensible FlexField

A customer-specified set of fields that are used to capture a characteristic of a item supplier, such as lead time or minimum order quantity.

QName: {http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/itemSupplier/categories/}j_RevisedItemSupplierAssociation

Logical Business Objects

  • SCM : Product Model : Item

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

Contained by

Item Supplier 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

AcdType

string

An attribute that represents the change action for the operation.
  • Primary Key

AssociationId

long

An unique identifier for the item association.

CategoryCode

string

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

ChangeBitMap

string

change bitmap is the bitmap representation for attributes which are changed through the row

ChangeLineId

long

Unique identifier for change line
  • Primary Key

ContextChangeLineId

long

Identifier for the change context in which the data is queried

ContextDate

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

Context date

ContextVersionId

long

Version identifier for the change context in which the data is queried

CreatedBy

string

Who column: An attribute that identifies the person that created the record.

CreationDate

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

Who column: An attribute that indicates the date and time of the creation of the trading partner item.

Duns

string

An internal value.

ImplementationDate

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

An attribute that represent the date of the implementation.

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

ItemCatalogGroupId

long

An unique value that provides metadata common to all items that share the category.

JobDefinitionName

string

Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.

JobDefinitionPackage

string

Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

LastUpdateDate

{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 trading partner item.

LastUpdateLogin

string

Who column: An attribute that represent the login name of the person that updated the record.

LastUpdatedBy

string

Who column: An attribute which indicates the person that updated the record.

MasterOrganizationId

long

An unique identifer for the master organization for the item for production items. In case of pending or update operations such update of version item, this attribute value will be the VersionId.

ObjectVersionNumber

int

Who column: The object version number for the record.

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

OrganizationId1

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

PrimaryFlag

boolean

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

ProgramAppName

string

Who column: The program application name in the concurrent request.

ProgramName

string

Who column: The program name in the current request.

RegistryId

string

Registry identification number of a supplier in the party model.

RequestId

decimal

Enterprise Service Scheduler: An attribute that indicates the request ID of the job that created or last updated the row.

StatusCode

long

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

SupplierId

long

An unique identifier for the vender that will supply the item.
  • Primary Key

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.

SupplierSiteId

long

An unique identifier for the supplier site name for the supplier site association.
  • Primary Key

SupplierSiteName

string

An attribute that represents the name of the supplier address.

VersionEndDate

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

An attribute that presents date version end date.

VersionId

long

An attribute value for the vender that will supply the item.
  • Primary Key

VersionStartDate

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

An attribute that represents the start date of version