Query the Act! CRM Companies associated with a Contact.

View Specific Information

Select

• ContactId 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.
• AddressLatitude supports the '<=,<,=,!=,>,>=' operator.
• AddressLongitude supports the '<=,<,=,!=,>,>=' 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.
• BillingAddressLatitude supports the '<=,<,=,!=,>,>=' operator.
• BillingAddressLongitude supports the '<=,<,=,!=,>,>=' 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.
• 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.
• ShippingAddressLatitude supports the '<=,<,=,!=,>,>=' operator.
• ShippingAddressLongitude supports the '<=,<,=,!=,>,>=' 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 ContactCompanies WHERE ContactId = 'a58016a6-780c-48c0-84ff-b6b6b085eb8c'

SELECT * FROM ContactCompanies

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier (id) for this company.
ContactId [KEY]	String	The unique identifier (id) for the contact to retrieve companies from.
Created	Datetime	Created date of the company.
Name	String	The company's given name.
AddressCity	String	The city of the company's address.
AddressCountry	String	The country of the company's address.
AddressLine1	String	The first line of the company's street address.
AddressLine2	String	The second line of the company's street address.
AddressLine3	String	The third line of the company's street address.
AddressPostalCode	String	The postal code of the company's address.
AddressState	String	The state or province of the company's address.
BillingAddressCity	String	The city of the company's billing address.
BillingAddressCountry	String	The country of the company's billing address.
BillingAddressLine1	String	The first line of the company's billing street address.
BillingAddressLine2	String	The second line of the company's billing street address.
BillingAddressLine3	String	The third line of the company's billing street address.
BillingAddressPostalCode	String	The postal code of the company's billing address.
BillingAddressState	String	The state or province of the company's billing address.
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 company.
EditedBy	String	User who edited the company record.
Fax	String	The company's fax phone number.
FaxExtension	String	The company's fax phone number extension.
HierarchyLevel	Integer	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	Integer	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 company record.
ReferredBy	String	The name of the person or entity that referred this company.
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	The city of the company's shipping address.
ShippingAddressCountry	String	The country of the company's shipping address.
ShippingAddressLine1	String	The first line of the company's shipping street address.
ShippingAddressLine2	String	The second line of the company's shipping street address.
ShippingAddressLine3	String	The third line of the company's shipping street address.
ShippingAddressPostalCode	String	The postal code of the company's shipping address.
ShippingAddressState	String	The state or province of the company's shipping address.
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 extension.
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.
ShippingAddressLatitude	Decimal	The Shipping address latitude.
ShippingAddressLongitude	Decimal	The Shipping address longitude.
HasDivisions	Boolean	This readonly property indicates that this company has divisions.
ImportDate	Datetime	This readonly property displays the date that the company 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.
RecordManagerID	String	The record manager.
CustomFields	String	Custom fields.
RecordManager	String	Manager of the company record.
Acl	String	The access control level of the record.