Quotes
Query quotes for a Xero organization
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 |