Regions
Regions view for 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. 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 driver.
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. |