ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111