JDBC Driver for Avalara

Build 22.0.8462

Tables

The driver models the data in Avalara into a list of tables that can be queried using standard SQL statements.

Generally, querying Avalara tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

CData JDBC Driver for Avalara Tables

Name Description
Accounts Accounts table for AvalaraAvatax data provider.
Batches Batches table for AvalaraAvatax data provider.
Companies Companies table for AvalaraAvatax data provider.
Contacts Contacts table for AvalaraAvatax data provider.
Customers Customers table for AvalaraAvatax data provider.
DataSources DataSources table for AvalaraAvatax data provider.
DistanceThresholds DistanceThresholds table for AvalaraAvatax data provider.
FilingCalendars FilingCalendars table for AvalaraAvatax data provider.
Items Items table for AvalaraAvatax data provider.
Locations Locations table for AvalaraAvatax data provider.
MultiDocument MultiDocument table for AvalaraAvatax data provider.
Nexus Nexus table for AvalaraAvatax data provider.
Notices Notices table for AvalaraAvatax data provider.
Notifications Notifications table for AvalaraAvatax data provider.
Settings Settings table for AvalaraAvatax data provider.
TaxCodes TaxCodes table for AvalaraAvatax data provider.
TaxRules TaxRules table for AvalaraAvatax data provider.
TransactionLines TransactionLines view for AvalaraAvatax data provider.
Transactions Transactions table for AvalaraAvatax data provider.
Upcs Upcs table for AvalaraAvatax data provider.
Users Users table for AvalaraAvatax data provider.

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