AgedPayablesByContact
Query Aged Payables for a Contact.
Table-Specific Information
SELECT
If the ContactId is not provided, the Aged Payables report for all contacts will be returned, one after the other. Please note that this will generate one operation against the Xero API per contact in the organization. Consider filtering to a subset of contacts or adding a LIMIT clause to avoid exceeding API limits. See Xero API Limits for more information.
Columns
| Name | Type | Description |
| ID [KEY] | String | The row number, combined with the contact ID. |
| ContactId | String | The ID of the contact this is reporting on. |
| Date | Datetime | The Date the bill is created. |
| Reference | String | Purchase order reference for this bill. |
| DueDate | Datetime | Date the amount is due. |
| Overdue | Decimal | Amount due passed due date. |
| Currency | String | The currency used for all fields but DueLocal, or empty if the default currency is used |
| Total | Decimal | Total amount due. |
| Paid | Decimal | Amount paid. |
| Credited | Decimal | Amount credited. |
| Due | Decimal | Amount due. |
| DueLocal | Decimal | Amount due in the default organisation currency. |
| InvoiceId | String | The invoice for this bill. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| fromDate | Datetime | Show all payable invoices from this date for contact. |
| toDate | Datetime | Show all payable invoices to this date for the contact. |