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.
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. |