JDBC Driver for Xero

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462