// fusionrest agent · procurement

Purchase Agreement Lines

purchaseAgreementLines Based on 26C

Look up Purchase Agreement Lines, with item attributes and price breaks. Read-only.

/fscmRestApi/resources/11.13.18.05/purchaseAgreementLines
Operations
GET (list)GET (one)
Record key
AgreementLineId
Required on create
no create on this resource
At a glance
65 fields2 finders7 children
I want to…List the latest 25Count recordsGet one record

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/purchaseAgreementLines?fields=AgingPeriodDays,AgreementAmount,AgreementHeaderId,AgreementLineId,AgreementNumber&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AgingPeriodDays": 0,
      "AgreementAmount": 0,
      "AgreementHeaderId": 0,
      "AgreementLineId": 0,
      "AgreementNumber": "<string, max 30>"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0
}

Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.

Fields 65

AttributeTypeUse
AgingPeriodDaysnumberRead-onlySearchable
AgreementAmountnumberRead-onlySearchable
AgreementHeaderIdnumberRead-onlySearchable
AgreementLineIdnumberRead-onlySearchable
AgreementNumbertext · max 30Read-onlySearchable
AgreementQuantitynumberRead-onlySearchable
AllowItemDescriptionUpdateFlagyes/no · max 1Read-onlySearchable
AllowPriceOverrideFlagyes/no · max 1Read-onlySearchable
AmountnumberRead-onlySearchable
Categorytext · max 2400Read-onlySearchable
CategoryCodetext · max 820Read-onlySearchable
CategoryIdnumberRead-onlySearchable
ConsignmentLineFlagyes/no · max 1Read-onlySearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
Currencytext · max 80Read-onlySearchable
CurrencyCodetext · max 15Read-onlySearchable
Descriptiontext · max 240Read-onlySearchable
ExpirationDatedateRead-onlySearchable
HazardClasstext · max 40Read-onlySearchable
HazardClassCodetext · max 30Read-onlySearchable
HazardClassIdnumberRead-onlySearchable
Itemtext · max 255Read-onlySearchable
ItemIdnumberRead-onlySearchable
ItemRevisiontext · max 18Read-onlySearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LineNumbernumberRead-onlySearchable
LineStartDatedateRead-onlySearchable
LineTypetext · max 30Read-onlySearchable
LineTypeIdnumberRead-onlySearchable
MinimumReleaseAmountnumberRead-onlySearchable
NegotiatedFlagyes/no · max 1Read-onlySearchable
NoteToSuppliertext · max 1000Read-onlySearchable
ParentItemtext · max 255Read-only
ParentItemIdnumberRead-onlySearchable
PimItemCategorytext · max 255Read-onlySearchable
PimItemCategoryCodetext · max 255Read-onlySearchable
PimItemCategoryIdnumberRead-onlySearchable
PimItemDescriptiontext · max 255Read-onlySearchable
PricenumberRead-onlySearchable
PriceBreakTypetext · max 80Read-only
PriceBreakTypeCodetext · max 25Read-onlySearchable
PriceLimitnumberRead-onlySearchable
ProcurementBUtext · max 255Read-onlySearchable
ProcurementBUIdnumberRead-onlySearchable
PurchaseBasistext · max 30Read-only
ReleasedAmountnumberRead-onlySearchable
Statustext · max 80Read-onlySearchable
StatusCodetext · max 25Read-onlySearchable
Suppliertext · max 255Read-onlySearchable
SupplierIdnumberRead-onlySearchable
SupplierItemtext · max 300Read-onlySearchable
SupplierItemAuxiliaryIdentifiertext · max 255Read-onlySearchable
SupplierParentItemtext · max 300Read-onlySearchable
SupplierSitetext · max 255Read-onlySearchable
SupplierSiteIdnumberRead-onlySearchable
SupplierTopModeltext · max 300Read-onlySearchable
TopModeltext · max 255Read-only
TopModelIdnumberRead-onlySearchable
UNNumberDescriptiontext · max 240Read-onlySearchable
UOMtext · max 25Read-onlySearchable
UOMCodetext · max 3Read-onlySearchable
UnNumbertext · max 20Read-onlySearchable
UnNumberIdnumberRead-onlySearchable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 2

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 7

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/purchaseAgreementLines/{AgreementLineId}/child/<name>. Add them to a GET with expand.

Use in AI Agent Studio

More in For Builders.

Pitfalls