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