TDV Adapter for Avalara

Build 21.0.8137

CustomerCustomFields

CustomerCustomFields view for AvalaraAvatax data provider.

Select

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'

Columns

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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137