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 |