ExpenseClaimPayments
Allows querying the payments made for expense claims within a Xero organization. It tracks reimbursements made to employees for work-related expenses.
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 | A unique identifier for the line item, combining the line item index with the Xero-generated identifier for the expense claim. This ensures that each payment can be uniquely identified in the system. |
| ExpenseClaimId | String | The unique identifier of the expense claim that this payment belongs to. This links the payment directly to a specific expense claim, allowing for proper tracking and reconciliation of expenses. |
| Date | Date | The date the payment is made. This field reflects when the payment was processed, and it is essential for tracking the timing of payments made against the expense claim. |
| Amount | Decimal | The amount of the payment being made. This value must be equal to or less than the outstanding balance owed on the expense claim, ensuring that payments do not exceed the amount owed. |
| Reference | String | An optional field for adding a reference or description for the payment. This could be used for internal tracking, such as invoice numbers or notes related to the payment. |
| AccountId | String | The unique identifier of the account used to make the payment. This account must be of type 'BANK' or have payments enabled, ensuring that funds can be properly allocated from the correct financial source. |
| AccountCode | String | The account code of the account from which the payment is made. This code is used to categorize the transaction in the financial system, ensuring the correct account is used. |
| AccountName | String | The name of the account used for the payment. This provides a human-readable label for the account, which can help users quickly identify the source of the payment. |
| TenantId | String | The unique identifier for the tenant. This allows queries to access data specific to a particular tenant in multi-tenant environments, ensuring the payment is recorded under the correct tenant's account. |