# Organizations ## Documentation The organizations: companies and other parties the company does business with. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Contacts` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Organizations` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `acme_segment_label` | `varchar2` | ACME Segment Label | ☐ | The labels of the chosen options of the custom field 'ACME Segment'. | | `acme_segment` | `int64` | ACME Segment | ☐ | The custom field 'ACME Segment' of the company. | | `add_time` | `datetime` | | ☐ | The creation date and time of the organization. | | `address_admin_area_level_1` | `varchar2` | | ☐ | Admin area level 1 (e.g. state) of the organization. | | `address_admin_area_level_2` | `varchar2` | | ☐ | Admin area level 2 (e.g. county) of the organization. | | `address_country` | `varchar2` | | ☐ | Country of the organization. | | `address_locality` | `varchar2` | | ☐ | Locality (e.g. city) of the organization. | | `address_postal_code` | `varchar2` | | ☐ | Postal code of the organization. | | `address_route` | `varchar2` | | ☐ | Route (e.g. street) of the organization. | | `address_street_number` | `varchar2` | | ☐ | Street number of the organization. | | `address_sublocality` | `varchar2` | | ☐ | Sublocality (e.g. neighborhood) of the organization. | | `address_subpremise` | `varchar2` | | ☐ | Subpremise (e.g. apartment/suite number) of the organization. | | `address_value` | `varchar2` | | ☐ | The full address of the organization. | | `address` | `varchar2` | | ☐ | The address of the organization. Only taken when writing; empty when read. | | `annual_revenue` | `int64` | | ☐ | The annual revenue of the organization. | | `employee_count` | `int64` | | ☐ | The number of employees in the organization. | | `id` | `int64` | | ☑ | The ID of the organization. | | `industry` | `int64` | | ☐ | The industry the organization belongs to. | | `is_deleted` | `char` | | ☐ | Whether the organization is deleted or not. | | `label_ids` | `varchar2` | | ☐ | The IDs of labels assigned to the organization. | | `linkedin` | `varchar2` | | ☐ | The LinkedIn profile URL of the organization. | | `name` | `varchar2` | | ☐ | The name of the organization. | | `owner_id` | `int64` | | ☐ | The ID of the user who owns the organization. | | `update_time` | `datetime` | | ☐ | The last updated date and time of the organization. | | `visible_to` | `int64` | | ☐ | The visibility of the organization. | | `website` | `varchar2` | | ☐ | The website of the organization. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `owner_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Activities-Activities\|Activities.Activities]] | `org_id` | Declared by the connector, not enforced by the platform | | [[Activities-CallLogs\|Activities.CallLogs]] | `org_id` | Declared by the connector, not enforced by the platform | | [[Contacts-Persons\|Contacts.Persons]] | `org_id` | Declared by the connector, not enforced by the platform | | [[Deals-ArchivedDeals\|Deals.ArchivedDeals]] | `org_id` | Declared by the connector, not enforced by the platform | | [[Deals-Deals\|Deals.Deals]] | `org_id` | Declared by the connector, not enforced by the platform | | [[Leads-ArchivedLeads\|Leads.ArchivedLeads]] | `organization_id` | Declared by the connector, not enforced by the platform | | [[Leads-Leads\|Leads.Leads]] | `organization_id` | Declared by the connector, not enforced by the platform | | [[Notes-Files\|Notes.Files]] | `org_id` | Declared by the connector, not enforced by the platform | | [[Notes-Notes\|Notes.Notes]] | `org_id` | Declared by the connector, not enforced by the platform | | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of Organizations, when item is 'organization'. |