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 の制限 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |