Power BI Connector for QuickBooks

Build 24.0.9060

SalesTaxItems

Create, update, delete, and query QuickBooks Sales Tax Items.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier.

Name String False 31

The name of the other name. This is required to have a value when inserting.

IsActive Boolean False

Whether or not the other name is active.

ClassRef_FullName String False 1000

A reference to the class of the transaction. Requires QBXML version 12.0 or later.

ClassRef_ListID String False

Class.ID

255

A reference to the class of the transaction. Requires QBXML version 12.0 or later.

ItemDesc String False 4096

A description for the sales tax item.

TaxRate Double False

The tax rate. If a nonzero TaxRate is specified, then TaxVendorRef is required.

TaxVendorRef_FullName String False 1000

Refers to the tax agency to whom collected taxes are owed. This will be a vendor on the vendor list.

TaxVendorRef_ListID String False

Vendors.ID

255

Refers to the tax agency to whom collected taxes are owed. This will be a vendor on the vendor list.

CustomFields String False

Custom fields returned from QuickBooks and formatted into XML.

EditSequence String True 16

An identifier used for versioning for this copy of the object.

TimeModified Datetime True

When the sales tax item was last modified.

TimeCreated Datetime True

When the sales tax item was created.

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