Purchase Order Schedules for Trade Operations
purchaseOrderSchedulesForLandedCosts Based on 26C
Look up Purchase Order Schedules for Trade Operations, with shipment details and trade operation details. Read-only.
- Operations
- GET (list)GET (one)
- Record key
POLineLocationId- Required on create
- no create on this resource
- At a glance
- 40 fields1 finders2 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/purchaseOrderSchedulesForLandedCosts?fields=AssociatedCharges,Buyer,BuyerId,DeliveredToInventoryOrg,DeliveredToInventoryOrgId&limit=25&onlyData=true
{
"items": [
{
"AssociatedCharges": "<string, max 15>",
"Buyer": "<string, max 240>",
"BuyerId": 0,
"DeliveredToInventoryOrg": "<string, max 18>",
"DeliveredToInventoryOrgId": 0
}
],
"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 40
| Attribute | Type | Use |
|---|---|---|
AssociatedCharges | text · max 15 | Read-onlySearchable |
Buyer | text · max 240 | Read-onlySearchable |
BuyerId | number | Read-onlySearchable |
DeliveredToInventoryOrg | text · max 18 | Read-onlySearchable |
DeliveredToInventoryOrgId | number | Read-onlySearchable |
DestinationType | text · max 80 | Read-onlySearchable |
ExtendedPrecision | number | Read-onlySearchable |
IsChargeAssociated | text · max 80 | Read-onlySearchable |
LandedCostPOScheduleId | number | Read-onlySearchable |
NeedByDate | date | Read-onlySearchable |
OrderedQuantityInPrimaryUOM | number | Read-onlySearchable |
POApprovalDate | date | Read-onlySearchable |
POLineLocationId | number | Read-onlySearchable |
Precision | number | Read-onlySearchable |
ProcurementBU | text · max 240 | Read-onlySearchable |
ProcurementBUId | number | Read-onlySearchable |
ProfitCenterBU | text · max 240 | Read-onlySearchable |
ProfitCenterBUId | number | Read-onlySearchable |
PromisedDate | date | Read-onlySearchable |
PurchaseOrderCurrency | text · max 80 | Read-onlySearchable |
PurchaseOrderCurrencyCode | text · max 15 | Read-onlySearchable |
PurchaseOrderDescription | text · max 240 | Read-onlySearchable |
PurchaseOrderFunctionalCurrencyAmount | number | Read-onlySearchable |
PurchaseOrderHeaderId | number | Read-onlySearchable |
PurchaseOrderItemNumber | text · max 300 | Read-onlySearchable |
PurchaseOrderLineId | number | Read-onlySearchable |
PurchaseOrderLineNumber | text · max 40 | Read-onlySearchable |
PurchaseOrderNumber | text · max 255 | Read-onlySearchable |
PurchaseOrderScheduleNumber | text · max 40 | Read-onlySearchable |
RequisitioningBU | text · max 240 | Read-onlySearchable |
RequisitioningBUId | number | Read-onlySearchable |
ShipToLocation | text · max 30 | Read-onlySearchable |
ShipToLocationId | number | Read-onlySearchable |
Supplier | text · max 360 | Read-onlySearchable |
SupplierId | number | Read-onlySearchable |
SupplierSite | text · max 15 | Read-onlySearchable |
SupplierSiteId | number | Read-onlySearchable |
TaxExclusivePOPrice | number | Read-onlySearchable |
UnitOfMeasure | text · max 25 | Read-onlySearchable |
UnitOfMeasureCode | text · max 3 | 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 1
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findPurchaseOrderSchedules·bindActualAmountbindAssociatedChargesbindBuyerbindCaseSensitivePONumberbindChargeLineStatusbindChargeNamebindDeliverToInvOrgbindDestinationTypebindEstimatedAmountbindNeedByDatebindOrderedQuantitybindPOApprovalDatebindPODescriptionbindPOFunctionalCurrencyAmountbindPOItemNumberbindPOLineNumberbindPONumberbindPOSchedulebindProcurementBUbindProfitCenterBUbindPromisedDatebindQuantityReceivedbindQuantityShippedbindRequisitioningBUbindShipToLocationbindShipmentLineNumberbindShipmentNumberbindSupplierbindSupplierSitebindTaxExclusivePricebindTradeOperationNamebindTradeOperationNumber
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 2
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/purchaseOrderSchedulesForLandedCosts/{POLineLocationId}/child/<name>. Add them to a GET with expand.
shipmentDetailsGET Shipment Details · 13 fieldsItemDescriptionItemIdLineNumberPOHeaderIdPOLineIdPOLineLocationIdQuantityReceivedQuantityShippedReceiptNumberShipmentHeaderIdShipmentLineIdShipmentNumberShippedDatetradeOperationDetailsGET Trade Operation Details · 9 fieldsChargeLineNumberChargeLineStatusNameRequiredBUCurrencyCodeTotalActualAmountTotalEstimatedAmountTradeOperationIdTradeOperationNameTradeOperationNumber
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/purchaseOrderSchedulesForLandedCostsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findPurchaseOrderSchedulesfor 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:AssociatedCharges, notassociatedcharges. - 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.