ExpenseClaimReceipts
Query claimed receipts for a Xero organisation.
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 | 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 receipt belongs to |
| ReceiptId | String | The unique, Xero-generated identifier for the receipt. |
| Date | Date | The date of the receipt. |
| Contact_ContactId | String | The Id of the contact. A contact must be specified when creating a receipt. |
| Contact_Name | String | The name of the contact. |
| LineItem_Description | String | The description for the item. |
| LineItem_UnitAmount | Decimal | The unit amount of the item. |
| LineItem_AccountCode | String | The code for the associated account. |
| LineItem_Quantity | Double | The quantity of the item. |
| LineItem_TaxType | String | The tax type. This field can be used to override the default tax code for the selected account. |
| LineItem_LineAmount | Decimal | The total of the unit amount multiplied by the quantity. |
| LineItem_TrackingCategory1_CategoryId | String | The Id of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory1_CategoryName | String | The name of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory1_OptionId | String | The Id of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory1_OptionName | String | The option of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory1_Option_Stat | String | The status of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory2_CategoryId | String | The Id of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory2_CategoryName | String | The name of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory2_OptionId | String | The Id of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory2_OptionName | String | The option of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_TrackingCategory2_Option_Stat | String | The status of a tracking category. The API allows two optional tracking categories to be defined. |
| LineItem_DiscountRate | Double | The percentage discount being applied to the line item. |
| User_UserId | String | The user in the organisation that the expense claim receipt is for. |
| Reference | String | Additional reference number. |
| LineAmountTypes | String | This field specifies whether line amounts include tax (default). When this field is not specified, line amounts totals do not include tax. The valid values are Exclusive, Inclusive, and NoTax. |
| SubTotal | Decimal | The total, excluding taxes, of the receipt. |
| TotalTax | Decimal | The total tax on the receipt. |
| Total | Decimal | The total of the receipt -- the sum of SubTotal plus TotalTax. |
| Status | String | The current status of the receipt. The valid status types are DRAFT, SUBMITTED, AUTHORISED, and DECLINED. |
| ReceiptNumber | String | The Xero-generated number of the receipt in sequence in the current claim for the given user. |
| UpdatedDateUTC | Datetime | The date when the receipt was last updated. |
| HasAttachments | Boolean | This field indicates whether the receipt has attachments. |
| URL | String | A link to a source document. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |