Excel Add-In for Salesforce

Build 25.0.9434

DatacloudCompany

Schema file for DatacloudCompany.

Columns

Name Type References Description
Id [KEY] String Unique identifier for the record.
CurrencyIsoCode String ISO code for the currency in which the revenue amount is expressed.
ExternalId String External ID from another system.
CompanyId String ID of the Company associated with this record.
Name String Name of the record.
Description String Text description of the record.
IsInactive Bool Indicates whether the record has the Inactive characteristic.
Phone String Phone number for the contact or account.
Fax String Fax number for the contact or account.
Street String Street address.
City String City portion of the address.
State String State or province portion of the address.
StateCode String Field containing StateCode information.
Country String Country portion of the address.
CountryCode String Field containing CountryCode information.
Zip String Field containing Zip information.
Site String The billing address city for this account.
Industry String Industry that the account belongs to.
NumberOfEmployees Int Number of employees working at the company represented by this account.
AnnualRevenue Decimal Estimated annual revenue of the account.
DunsNumber String The Data Universal Number System (D-U-N-S) number is a nine-digit number assigned to companies by Dun & Bradstreet.
NaicsCode String Field containing NaicsCode information.
NaicsDesc String Field containing NaicsDesc information.
Sic String Standard Industrial Classification code of the company's main business categorization.
SicDesc String A brief description of the company's business, based on the SIC code.
Ownership String Ownership type for the account.
IsOwned Bool Indicates whether the record has the Owned characteristic.
TickerSymbol String The stock market symbol for the account.
TradeStyle String Field containing TradeStyle information.
Website String Website URL for this account.
YearStarted String Field containing YearStarted information.
ActiveContacts Int Field containing ActiveContacts information.
UpdatedDate Datetime Date associated with Updated.
FortuneRank Int Field containing FortuneRank information.
IncludedInSnP500 String Field containing IncludedInSnP500 information.
PremisesMeasure Int Field containing PremisesMeasure information.
PremisesMeasureReliability String Field containing PremisesMeasureReliability information.
PremisesMeasureUnit String Field containing PremisesMeasureUnit information.
EmployeeQuantityGrowthRate Double Field containing EmployeeQuantityGrowthRate information.
SalesTurnoverGrowthRate Double Field containing SalesTurnoverGrowthRate information.
PriorYearEmployees Int Field containing PriorYearEmployees information.
PriorYearRevenue Decimal Field containing PriorYearRevenue information.
IsInCrm Bool Indicates whether the record has the InCrm characteristic.
FullAddress String Field containing FullAddress information.
SicCodeDesc String Field containing SicCodeDesc information.
SOQL String Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.
ExternalIdColumn String Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.
FilterScope String Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434