Tableau Connector for Xero

Build 25.0.9434

HistoryExpenseClaims

Queries the history and notes of expense claims in Xero. This helps track all past activities related to employee expense reimbursements.

View Specific Information

The HistoryExpenseClaims view allows you to read the notes created on a expense claim, and the history of changes to that expense claim. If a ExpenseClaimId is not provided, the history of all ExpenseClaims will be retrieved.

Columns

Name Type Description
Id [KEY] String A unique identifier for the history item, combining its position in the history log with the timestamp of when the change occurred. This ensures that each history entry is distinctly identifiable and provides accurate tracking of changes over time.
ExpenseClaimId String The unique identifier of the expense claim to which this history item belongs. This field links the history entry to a specific expense claim, helping to track changes made to the claim.
Changes String Describes the type of change that occurred on the expense claim. This could include updates such as changes to the claim's status, amounts, or attached receipts, providing insight into the nature of the modification.
Date Datetime The exact timestamp of when the change occurred. This field records the time when the change was made, allowing for chronological tracking of modifications to the expense claim.
User String The name of the user who made the change. This field identifies the person responsible for altering the expense claim, ensuring accountability and transparency in the system.
Details String A detailed description of the specific change made to the expense claim. This could include specifics such as changes in the claim's amount, new receipts attached, or adjustments made to the claim.
TenantId String The unique identifier of the tenant. This ensures the query retrieves data specific to a particular tenant, which is important in multi-tenant environments where each tenant's data is isolated from others.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434