Item Supplier Associations

The Item Supplier Associations view object contains information for the suppliers associated with an item.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemSupplierAssociationExtractPVO

Primary Keys : ItemSupplierAssociationPEOSupplierSiteId, ItemSupplierAssociationPEOChangeLineId, ItemSupplierAssociationPEOAcdType, ItemSupplierAssociationPEOInventoryItemId, ItemSupplierAssociationPEOVersionId, ItemSupplierAssociationPEOOrganizationId, ItemSupplierAssociationPEOSupplierId

Initial Extract Date : ItemSupplierAssociationPEOCreationDate

Incremental Extract Date : ItemSupplierAssociationPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ItemSupplierAssociationPEOAcdType	Indicates whether this is a production row, change row or change history row.
ItemSupplierAssociationPEOAssociationId	Value that uniquely identifies the item supplier association.
ItemSupplierAssociationPEOChangeLineId	Value that uniquely identifies the change order line.
ItemSupplierAssociationPEOCreatedBy	User who created the item supplier association.
ItemSupplierAssociationPEOCreationDate	Date when the user created the item supplier association.
ItemSupplierAssociationPEOImplementationDate	Date when the change was implemented.
ItemSupplierAssociationPEOInventoryItemId	Value that uniquely identifies an item.
ItemSupplierAssociationPEOLastUpdateDate	Date when the user most recently updated the item supplier association.
ItemSupplierAssociationPEOLastUpdateLogin	Login that the user used when updating the item supplier association last.
ItemSupplierAssociationPEOLastUpdatedBy	User who most recently updated the item supplier association..
ItemSupplierAssociationPEOOrganizationId	Value that uniquely identifies the organization.
ItemSupplierAssociationPEOPrimaryFlag	Primary status of the item supplier association. Contains one of the following values: Y or N. If Y, then the item supplier association is primary. If N, it's not primary.
ItemSupplierAssociationPEOStatusCode	Value that identifies the status of item supplier association. A list of accepted values is defined in the lookup type EGO_ITEM_ASSOC_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemSupplierAssociationPEOSupplierId	Value that uniquely identifies the supplier.
ItemSupplierAssociationPEOSupplierSiteId	Value that uniquely identifies the supplier address.
ItemSupplierAssociationPEOVersionEndDate	Date when the version of the item becomes ineffective.
ItemSupplierAssociationPEOVersionId	Value that uniquely identifies the item version.
ItemSupplierAssociationPEOVersionStartDate	Date when the new version of the item comes into effect.