Purchase Agreement Lines
purchaseAgreementLines Based on 26C
Look up Purchase Agreement Lines, with item attributes and price breaks. Read-only.
- Operations
- GET (list)GET (one)
- Record key
AgreementLineId- Required on create
- no create on this resource
- At a glance
- 65 fields2 finders7 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/purchaseAgreementLines?fields=AgingPeriodDays,AgreementAmount,AgreementHeaderId,AgreementLineId,AgreementNumber&limit=25&onlyData=true
{
"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
| Attribute | Type | Use |
|---|---|---|
AgingPeriodDays | number | Read-onlySearchable |
AgreementAmount | number | Read-onlySearchable |
AgreementHeaderId | number | Read-onlySearchable |
AgreementLineId | number | Read-onlySearchable |
AgreementNumber | text · max 30 | Read-onlySearchable |
AgreementQuantity | number | Read-onlySearchable |
AllowItemDescriptionUpdateFlag | yes/no · max 1 | Read-onlySearchable |
AllowPriceOverrideFlag | yes/no · max 1 | Read-onlySearchable |
Amount | number | Read-onlySearchable |
Category | text · max 2400 | Read-onlySearchable |
CategoryCode | text · max 820 | Read-onlySearchable |
CategoryId | number | Read-onlySearchable |
ConsignmentLineFlag | yes/no · max 1 | Read-onlySearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
Currency | text · max 80 | Read-onlySearchable |
CurrencyCode | text · max 15 | Read-onlySearchable |
Description | text · max 240 | Read-onlySearchable |
ExpirationDate | date | Read-onlySearchable |
HazardClass | text · max 40 | Read-onlySearchable |
HazardClassCode | text · max 30 | Read-onlySearchable |
HazardClassId | number | Read-onlySearchable |
Item | text · max 255 | Read-onlySearchable |
ItemId | number | Read-onlySearchable |
ItemRevision | text · max 18 | Read-onlySearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LineNumber | number | Read-onlySearchable |
LineStartDate | date | Read-onlySearchable |
LineType | text · max 30 | Read-onlySearchable |
LineTypeId | number | Read-onlySearchable |
MinimumReleaseAmount | number | Read-onlySearchable |
NegotiatedFlag | yes/no · max 1 | Read-onlySearchable |
NoteToSupplier | text · max 1000 | Read-onlySearchable |
ParentItem | text · max 255 | Read-only |
ParentItemId | number | Read-onlySearchable |
PimItemCategory | text · max 255 | Read-onlySearchable |
PimItemCategoryCode | text · max 255 | Read-onlySearchable |
PimItemCategoryId | number | Read-onlySearchable |
PimItemDescription | text · max 255 | Read-onlySearchable |
Price | number | Read-onlySearchable |
PriceBreakType | text · max 80 | Read-only |
PriceBreakTypeCode | text · max 25 | Read-onlySearchable |
PriceLimit | number | Read-onlySearchable |
ProcurementBU | text · max 255 | Read-onlySearchable |
ProcurementBUId | number | Read-onlySearchable |
PurchaseBasis | text · max 30 | Read-only |
ReleasedAmount | number | Read-onlySearchable |
Status | text · max 80 | Read-onlySearchable |
StatusCode | text · max 25 | Read-onlySearchable |
Supplier | text · max 255 | Read-onlySearchable |
SupplierId | number | Read-onlySearchable |
SupplierItem | text · max 300 | Read-onlySearchable |
SupplierItemAuxiliaryIdentifier | text · max 255 | Read-onlySearchable |
SupplierParentItem | text · max 300 | Read-onlySearchable |
SupplierSite | text · max 255 | Read-onlySearchable |
SupplierSiteId | number | Read-onlySearchable |
SupplierTopModel | text · max 300 | Read-onlySearchable |
TopModel | text · max 255 | Read-only |
TopModelId | number | Read-onlySearchable |
UNNumberDescription | text · max 240 | Read-onlySearchable |
UOM | text · max 25 | Read-onlySearchable |
UOMCode | text · max 3 | Read-onlySearchable |
UnNumber | text · max 20 | Read-onlySearchable |
UnNumberId | number | Read-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.
filterByLineStartDate·BindNeedByDatefilterByLineStartDateWithTimezone·BindNeedByDateBindShipToOrgIdBindSoldToLeIdBindTzSysdateisLineStartDateProfileEnabled
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.
DFFGET Descriptive Flexfields · 3 fieldsPoLineId__FLEX_Context__FLEX_Context_DisplayValueattachmentsGET Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameitemAttributesGET Item Attributes · 28 fieldsAliasAttachmentURLAttributeValuesIdAttributeValuesTlpIdAvailabilityCommentsCreatedByCreationDateHazardClassHazardClassCodeHazardClassIdImageURLLastUpdateDateLastUpdatedByLeadTimeDaysLongDescriptionManufacturerManufacturerPartNumberManufacturerURLPackagingStringRoundingFactorSupplierPartAuxidSupplierURLThumbnailImageURLUNNumberUNNumberDescriptionUNNumberIdUNSPSCDFFGET Agreement Line Item DFF · 3 fieldsAttributeValuesId__FLEX_Context__FLEX_Context_DisplayValuepriceBreaksGET Price Breaks · 22 fieldsCreatedByCreationDateCurrencyCurrencyCodeDiscountPercentEndDateLastUpdateDateLastUpdatedByLineNumberLocationLocationCodeLocationIdPricePriceBreakIdPriceBreakNumberQuantityShipToOrganizationShipToOrganizationCodeShipToOrganizationIdStartDateUOMUOMCodeDFFGET Descriptive Flexfields · 3 fieldsLineLocationId__FLEX_Context__FLEX_Context_DisplayValueattachmentsGET Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserName
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/purchaseAgreementLinesand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
filterByLineStartDatefor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AgingPeriodDays, notagingperioddays. - Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.