ExpenseClaimPayments
Query payments for a Xero organisation.
View Specific Information
The ExpenseClaimPayments view allows you to SELECT payments to different expense claims for a Xero organization. The Id column is generated by the connector; it combines the index of the line item with the unique, Xero-generated ExpenseClaimID.
Note that this table does not include other types of Payments - to retrieve those, you will need to read from the Payments table.
SELECT
The Xero API allows extensive filtering and ordering. You can define WHERE and ORDER BY clauses in a query to filter and order the results using any non-line-item column.
Note: The Xero API does not support filtering on line items or journal lines.
Columns
| Name | Type | Description |
| Id [KEY] | String | The line item index combined with the unique, Xero-generated identifier for the expense claim. |
| ExpenseClaimId | String | The ID of the expense claim that this payment belongs to |
| Date | Date | The date the payment is being made. |
| Amount | Decimal | The amount of the payment. This value must be less than or equal to the outstanding amount owing on the expense claim. |
| Reference | String | A optional description for the payment. |
| AccountId | String | The Id of the account used to make the payment. The account type must be BANK or payments to the account must be enabled. |
| AccountCode | String | The account code of the account used to make the payment. |
| AccountName | String | The account code of the account used to make the payment. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |