TaxRatesByZipCode
Retrieve estimated tax rates by zip code for a specific date using the Avalara Avatax data provider.
Select
The driver will use the Avalara API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- StateAbbreviation supports the '=' comparison operator.
- Date supports the '=' comparison operator.
SELECT * FROM TaxRatesByZipCode WHERE StateAbbreviation='NY' AND Date='2020-01-01'
Columns
| Name | Type | Description |
| ZipCode [KEY] | String | The five digit zip code for this record. |
| StateAbbreviation | String | A valid two-character US state abbreviation for this record. |
| CountyName | String | A valid county name for this record. Zip codes may span multiple counties. |
| CityName | String | A valid city name for this record. Zip codes may span multiple cities. |
| StateSalesTax | Decimal | The state component of the sales tax rate. |
| StateUseTax | Decimal | The state component of the use tax rate. |
| CountySalesTax | Decimal | The county component of the sales tax rate. |
| CountyUseTax | Decimal | The county component of the use tax rate. |
| CitySalesTax | Decimal | The city component of the sales tax rate. |
| CityUseTax | Decimal | The city component of the use tax rate. |
| TotalSalesTax | Decimal | The total sales tax rate for this postal code. This value may differ from the sum of state, county, and city taxes due to special jurisdiction rules. |
| TotalUseTax | Decimal | The total use tax rate for this postal code. This value may differ from the sum of state, county, and city rates due to special tax jurisdiction rules. |
| TaxShippingAlone | Bool | Whether shipping is taxable. |
| TaxShippingAndHandlingTogether | Bool | Whether shipping and handling are taxable when sent together. |
| Date | Date | The date for which the point-of-sale data is calculated. Defaults to today. |