AgedReceivablesByContact
Query Aged Receivables for a Contact.
Table-Specific Information
SELECT
If the ContactId is not provided, the Aged Receivables 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 invoice is created. |
| Reference | String | Sale 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. Is empty if multi-currency is not in use. |
| 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. |
| 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. |