Tableau Connector for Salesforce

Build 25.0.9434

DatacloudDandBCompany

Schema file for DatacloudDandBCompany.

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.
Name String Name of the record.
DunsNumber String The Data Universal Number System (D-U-N-S) number is a nine-digit number assigned to companies by Dun & Bradstreet.
CompanyId String ID of the Company associated with this record.
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.
Phone String Phone number for the contact or account.
Fax String Fax number for the contact or account.
CountryAccessCode String Field containing CountryAccessCode information.
PublicIndicator String Field containing PublicIndicator information.
StockSymbol String Field containing StockSymbol information.
StockExchange String Field containing StockExchange information.
SalesVolume Double Field containing SalesVolume information.
URL String Field containing URL information.
OutOfBusiness String Field containing OutOfBusiness information.
EmployeesTotal Double Field containing EmployeesTotal information.
FipsMsaCode String Field containing FipsMsaCode information.
FipsMsaDesc String Field containing FipsMsaDesc information.
TradeStyle1 String Field containing TradeStyle1 information.
YearStarted String Field containing YearStarted information.
MailingStreet String Street address for Mailing purposes.
MailingCity String City for Mailing address.
MailingState String State or province for Mailing address.
MailingStateCode String Field containing MailingStateCode information.
MailingCountry String Country for Mailing address.
MailingCountryCode String Field containing MailingCountryCode information.
MailingZip String Field containing MailingZip information.
Latitude String Used with Longitude to specify the precise geolocation of an address.
Longitude String Used with Latitude to specify the precise geolocation of an address.
PrimarySic String Field containing PrimarySic information.
PrimarySicDesc String Field containing PrimarySicDesc information.
SecondSic String Field containing SecondSic information.
SecondSicDesc String Field containing SecondSicDesc information.
ThirdSic String Field containing ThirdSic information.
ThirdSicDesc String Field containing ThirdSicDesc information.
FourthSic String Field containing FourthSic information.
FourthSicDesc String Field containing FourthSicDesc information.
FifthSic String Field containing FifthSic information.
FifthSicDesc String Field containing FifthSicDesc information.
SixthSic String Field containing SixthSic information.
SixthSicDesc String Field containing SixthSicDesc information.
PrimaryNaics String Field containing PrimaryNaics information.
PrimaryNaicsDesc String Field containing PrimaryNaicsDesc information.
SecondNaics String Field containing SecondNaics information.
SecondNaicsDesc String Field containing SecondNaicsDesc information.
ThirdNaics String Field containing ThirdNaics information.
ThirdNaicsDesc String Field containing ThirdNaicsDesc information.
FourthNaics String Field containing FourthNaics information.
FourthNaicsDesc String Field containing FourthNaicsDesc information.
FifthNaics String Field containing FifthNaics information.
FifthNaicsDesc String Field containing FifthNaicsDesc information.
SixthNaics String Field containing SixthNaics information.
SixthNaicsDesc String Field containing SixthNaicsDesc information.
OwnOrRent String Field containing OwnOrRent information.
EmployeesHere Double Field containing EmployeesHere information.
EmployeesHereReliability String Field containing EmployeesHereReliability information.
SalesVolumeReliability String Field containing SalesVolumeReliability information.
CurrencyCode String Field containing CurrencyCode information.
LegalStatus String Status of the Legal.
GlobalUltimateTotalEmployees Double Field containing GlobalUltimateTotalEmployees information.
EmployeesTotalReliability String Field containing EmployeesTotalReliability information.
MinorityOwned String Field containing MinorityOwned information.
WomenOwned String Field containing WomenOwned information.
SmallBusiness String Field containing SmallBusiness information.
MarketingSegmentationCluster String Field containing MarketingSegmentationCluster information.
ImportExportAgent String Field containing ImportExportAgent information.
Subsidiary String Field containing Subsidiary information.
TradeStyle2 String Field containing TradeStyle2 information.
TradeStyle3 String Field containing TradeStyle3 information.
TradeStyle4 String Field containing TradeStyle4 information.
TradeStyle5 String Field containing TradeStyle5 information.
NationalId String ID of the National associated with this record.
NationalIdType String Type classification for NationalId.
UsTaxId String ID of the UsTax associated with this record.
GeoCodeAccuracy String Accuracy level of the geocode for the address.
FamilyMembers Int Field containing FamilyMembers information.
MarketingPreScreen String Field containing MarketingPreScreen information.
GlobalUltimateDunsNumber String GlobalUltimateDuns identification number.
GlobalUltimateBusinessName String Field containing GlobalUltimateBusinessName information.
ParentOrHqDunsNumber String ParentOrHqDuns identification number.
ParentOrHqBusinessName String Field containing ParentOrHqBusinessName information.
DomesticUltimateDunsNumber String DomesticUltimateDuns identification number.
DomesticUltimateBusinessName String Field containing DomesticUltimateBusinessName information.
LocationStatus String Status of the Location.
CompanyCurrencyIsoCode String Field containing CompanyCurrencyIsoCode information.
Description String Text description of the record.
IsOwned Bool Indicates whether the record has the Owned characteristic.
IsParent Bool Indicates whether the record has the Parent characteristic.
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.
PrimarySic8 String Field containing PrimarySic8 information.
PrimarySic8Desc String Field containing PrimarySic8Desc information.
SecondSic8 String Field containing SecondSic8 information.
SecondSic8Desc String Field containing SecondSic8Desc information.
ThirdSic8 String Field containing ThirdSic8 information.
ThirdSic8Desc String Field containing ThirdSic8Desc information.
FourthSic8 String Field containing FourthSic8 information.
FourthSic8Desc String Field containing FourthSic8Desc information.
FifthSic8 String Field containing FifthSic8 information.
FifthSic8Desc String Field containing FifthSic8Desc information.
SixthSic8 String Field containing SixthSic8 information.
SixthSic8Desc String Field containing SixthSic8Desc information.
PriorYearEmployees Int Field containing PriorYearEmployees information.
PriorYearRevenue Double Field containing PriorYearRevenue information.
Industry String Industry that the account belongs to.
Revenue Double Field containing Revenue 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