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