TaxRatesByZipCode
Retrieve estimated tax rates by zip code for a specific date using the Avalara Avatax data provider.
Select
The add-in 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 add-in.
- 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. |