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.

The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM ActivityCompanies WHERE ActivityId = '12345'

SELECT * FROM ActivityCompanies WHERE Name = 'TSS Company' 

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 an error.

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.