Quotes

Columns

Name

Type

Description

Id [KEY]

String

The line item index combined with the Id of the Quote.

QuoteId

String

The Id of the Quote. This field is assigned by Xero.

ContactId

String

The Id of the contact.

ContactName

String

The name of the contact.

Date

Date

The date the quote was issued.

ExpiryDate

Date

The date the quote expires.

Status

String

The status of the quote.

LineItem_LineItemId

String

The Xero generated identifier for a line item.

LineItem_Description

String

The description of the line item.

LineItem_Quantity

Double

The quantity of the associated item in the line item.

LineItem_UnitAmount

Decimal

The unit amount of the associated item in the line item.

LineItem_ItemCode

String

The code that identifies the associated item.

LineItem_AccountCode

String

The account code. This must be active for the organisation.

LineItem_TaxType

String

The tax type. This field is used to override AccountCode, the default tax code for the selected account.

LineItem_TaxAmount

Decimal

The automatically calculated percentage of tax, based on the tax rate, for the line amount.

LineItem_LineAmount

Decimal

The total of the quantity multiplied by the unit amount with any discounts applied.

LineItem_DiscountRate

Double

The discount percentage being applied to the line item.

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_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.

QuoteNumber

String

The unique, alphanumeric code identifying the quote.

LineAmountTypes

String

This field specifies whether line amounts include tax. The valid values are Exclusive, Inclusive, and NoTax.

Reference

String

An additional reference number for ACCREC-type invoices.

CurrencyCode

String

The ISO 4217 currency code.

CurrencyRate

Decimal

The currency rate for a multicurrency invoice. If no rate is specified, the XE.com day rate is used.

SubTotal

Decimal

The subtotal for the invoice, which excludes taxes.

TotalTax

Decimal

The total tax for the invoice.

Total

Decimal

The total for the invoice, including tax -- the sum of SubTotal and TotalTax.

TotalDiscount

Decimal

Total of discounts applied on the invoice line items.

BrandingThemeId

String

The Id of the branding theme.

Terms

String

The terms of the quote.

UpdatedDateUTC

Datetime

The date when the invoice was last updated.

TenantId

String

The ID of the tenant to query instead of the connection tenant

Last updated