Power BI Connector for QuickBooks Online

Build 22.0.8678

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, CA, and IN editions.

Pseudo-Columns

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

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8678