CustomerExposureZones
CustomerExposureZones view for AvalaraAvatax data provider.
Select
To retrieve records from CustomerExposureZones view, at least CompanyId or CompanyId and CompanyCode should be specified in the WHERE clause. The add-in will use the Avalara API to process WHERE clause conditions built with the following columns and operators. CompanyId and CompanyCode support server side filtering with the = operator. The rest of the filter is executed client side within the add-in.
For example, the following query is processed server side:
SELECT * FROM CustomerExposureZones WHERE CompanyId = '247015' AND CustomerCode = 'CC001'
Columns
| Name | Type | Description |
| Id | Int | A unique ID number representing this exposure zone. |
| CompanyId [KEY] | Int | The unique ID number of the AvaTax company that recorded this customer. |
| CustomerCode [KEY] | String | The customer code this record is associated to. |
| Name | String | The short name of this exposure zone, suitable for use in a drop-down list. |
| Country | String | Two character ISO 3166 county code for the country component of this exposure zone. |
| Created | Datetime | The date when this record was created. |
| Region | String | Two or three character ISO 3166 region, province, or state name of this exposure zone. |
| Description | String | A more complete description of this exposure zone, suitable for use as a tooltip or help text. |
| Modified | Datetime | The date/time when this record was last modified. |
| Tag | String | A tag indicating |