Businesses
List businesses.
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 name FROM Businesses WHERE Id = 'QnVzaW5lc3M6MDU3MWUwYWYtGI3LWE1ZTAtNmYyNzU4N2IwNGNi'
Columns
Name | Type | References | SupportedOperators | Description |
Id [KEY] | String | The unique identifier for the business. | ||
Name | String | The name of the business. | ||
IsPersonal | Bool | Is the business a personal one with limited functionality compared to regular businesses. | ||
OrganizationalType | String | The organization type of the business. | ||
TypeName | String | The description of the business type in human-friendly form. | ||
TypeValue | String | The enum value of the business type. | ||
SubtypeName | String | The description of the business subtype in human-friendly form. | ||
SubtypeValue | String | The enum value of the business subtype. | ||
CurrencyCode | String |
Currencies.Code | Currency code. | |
Timezone | String | The timezone of the business. | ||
AddressLine1 | String | Address line 1 (Street address/PO Box/Company name). | ||
AddressLine2 | 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. | ||
Phone | String | The phone number of the business. | ||
Fax | String | The fax number of the business. | ||
Mobile | String | The mobile/cell number of the business. | ||
TollFree | String | The toll free number of the business. | ||
Website | String | The website of the business. | ||
IsArchived | Bool | Is the business hidden from view by default. | ||
CreatedAt | Datetime | When the business was created. | ||
ModifiedAt | Datetime | When the business was last modified. |