Excel Add-In for Act! CRM

Build 23.0.8839

OpportunityCompanies

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 add-in uses the Act! CRM API to process search criteria that refer to the supported fields. The add-in processes other filters client-side within the add-in. 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'

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839