PurchaseAgreementslinesitemAttributes
Agreement item attribute captures additional information about the item on the agreement line such as supplier item auxiliary identifier, supplier URL, manufacturer name, manufacturer URL, manufacturer part number, United Nations Standard Products and Services Code, UNSPSC, and image URL. For example, Big Computers could be the manufacturer of a laptop whereas B004521 could be the manufacturer part number for a television.
Columns
Name | Type | Description |
PurchaseAgreementsAgreementHeaderId [KEY] | Long | Value that uniquely identifies the purchase agreement. |
LinesAgreementLineId [KEY] | Long | Value that uniquely identifies the agreement line. |
AttributeValuesId [KEY] | Long | Value that uniquely identifies the purchasing extended item attributes. This is the primary key of the Purchasing Attribute Values view object. |
AttributeValuesTlpId | Long | Value that uniquely identifies the purchasing item translation attributes. This is the primary key of the Purchasing Attribute Values Translation view object. |
LongDescription | String | Text describing the long description of the item specified on a blanket purchase agreement line. |
SupplierURL | String | URL of the supplier's organization. |
Manufacturer | String | Name of the manufacturer of the item specified on a blanket purchase agreement line. |
ManufacturerURL | String | URL of the manufacturer of the item specified on a blanket purchase agreement line. |
ManufacturerPartNumber | String | Part number used to identify the item by the manufacturer of the item, that's specified on a blanket purchase agreement line. |
AttachmentURL | String | URL of the attachment associated with the item. |
Alias | String | Alternate identifier for an item specified on a blanket purchase agreement line. |
LeadTimeDays | Decimal | The number of days in which the item, specified on the blanket purchase order line, can be delivered when ordered. |
UNSPSC | String | The United Nations Standard Products and Services Code for the item specified on the blanket purchase agreement. |
ImageURL | String | URL of the image file associated with the item specified on a blanket purchase agreement line. |
ThumbnailImageURL | String | Location of the small version of a larger image file for the item specified on the blanket purchase agreement. |
Availability | String | Status of the item availability from supplier. |
RoundingFactor | Double | 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. |
PackagingString | String | String that describes how the item is packed by the supplier. |
CreatedBy | String | User who created the item attributes for a purchase agreement line. |
CreationDate | Datetime | Date and time when the buyer or application created the item attributes for a purchase agreement line. |
LastUpdateDate | Datetime | Date and time when the buyer or application last updated the item attributes on a purchase agreement line. |
LastUpdatedBy | String | User who last updated the item attributes on a purchase agreement line. |
AgreementHeaderId | Long | agreementheaderid |
Finder | String | finder |
EffectiveDate | Date | This query parameter is used to fetch resources which are effective dated as of the specified start date. |