Organizations
Query information regarding different organizations.
View-Specific Information
Select
The driver processes filters client-side within the driver. 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 not be filtered.
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique numeric identifier for the organization. |
| CompanyName | String | The name of the company for this organization. |
| PrimaryEmail | String | The primary email of the organization. |
| Phone | String | The phone number of the organization. |
| Mobile | String | The mobile phone number of the organization. |
| IsoCode | String | The ISO code of the organization. |
| Description | String | The description of the organization. |
| Country | String | The country where this organization is situated. |
| City | String | The city where this organization is situated. |
| State | String | The state where this organization is situated. |
| Street | String | The street where this organization is situated. |
| Zip | String | The zip where this organization is situated. |
| CountryCode | String | The country code of the organization. |
| Alias | String | The alias of the organization. |
| Fax | String | The fax of the organization. |
| EmployeeCount | Int | The number of employees this organization has. |
| Website | String | The website of the organization. |
| CurrencySymbol | String | The default currency symbol for the organization. |
| CurrencyLocale | String | The default currency locale for the organization. |
| PrimaryZuid | String | The primary ZUID for the organization. |
| TimeZone | String | The time zone for the organization. |
| Zgid | String | The zgid for the organization. |
| MCStatus | Boolean | Whether this organization has MC status or not. |
| GappsEnabled | Boolean | Whether this organization has gapps enabled or not. |
| LicenseDetailsPaidExpiry | Datetime | The date and time the subscription expires for this organization. |
| LicenseDetailsTrialType | String | The trial type of subscription the organization has. |
| LicenseDetailsTrialExpiry | Datetime | The date and time the trial subscription expires for this organization. |
| LicenseDetailsPaid | Boolean | Whether the organization has a paid subscription. |
| LicenseDetailsPaidType | String | The type of subscription the organization has. |