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