Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

PurchaseAgreementslines

Details of the goods or services to be purchased from the supplier. The line doesn't contain delivery dates or individual delivery quantities or amounts. For example, an agreement line can be service-based for installing a television or a goods item to negotiate the price for 50 laptops.

Columns

Name Type Description
PurchaseAgreementsAgreementHeaderId [KEY] Long Value that uniquely identifies the purchase agreement.
AgreementLineId [KEY] Long Value that indicates the status of the line.
LineNumber Decimal Value that uniquely identifies the purchase order or agreement line.
AgreementHeaderId Long Value that uniquely identifies the purchase agreement.
AgreementNumber String Number that uniquely identifies the purchase agreement in the sold-to legal entity.
ProcurementBUId Long Value that uniquely identifies the business unit that manages and owns the purchasing document.
ProcurementBU String Business unit that manages and owns the purchase agreement.
SupplierId Long Value that uniquely identifies the supplier.
Supplier String Name of the supplier who fulfills the item.
SupplierSiteId Long Value that uniquely identifies the supplier site.
SupplierSite String Location that the supplier uses to purchase the item.
LineTypeId Long Value that uniquely identifies the line type on your documents.
LineType String Line type on purchasing documents.
ItemId Long Value that uniquely identifies the item on the purchase agreement.
Item String Abbreviation that uniquely identifies the item on the purchase order.
ItemRevision String Value that identifies the revision number of the item.
Description String Description for the line item.
SupplierItem String Value that identifies the supplier item number.
CategoryId Long Value that uniquely identifies the purchasing category.
CategoryCode String Abbreviation that identifies the purchasing category.
Category String Value that uniquely identifies the purchasing category.
StatusCode String Code that identifies the agreement line status.
Status String Status of an agreement line.
UOMCode String Code that identifies the unit of measure.
UOM String Abbreviation that identifies the unit of measure on the agreement line
Price Decimal Unit price for the line.
Amount Decimal Value that identifies the amount agreed on an agreement line between the buying and selling organization.
CurrencyCode String Code that identifies the purchase order currency.
Currency String Currency on the purchase agreement line.
ConsignmentLineFlag Bool Contains one of the following values: true or false. If true, then the blanket purchase agreement and the purchase order include consignment lines. If false, then the blanket purchase agreement and the purchase order don't include consignment lines. The default value is false.
NoteToSupplier String Value that uniquely identifies a note to supplier.
AllowItemDescriptionUpdateFlag Bool Value that identifies whether item descriptions can be updated on document lines.
PriceLimit Decimal Value that identifies the price limit that you can't exceed on a release shipment.
AllowPriceOverrideFlag Bool Value that identifies if you can change the price on release shipments. Possible values are Y and N. This attribute doesn't have a default value.
NegotiatedFlag Bool Contains one of the following values: true or false. If true, then the buyer and the supplier negotiated and agreed on the price before the purchase. If false, then the buyer and the supplier didn't negotiate the price before the purchase. This attribute doesn't have a default value.
ExpirationDate Date Value that identifies the expiration date of the document.
MinimumReleaseAmount Decimal Value that identifies the minimum amount that can be released against a blanket or planned purchase order.
AgreementAmount Decimal Value that identifies the amount agreed for an agreement line.
AgreementQuantity Decimal Quantity agreed for an agreement line.
ReleasedAmount Decimal Value that identifies the amount released against this agreement. It's the sum of all the approved standard PO amounts.
PriceBreakTypeCode String Value that identifies the pricing scheme for the price breaks of this line.
SupplierItemAuxiliaryIdentifier String Value that uniquely identifies the item information.
ParentItemId Long Value that uniquely identifies the parent option class or model for the item.
SupplierParentItem String Value that identifies the supplier's identification number for the option class or model associated with item.
TopModelId Long Value that uniquely identifies the top model associated with the option, option class, or submodel.
SupplierTopModel String Value that identifies the top model associated with the option or option class, or submodel.
UnNumberId Long Value that uniquely identifies the number that the United Nations uses to identify hazardous material.
UnNumber String Value that identifies the United Nations identification number for the hazardous material.
UNNumberDescription String Value that uniquely identifies the number that the United Nations uses to identify hazardous material.
HazardClassId Long Value that uniquely identifies the hazard class.
HazardClassCode String Code that identifies the hazard class.
HazardClass String Name of the hazard class.
AgingPeriodDays Int Value that identifies the maximum number of days the material may be on consignment.
CreatedBy String User who created the purchase agreement line.
CreationDate Datetime Date and time when the buyer or application created the purchase agreement line.
LastUpdatedBy String User who last updated the purchase agreement line.
LastUpdateDate Datetime Date and time when the buyer or application last updated the purchase agreement line
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