Table Type: Metadata
Contains the external organizations. Organizations have multiple contacts and a single primary contact.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| id | string | Primary Key | The unique identifier of the external organization. |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. | |
| db_when_deleted | datetime | When this record was deleted in UTC or NULL. | |
| name | string | The name of the organization. | |
| company_type | string | The type of company. | |
| industry | string | The industry of the organization. | |
| address1 | string | The organization's address. | |
| address2 | string | The organization's address. | |
| city | string | The organization's address. | |
| state | string | The organization's address. | |
| postal_code | string | The organization's address. | |
| country_code | string | The organization's address. | |
| phone_number_display | string | The displayed form of the phone number string in E164 format. | |
| phone_number_extension | int64 | An optional extension for the provided phone number. | |
| phone_number_accepts_sms | boolean | Whether the phone number can accept SMS messages. | |
| phone_number_normalization_country_code | string | The country code that will be used for E164 conversion of a provided phone number. If the country code is omitted from the provided phone number, the country code provided in this field will be used during the E164 conversion attempt. If this field is left empty, the default country code for any provided phone number that does not explicitly include a country code is assumed to be +1 (North America). | |
| phone_number_user_input | string | The phone number the user inputted. | |
| phone_number_e164 | string | The phone number in E164 format Only set when the provided phone number could be read as E164. | |
| phone_number_country_code | string | The detected country code from the provided phone number. | |
| fax_number_display | string | ||
| fax_number_extension | int64 | ||
| fax_number_accepts_sms | boolean | ||
| fax_number_normalization_country_code | string | ||
| fax_number_user_input | string | ||
| fax_number_e164 | string | ||
| fax_number_country_code | string | ||
| employee_count | int64 | ||
| revenue | int64 | ||
| modify_date | datetime | The date the record was last modified. | |
| create_date | datetime | The date the record was created. |
