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