ExpenseClaimReceipts

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

Last updated