JDBC Driver for Act! CRM

Build 21.0.8137

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

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137