PostalCodes
PostalCodes 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 of the columns 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.
- IncludeExpiredPostalCodes supports the '=' comparison operator.
SELECT * FROM PostalCodes WHERE EffectiveDate >= '2018-09-01' AND EffectiveDate <= '2022-02-01' AND Region='NY' AND TaxRegionId IN ('4001027','4001022')
SELECT * FROM PostalCodes WHERE IncludeExpiredPostalCodes = true
Columns
| Name | Type | Description |
| PostalCode [KEY] | String | The postal code. |
| Country | String | The country in which this postal code is located. |
| Region | String | The region, state, or province where this postal code is located. |
| TaxRegionId | Int | An Avalara-assigned tax region Id associated with the postal code. |
| EffectiveDate | Date | The date the postal code becomes active. |
| EndDate | Date | The date the postal code expires. |
| IncludeExpiredPostalCodes | Bool | If set to true, returns expired postal codes. Defaults to false. |