Excel Add-In for QuickBooks Online

Build 24.0.9060

TaxCodes

Create and query QuickBooks Sales Tax Codes.

Columns

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

The Id of the sales tax code.

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

The time the record was created.

MetaData_LastUpdatedTime Datetime True False True

The time the record was last updated.

Name String False False True

The name for the tax sales code.

Description String False False True

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

Active Boolean False False False

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

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

This field indicates whether the sales tax code is for a tax group.

SalesTaxRateList_TaxRateDetailAggregate String False False False

An XML aggregate of sales tax rates.

PurchaseTaxRateList_TaxRateDetailAggregate String False False False

An XML aggregate of purchase tax rates. This field available in only the UK, AU, and CA editions.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
TaxRateDetails String

Aggregate of TaxRateDetails. Used only for insert.

TaxApplicableOn String

Specifies where this tax rate can be applied. Possible values are 'Sales' or 'Purchase'.Used only for insert.

TaxRateName String

Name of a new tax rate.Used only for insert.

TaxAgencyId String

The Id of the agency to whom tax is paid.Used only for insert.

RateValue String

The tax rate value.Used only for insert.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060