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 connector 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 connector.
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 |