TaxRatesByAddress
Retrieve real-time estimated tax rates based on an address 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.
- PostalCode supports the '=' comparison operator.
- Region supports the '=' comparison operator.
- City supports the '=' comparison operator.
- Line1 supports the '=' comparison operator.
- Line2 supports the '=' comparison operator.
- Line3 supports the '=' comparison operator.
SELECT * FROM TaxRatesByAddress WHERE PostalCode='99950' AND Region='AK' AND City='KETCHIKAN' AND Line1='Whale Pass'
Columns
| Name | Type | Description |
| Rate | Decimal | The sales tax rate for general tangible personal property in this jurisdiction. |
| Name | String | A readable name of the tax or taxing jurisdiction related to this tax rate. |
| Type | String | The type of jurisdiction associated with this tax rate. |
| PostalCode | String | The postal code of the location. |
| Region | String | Name or ISO 3166 code identifying the region within the country. |
| City | String | The city name of the location. |
| Line1 | String | The street address of the location. |
| Line2 | String | The street address of the location. |
| Line3 | String | The street address of the location. |