TDV Adapter for Avalara

Build 22.0.8462


CustomerCustomFields view for AvalaraAvatax data provider.


To retrieve records from CustomerCustomFields view, at least CompanyId or CompanyId and CompanyCode should be specified in the WHERE clause. The adapter 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 adapter. For example, the following query is processed server side:

SELECT * FROM CustomerCustomFields WHERE CompanyId = '247015' AND CustomerCode = 'CC001'


Name Type Description
CompanyId [KEY] String The company Id of the parent record.
CustomerCode [KEY] String The customer code this record is associated to.
Name String The name of the custom field.
Value String The value of the custom field.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462