Read purchase order by ID

Reads detailed information about a specific purchase order identified by its ID. This includes line items, costs, and approval status.

Use the WHERE id=... clause to filter for a specific purchase order. Replace 111112345 with the purchase order ID.

SELECT * FROM PurchaseOrders WHERE id=111112345