Purchasing Attribute Values

The Purchasing Attribute Values view object manages the purchasing extended item attributes.

Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingAttributeValuesExtractPVO

Primary Keys : AttributeValuesId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AttachmentUrl	URL of the attachment associated with the item.
AttributeValuesId	Value that uniquely identifies the purchasing extended item attributes. This is the primary key of the Purchasing Attribute Values view object.
Availability	Status of the item availability from supplier.
CreatedBy	User who created the purchasing extended item attributes.
CreationDate	Date and time when the purchasing extended item attributes was created.
JobDefinitionName	Name of the job that created or last updated the row.
JobDefinitionPackage	Package name of the job that created or last updated the row.
LastUpdateDate	Date and time when the buyer or application last updated the purchasing extended item attributes.
LastUpdateLogin	Session login associated with the user who last updated the row.
LastUpdatedBy	User who last updated the purchasing extended item attributes.
LastUpdatedProgram	Name of the program that last updated the row.
LeadTime	The number of days in which the item, specified on the blanket purchase order line, can be delivered when ordered.
ManufacturerPartNum	Part number used to identify the item by the manufacturer of the item, that's specified on a blanket purchase agreement line.
ManufacturerUrl	URL of the manufacturer of the item specified on a blanket purchase agreement line.
ObjectVersionNumber	Number of times the purchasing extended item attributes has been updated.
PackagingString	String that describes how the item is packed by the supplier.
Picture	URL of the image file associated with the item specified on a blanket purchase agreement line.
PoHeaderId	Value that uniquely identifies the purchase agreement.
PoLineId	Value that uniquely identifies the purchase agreement line.
PrcBuId	Value that uniquely identifies the business unit that manages and owns the purchasing documents.
RebuildSearchIndexFlag	Indicates that a row has an oracle text domain index defined to support keyword search.
RequestId	Value that uniquely identifies the request ID of the job that created or last updated the row.
RoundingFactor	Attribute indicating how to round the quantity on an internal requisition that results from conversions between the requisition line unit of measure and the item unit of issue.
SupplierUrl	URL of the supplier's organization.
ThumbnailImage	Location of the small version of a larger image file for the item specified on the blanket purchase agreement.
Unspsc	The United Nations Standard Products and Services Code for the item specified on the blanket purchase agreement.