Query and delete the Companies related to an Act! CRM opportunity.

Table Specific Information

Select

• Id supports the '=' operator.
• OpportunityId supports the '=' operator.
• Created 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.
• Edited supports the '<=,<,=,!=,>,>=' 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 '<=,<,=,!=,>,>=,CONTAINS' 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 OpportunityCompanies WHERE OpportunityId = '12345'

SELECT * FROM OpportunityCompanies WHERE Name = 'Company name' 

Delete

OpportunityCompanies can be deleted by providing an OpportunityId and Id (Company Id) and issuing a DELETE statement.

DELETE FROM OpportunityCompanies WHERE OpportunityId = '123456' AND Id = '345678'

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	ReadOnly	Description
Id [KEY]	String	False	The unique identifier (id) for this company.
OpportunityId [KEY]	String	False	The unique identifier of the opportunity the companies are related to.
Created	Datetime	False	Created date of the company.
Name	String	False	The company's given name.
AddressCity	String	False	An inhabited place of greater size, population, or importance than a town or village.
AddressCountry	String	False	A nation with its own government, occupying a particular territory.
AddressLine1	String	False	Primary street address
AddressLine2	String	False	Secondary street address
AddressLine3	String	False	Miscellaneous street address
AddressPostalCode	String	False	A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState	String	False	A nation or territory considered as an organized political community under one government.
BillingAddressCity	String	False	An inhabited place of greater size, population, or importance than a town or village.
BillingAddressCountry	String	False	A nation with its own government, occupying a particular territory.
BillingAddressLine1	String	False	Primary street address
BillingAddressLine2	String	False	Secondary street address
BillingAddressLine3	String	False	Miscellaneous street address
BillingAddressPostalCode	String	False	A code of letters and digits added to a postal address to aid in the sorting of mail.
BillingAddressState	String	False	A nation or territory considered as an organized political community under one government.
Description	String	False	A brief written representation or account of this company.
Division	String	False	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	False	Edited date of the company.
EditedBy	String	False	User who edited the company.
Fax	String	False	The company's fax phone number.
FaxExtension	String	False	The company's fax phone number extension.
HierarchyLevel	Int	False	The positional level of where this company lays within a company hierarchy.
IdStatus	String	False	The relative social or professional position of an individual within a group or organization.
Industry	String	False	Economic activity concerned with the processing of raw materials and manufacture of goods in factories.
NumberOfEmployees	Int	False	The total number of employees that this company operates with.
ParentID	String	False	The unique identifier (id) of the parent company.
Phone	String	False	The company's phone number.
PhoneExtension	String	False	The company's phone number extension.
RecordOwner	String	False	Owner user of the record.
ReferredBy	String	False	Mention or allude to.
Region	String	False	A part of a country, of the world, etc., that is different or separate from other parts in some way.
Revenue	String	False	The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise.
ShippingAddressCity	String	False	An inhabited place of greater size, population, or importance than a town or village.
ShippingAddressCountry	String	False	A nation with its own government, occupying a particular territory.
ShippingAddressLine1	String	False	Primary street address
ShippingAddressLine2	String	False	Secondary street address
ShippingAddressLine3	String	False	Miscellaneous street address
ShippingAddressPostalCode	String	False	A code of letters and digits added to a postal address to aid in the sorting of mail.
ShippingAddressState	String	False	A nation or territory considered as an organized political community under one government.
SicCode	String	False	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	False	Geographical area.
TickerSymbol	String	False	An arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly.
TollFreeExtension	String	False	The company's toll free phone number.
TollFreePhone	String	False	The company's toll free phone number.
Website	String	False	The company's website.