List All Purchase Order Details¶
Returns all purchase order detail lines across all purchase orders. Useful for bulk exports or cross-PO analysis.
Request¶
Required privilege: Procurement / Edit
Example Request¶
Response¶
Returns the same detail line structure as the details array in Get Purchase Order, but spanning all POs.
Response Body¶
{
"data": {
"headers": [
{ "key": "Item Number", "format": "string-link" },
{ "key": "Item Description", "format": "string" },
{ "key": "PO Details Document Status", "format": "string", "alias": "Status" },
{ "key": "Warehouse Number", "format": "string-link", "alias": "Warehouse #" },
{ "key": "PO Details Tracking", "format": "string", "alias": "BOL #" },
{ "key": "PO Details Order Date", "format": "date" },
{ "key": "PO Details Ship Date", "format": "date" },
{ "key": "PO Details ETA Date", "format": "date" },
{ "key": "PO Details Price", "format": "currency" },
{ "key": "PO Details Quantity", "format": "number" }
],
"rows": [
{
"id": 101,
"Item Id": 55,
"Item Number": "ITEM-A",
"Item Description": "Widget Assembly - Type A",
"Sub Item Id": null,
"Sub Item Number": null,
"Warehouse Id": 3,
"Warehouse Number": "WH-01",
"Warehouse Name": "Main Distribution Center",
"Ship From Id": 8,
"Ship From Number": "SF-01",
"Ship From Name": "Acme East Plant",
"PO Details Tracking": "BOL-789456",
"PO Details Price": 12.50,
"PO Details Quantity": 200,
"PO Details Order Date": "2024-03-01",
"PO Details Ship Date": "2024-03-08",
"PO Details ETA Date": "2024-03-15",
"PO Details First Promise Date": "2024-03-14",
"PO Details Request Date": null,
"PO Details Actual Ship Date": null,
"PO Details Actual Delivery Date": null,
"PO Details Document Status": "Open",
"PO Details Unique Id": "UNIQ-001",
"PO Details Servicenow Id": null
}
]
},
"tags": {},
"extra": {}
}
Related¶
- Get Purchase Order - Detail lines scoped to a single PO
- Delete Detail Line