Tableau Connector for QuickBooks Online

Build 25.0.9434

TaxAgency

Stores tax-agency records that are used in QuickBooks Online to define the government authorities to which sales tax is remitted.

Columns

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

The unique identifier (Id) that is assigned by QuickBooks Online to this tax agency record. It is used to retrieve or reference the tax agency programmatically and is required for updates or deletions.

SyncToken String True False False

The version control token for this tax agency record that is used to prevent conflicting updates. QuickBooks Online increments this sync token each time the record is modified, and only the latest sync token is accepted for edits.

MetaData_CreateTime Datetime True True True

The date and time stamp (Coordinated Universal Time) when QuickBooks Online created this tax agency record.

MetaData_LastUpdatedTime Datetime True True True

The date and time stamp (Coordinated Universal Time) when this tax agency record was last modified in QuickBooks Online.

DisplayName String False False False

The display name for the tax agency that is shown within QuickBooks Online.

TaxRegistrationNumber String True False False

The registration number that is assigned to this tax agency by the relevant tax authority.

TaxTrackedOnPurchases Boolean True False False

Indicates whether this tax agency is used to track tax on purchases. Typically, this field is true for agencies that are responsible for receiving purchase-related taxes.

TaxTrackedOnSales Boolean True False False

Indicates whether this tax agency is used to track tax on sales. Typically, this field is true for agencies that are responsible for receiving sales-related taxes.

LastFileDate Date True False False

The most recent tax filing date for this tax agency. This field is automatically populated by QuickBooks Online business logic at the time of tax filing.

TaxAgencyConfig String True False False

Indicates whether this tax agency record is system defined by the Automated Sales Tax engine or is user generated. This flag helps differentiate QuickBooks Online default agencies from agencies created manually by a user.

The allowed values are USER_DEFINED, SYSTEM_GENERATED, HIDDEN_AGENCY.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434