PostalCodes
PostalCodes 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 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 driver.
- 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. |