CData BizTalk Adapter for QuickBooks Online 2019 - Online Help
Questions / Feedback?

TaxRates

CData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354

Query QuickBooks Tax Rates.

Columns

Name Type References Description
Id [KEY] String The Id of the tax rate.
SyncToken String The sync token. This must be specified when executing an update or delete.
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 rate.
Description String A description for the sales tax rate. This field must not contain white space or formatting characters.
Active Boolean This field sets whether the tax rate is active. This value is false if inactive. Inactive sales tax codes may be hidden from display and are not used on financial transactions.
RateValue String The value of the tax rate.
AgencyRef String

TaxAgency.Id

The Id of the tax agency.
AgencyRef_Name String

TaxAgency.DisplayName

The name of the tax agency.
TaxReturnLineRef String The Id of the tax return line.
TaxReturnLineRef_Name String The name of the tax return line.
SpecialTaxType String The special tax type to handle zero-rate taxes. VAT-registered businesses who receive goods, services, or acquisitions from other EU countries will need to calculate the VAT due, but not paid, on these acquisitions. The rate of VAT that is payable is the same that would have been paid if the goods had been supplied by a UK supplier.
DisplayType String The display type of the tax rate. This field is used to configure display settings.
EffectiveTaxRate Double The effective tax rate. This field is used to know which tax rate is applicable on any date.

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