ExpenseClaimReceipts
Allows for querying claimed receipts in Xero. It includes receipts submitted by employees for reimbursement under an expense claim.
View Specific Information
The ExpenseClaimReceipts view allows you to SELECT claimed receipt line items 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 draft receipts - to retrieve those, you will need to read from the Receipts 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 receipt is uniquely tracked and associated with the correct expense claim. |
| ExpenseClaimId | String | The unique identifier of the expense claim that this receipt belongs to. This field links the receipt to a specific expense claim, ensuring that the receipt is properly associated with the claim it supports. |
| ReceiptId | String | The unique Xero-generated identifier for the receipt. This ID is used to reference the specific receipt in the system and ensures that the receipt is distinguishable from others. |
| Date | Date | The date when the receipt was issued or received. This is crucial for accounting and reporting purposes, determining when the receipt's associated expense occurred. |
| Contact_ContactId | String | The unique identifier of the contact associated with the receipt. A contact must be specified when creating a receipt, linking the receipt to a specific customer or supplier. |
| Contact_Name | String | The name of the contact associated with the receipt. This provides a human-readable reference to the contact that the receipt pertains to. |
| LineItem_Description | String | The description of the item on the receipt. This typically includes details such as the goods or services purchased, providing context for the line item. |
| LineItem_UnitAmount | Decimal | The unit price for the item on the receipt. This is the cost per unit of the item, excluding tax, which is used to calculate the total line item amount. |
| LineItem_AccountCode | String | The account code for the associated account, categorizing the expense for financial reporting. The account code must be active and valid in the organization's chart of accounts. |
| LineItem_Quantity | Double | The quantity of the item purchased or billed in the line item. This must be a non-negative number, indicating how many units of the item are included in the transaction. |
| LineItem_TaxType | String | The tax type applied to the line item. This can be used to override the default tax rate for the account, ensuring that the appropriate tax is applied to the receipt line item. |
| LineItem_LineAmount | Decimal | The total value of the line item, calculated as 'UnitAmount x Quantity'. This represents the monetary value of the item before tax, but may include discounts if applicable. |
| LineItem_TrackingCategory1_CategoryId | String | The ID of the first tracking category associated with the line item. Xero allows for up to two optional tracking categories, which can be used for categorizing and reporting transactions. |
| LineItem_TrackingCategory1_CategoryName | String | The name of the first tracking category. This provides a label for the category, helping to identify how the line item is classified in reports. |
| LineItem_TrackingCategory1_OptionId | String | The ID of the option within the first tracking category. This links the line item to a specific option within the tracking category, providing additional classification for financial reporting. |
| LineItem_TrackingCategory1_OptionName | String | The name of the option selected within the first tracking category. This is the value associated with the option used to categorize the transaction. |
| LineItem_TrackingCategory1_Option_Stat | String | The status of the option selected within the first tracking category, indicating whether it is active or inactive for reporting purposes. |
| LineItem_TrackingCategory2_CategoryId | String | The ID of the second tracking category associated with the line item. Xero supports up to two tracking categories, allowing for additional classification of the line item. |
| LineItem_TrackingCategory2_CategoryName | String | The name of the second tracking category. This provides a label for the second level of categorization, which is used in conjunction with the first tracking category. |
| LineItem_TrackingCategory2_OptionId | String | The ID of the option selected within the second tracking category. This allows for further classification of the line item using a second tracking option. |
| LineItem_TrackingCategory2_OptionName | String | The name of the option selected within the second tracking category. This value helps to categorize the line item for more detailed financial analysis. |
| LineItem_TrackingCategory2_Option_Stat | String | The status of the option selected within the second tracking category, indicating whether it is active or inactive for reporting purposes. |
| LineItem_DiscountRate | Double | The discount percentage applied to the line item. This rate reduces the total value of the line item, allowing for customized discounting of receipts. |
| User_UserId | String | The unique identifier of the user within the organization who the expense claim receipt is for. This helps track who the receipt pertains to within the organization. |
| Reference | String | An optional field for adding a reference number or description related to the receipt. This field can be used for additional internal tracking or identification purposes. |
| LineAmountTypes | String | Specifies whether line amounts include tax. The valid values are 'Exclusive' (tax excluded), 'Inclusive' (tax included), or 'NoTax' (no tax applied). If not specified, line amounts are considered to exclude tax by default. |
| SubTotal | Decimal | The total amount of the receipt, excluding taxes. This is the sum of the 'LineItem_LineAmount' for all line items before tax is applied. |
| TotalTax | Decimal | The total tax applied to the receipt. This is calculated based on the applicable tax rate for each line item, indicating how much tax was charged. |
| Total | Decimal | The total value of the receipt, which is the sum of 'SubTotal' and 'TotalTax', representing the final amount of the receipt after tax. |
| Status | String | The current status of the receipt. Valid values include 'DRAFT' (unapproved), 'SUBMITTED' (submitted for approval), 'AUTHORiSED' (approved), and 'DECLINED' (rejected or voided). |
| ReceiptNumber | String | The Xero-generated number assigned to the receipt. This number helps track and uniquely identify the receipt within the system for the specific expense claim. |
| UpdatedDateUTC | Datetime | The date and time, in UTC, when the receipt was last updated in the system. This timestamp reflects any changes made to the receipt after its creation. |
| HasAttachments | Boolean | Indicates whether the receipt has any attachments, such as scanned receipts or supporting documents, linked to it in Xero. |
| URL | String | A link to an external source document associated with the receipt, such as a scanned image or other supporting files stored outside of Xero. |
| TenantId | String | The unique identifier for the tenant. This allows the query to access data specific to a particular tenant in multi-tenant environments, ensuring data isolation between tenants. |