ActivityCompanies
Query the Companies participating in an Act! CRM Activity.
Table Specific Information
Select
- ActivityId supports the '=' operator.
- Name supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AddressCity supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AddressCountry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AddressLine1 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AddressLine2 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AddressLine3 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AddressPostalCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AddressState supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- BillingAddressCity supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- BillingAddressCountry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- BillingAddressLine1 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- BillingAddressLine2 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- BillingAddressLine3 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- BillingAddressPostalCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- BillingAddressState supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Description supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Division supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- EditedBy supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Fax supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- FaxExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- HierarchyLevel supports the '<=,<,=,!=,>,>=' operator.
- IdStatus supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Industry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- NumberOfEmployees supports the '<=,<,=,!=,>,>=' operator.
- ParentID supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Phone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- PhoneExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- RecordOwner supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- ReferredBy supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Region supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Revenue supports the '<=,<,=,!=,>,>=' operator.
- ShippingAddressCity supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- ShippingAddressCountry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- ShippingAddressLine1 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- ShippingAddressLine2 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- ShippingAddressLine3 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- ShippingAddressPostalCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- ShippingAddressState supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- SicCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Territory supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- TickerSymbol supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- TollFreeExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- TollFreePhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- Website supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
SELECT * FROM ActivityCompanies WHERE ActivityId = '12345' SELECT * FROM ActivityCompanies WHERE Name = 'TSS Company'
Columns
Name | Type | Description |
Id [KEY] | String | The unique identifier (id) for this company. |
ActivityId [KEY] | String | A unique identifier that represents the activity the companies are part of. |
Created | Datetime | Created date and the activity. |
Name | String | The company's given name. |
AddressCity | String | An inhabited place of greater size, population, or importance than a town or village. |
AddressCountry | String | A nation with its own government, occupying a particular territory. |
AddressLine1 | String | Primary street address |
AddressLine2 | String | Secondary street address |
AddressLine3 | String | Miscellaneous street address |
AddressPostalCode | String | A code of letters and digits added to a postal address to aid in the sorting of mail. |
AddressState | String | A nation or territory considered as an organized political community under one government. |
BillingAddressCity | String | An inhabited place of greater size, population, or importance than a town or village. |
BillingAddressCountry | String | A nation with its own government, occupying a particular territory. |
BillingAddressLine1 | String | Primary street address |
BillingAddressLine2 | String | Secondary street address |
BillingAddressLine3 | String | Miscellaneous street address |
BillingAddressPostalCode | String | A code of letters and digits added to a postal address to aid in the sorting of mail. |
BillingAddressState | String | A nation or territory considered as an organized political community under one government. |
Description | String | A brief written representation or account of this company. |
Division | String | The name of a smaller part of a parent company tasked with overseeing different types of products or services than those offered by the parent company. |
Edited | Datetime | Edited date of the activity. |
EditedBy | String | User that edited the activity. |
Fax | String | The company's fax phone number. |
FaxExtension | String | The company's fax phone number extension. |
HierarchyLevel | Int | The positional level of where this company lays within a company hierarchy. |
IdStatus | String | The relative social or professional position of an individual within a group or organization. |
Industry | String | Economic activity concerned with the processing of raw materials and manufacture of goods in factories. |
NumberOfEmployees | Int | The total number of employees that this company operates with. |
ParentID | String | The unique identifier (id) of the parent company. |
Phone | String | The company's phone number. |
PhoneExtension | String | The company's phone number extension. |
RecordOwner | String | Owner of the activity. |
ReferredBy | String | Mention or allude to. |
Region | String | A part of a country, of the world, etc., that is different or separate from other parts in some way. |
Revenue | Decimal | The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise. |
ShippingAddressCity | String | An inhabited place of greater size, population, or importance than a town or village. |
ShippingAddressCountry | String | A nation with its own government, occupying a particular territory. |
ShippingAddressLine1 | String | Primary street address |
ShippingAddressLine2 | String | Secondary street address |
ShippingAddressLine3 | String | Miscellaneous street address |
ShippingAddressPostalCode | String | A code of letters and digits added to a postal address to aid in the sorting of mail. |
ShippingAddressState | String | A nation or territory considered as an organized political community under one government. |
SicCode | String | Standard Industrial Classification (SIC) codes are four-digit numerical codes assigned by the U.S. government to business establishments to identify the primary business of the establishment. |
Territory | String | Geographical area. |
TickerSymbol | String | An arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly. |
TollFreeExtension | String | The company's toll free phone number. |
TollFreePhone | String | The company's toll free phone number. |
Website | String | The company's website. |
AddressLatitude | Decimal | The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes. |
AddressLongitude | Decimal | The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes. |
BillingAddressLatitude | Decimal | The Billing address latitude. |
BillingAddressLongitude | Decimal | The Billing address longitude. |
HasDivisions | Boolean | This readonly property indicates that this company has divisions. |
ImportDate | Datetime | This readonly property displays the date that the opportunity was imported into the system. |
IsPrivate | Boolean | Indicates elevated security that only the creator/owner has access to this company. |
RootParentId | String | The unique identifier (id) of the parent company. |
ShippingAddressLatitude | Decimal | The Shipping address latitude. |
ShippingAddressLongitude | Decimal | The Shipping address longitude. |
RecordManagerID | String | The record manager. |
CustomFields | String | Custom fields. |
RecordManager | String | Manager of the activity. |