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