ADO.NET Provider for QuickBooks Online

Build 22.0.8678

TaxRates

Create and query QuickBooks Tax Rates.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True True True

The Id of the tax rate.

SyncToken String True False False

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 True True True

The time the record was created.

MetaData_LastUpdatedTime Datetime True True True

The time the record was last updated.

Name String False True False

The name for the tax rate.

Description String False True True

A description for the sales tax rate. This field must not contain white space or formatting characters.

Active Boolean False True False

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 False True True

The value of the tax rate.

AgencyRef String False

TaxAgency.Id

True True

The Id of the tax agency.

AgencyRef_Name String True

TaxAgency.DisplayName

False False

The name of the tax agency.

TaxReturnLineRef String False True True

The Id of the tax return line.

TaxReturnLineRef_Name String True False False

The name of the tax return line.

SpecialTaxType String False False False

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 False False False

The display type of the tax rate. This field is used to configure display settings.

EffectiveTaxRate Double False False False

The effective tax rate. This field is used to know which tax rate is applicable on any date.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
TaxRateDetails String

The Tax Rate Details.Used only for insert.

TaxCode String

The name for the tax code.Used only for insert.

TaxApplicableOn String

The Tax rate applicability. Values can be 'Sales or 'Purchase'. Used only for Insert.

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