Customers
Customers table for AvalaraAvatax data provider.
Select
To retrieve Customer records from Customers table, at least CompanyId or CompanyId and CustomerCode 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 CustomerCode fields 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 Customers WHERE CompanyId = '247015' SELECT * FROM Contacts WHERE CompanyId = 247015 AND CustomerCode = 'CC001'
Columns
| Name | Type | ReadOnly | Description |
| Id | Int | False |
Unique ID number of this customer. |
| CompanyId [KEY] | Int | False |
The unique ID number of the AvaTax company that recorded this customer. |
| CustomerCode [KEY] | String | False |
The unique code identifying this customer. Must be unique within your company. |
| AlternateId | String | False |
A customer-configurable alternate ID number for this customer. You may set this value to match any other system that would like to reference this customer record. |
| IsShip | Bool | False |
True if this customer record is specifically used for ship-to purposes. |
| LinkedShipTos | String | False |
A list of ship-to customer records that are connected to this bill-to customer. |
| Region | String | False |
ISO 3166 code identifying the region within the country. |
| IsBill | Bool | False |
True if this customer record is specifically used for bill-to purposes. |
| EmailAddress | String | False |
The main email address for this customer. |
| LinkedCustomFields | String | False |
A list of custom fields defined on this customer. |
| TaxpayerIdNumber | String | False |
For customers in the United States, this field is the federal taxpayer ID number. For businesses, this is a Federal Employer Identification Number. For individuals, this will be a Social Security Number. |
| ModifiedDate | Datetime | False |
The date/time when this record was last modified. |
| LinkedCertificates | String | False |
A list of exemption certficates that apply to this customer. |
| FaxNumber | String | False |
The fax phone number for this customer, if any. |
| AttnName | String | False |
Indicates the 'Attn' component of the address for this customer, if this customer requires mailings to be shipped to the attention of a specific person or department name. |
| PhoneNumber | String | False |
The main phone number for this customer. |
| PostalCode | String | False |
Postal Code / Zip Code component of the address of this customer. |
| Line2 | String | False |
Second line of the street address of this customer. |
| Line1 | String | False |
First line of the street address of this customer. |
| LastTransaction | Datetime | False |
Date when this customer last executed a transaction. |
| Country | String | False |
Name or ISO 3166 code identifying the country. |
| City | String | False |
City component of the street address of this customer. |
| LinkedExposureZones | String | False |
A list of exposure zones where you do business with this customer. |
| ContactName | String | False |
The name of the main contact person for this customer. |
| CreatedDate | Datetime | False |
The date when this record was created. |
| Name | String | False |
A friendly name identifying this customer. |