Customers
List of customers for the business.
Table Specific Information
The 本製品 uses the Wave Financial API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. For example, the following queries are processed server side.SELECT
SELECT * FROM Customers WHERE Id = 'QnVzaW5lc3M6NjE2MtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdlO0N1c3RvbWVyOjMyNzkyMTY1' SELECT * FROM Customers WHERE BusinessId = 'QnVYtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdl' SELECT * FROM Customers WHERE ModifiedAt > '2019-10-30 07:14:55.0' AND ModifiedAt < '2019-10-30 07:18:03.0'
Columns
Name | Type | References | SupportedOperators | Description |
Id [KEY] | String | Unique identifier for the customer. | ||
BusinessId | String |
Businesses.id | The unique identifier for the business. | |
Name | String | Name or business name of the customer. | ||
FirstName | String | First name of the principal contact. | ||
LastName | String | Last name of the principal contact. | ||
String | Email of the principal contact. | |||
AddressAddressLine1 | String | Address line 1 (Street address/PO Box/Company name). | ||
AddressAddressLine2 | String | Address line 2 (Apartment/Suite/Unit/Building). | ||
AddressCity | String | City/District/Suburb/Town/Village. | ||
AddressProvinceCode | String |
Provinces.Code | [ISO 3166-2](https://en.wikipedia.org/wiki/ISO_3166-2) identifier. | |
AddressCountryCode | String |
Countries.Code | Country code. | |
AddressPostalCode | String | Zip/Postal Code. | ||
DisplayId | String | User defined id for the customer. Commonly referred to as Account Number. | ||
Mobile | String | Mobile telephone number of the principal contact. | ||
Phone | String | Telephone number of the customer. | ||
Fax | String | Fax number of the customer. | ||
TollFree | String | Toll-free number of the customer. | ||
Website | String | Website address of the customer. | ||
InternalNotes | String | Internal notes about the customer. | ||
CurrencyCode | String |
Currencies.Code | Currency code. | |
ShippingName | String | Name or business name of the customer. | ||
ShippingAddressLine1 | String | Address line 1 (Street address/PO Box/Company name). | ||
ShippingAddressLine2 | String | Address line 2 (Apartment/Suite/Unit/Building). | ||
ShippingAddressCity | String | City/District/Suburb/Town/Village. | ||
ShippingAddressProvinceCode | String |
Provinces.Code | [ISO 3166-2](https://en.wikipedia.org/wiki/ISO_3166-2) identifier. | |
ShippingAddressCountryCode | String |
Countries.Code | Country code. | |
ShippingAddressPostalCode | String | Zip/Postal Code. | ||
ShippingPhone | String | Telephone number of the customer. | ||
ShippingInstructions | String | Delivery instructions for handling. | ||
CreatedAt | Datetime | When the customer was created. | ||
ModifiedAt | Datetime | When the customer was last modified. | ||
IsArchived | Bool | Whether or not the customer is archived. |