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