HistoryPurchaseOrders
Used to query and insert the history and notes of purchase orders within Xero. This helps track the lifecycle of purchase orders.
Table Specific Information
The HistoryPurchaseOrders table allows you to read the notes created on a purchase order, and the history of changes to that purchase order. If a PurchaseOrderId is not provided, the history of all PurchaseOrders will be retrieved.
A PurchaseOrderId and Details is required for inserting a note:
INSERT INTO HistoryPurchaseOrders (PurchaseOrderId, Details) VALUES ('...', 'Rescheduled delivery for October 9th'),
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
A unique identifier for the history item, combining its position in the history log with the timestamp of when the change occurred. This ensures each history entry is distinctly identifiable, enabling precise tracking of changes to the purchase order. |
| PurchaseOrderId | String | False |
The unique identifier of the purchase order that this history item belongs to. This field links the history entry to a specific purchase order, ensuring the changes made to that order are tracked. |
| Changes | String | True |
Describes the type of change that occurred on the purchase order. This could include updates to the order's amount, status, items, or delivery details, providing insight into the nature of the modification. |
| Date | Datetime | True |
The timestamp of when the change occurred. This field records the exact time the modification was made, ensuring a clear and accurate record of changes over time. |
| User | String | True |
The name of the user who made the change. This identifies the individual responsible for the modification, ensuring accountability and transparency for updates to the purchase order. |
| Details | String | False |
A detailed description of the specific change made to the purchase order. This includes information on what was altered, such as item adjustments, quantity changes, or status updates. |
| TenantId | String | False |
The unique identifier of the tenant. This ensures the query retrieves data specific to a particular tenant in multi-tenant environments, isolating the changes to the correct organization's data. |