Excel Add-In for Avalara

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060