Regions
Regions view for 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. Most columns except for LocalizedNames support server side filtering with the following operators: =,>,<,<=,>=,IN,NOT,IN,AND,OR,LIKE. The rest of the filter is executed client side within the add-in.
For example, the following query is processed server side:
SELECT * FROM Regions where CountryCode='US' AND IsRegionTaxable=false AND Code!='MT' AND (Name LIKE '%KA' OR NAME LIKE 'OR%')
Columns
| Name | Type | Description |
| CountryCode | String | The two-character ISO 3166 country code this region belongs to. |
| Code | String | The three-character ISO 3166 region code. |
| Name | String | The full name, in uppercase, using localized characters specific to this region. |
| LocalizedNames | String | A list of localized names in various languages. |
| Classification | String | The term used in the local language that describes this region. |
| IsRegionTaxable | Bool | Indicates whether the region collects tax. This field is only populated for the US and is null for all other countries. |
| StreamlinedSalesTax | Bool | In the US, this flag indicates whether a state participates in the Streamlined Sales Tax program. For countries outside the US, this flag is null. |