ODBC Driver for QuickBooks Online

Build 20.0.7587

TaxCodes

Query QuickBooks Sales Tax Codes.

Columns

Name Type References Description
Id [KEY] String The Id of the sales tax code.
SyncToken String Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.
MetaData_CreateTime Datetime The time the record was created.
MetaData_LastUpdatedTime Datetime The time the record was last updated.
Name String The name for the tax sales code.
Description String A description for the sales tax code. This field must not contain white space or formatting characters.
Active Boolean This field sets whether the sales tax code entity is active. Inactive sales tax codes may be hidden from display and are not used on financial transactions.
Taxable Boolean This field indicates that the sales tax code signifies a non-taxable entity if false or null (default) or a taxable entity if true.
TaxGroup Boolean This field indicates whether the sales tax code is for a tax group.
SalesTaxRateList_TaxRateDetailAggregate String An XML aggregate of sales tax rates.
PurchaseTaxRateList_TaxRateDetailAggregate String An XML aggregate of purchase tax rates. This field available in only the UK, AU, CA, and IN editions.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587