Excel Add-In for Salesforce

Build 25.0.9434

DandBCompany

Schema file for DandBCompany.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String False

Name of the record.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

LastReferencedDate Datetime True

Date and time when the record was last referenced.

DunsNumber String False

The Data Universal Number System (D-U-N-S) number is a nine-digit number assigned to companies by Dun & Bradstreet.

Street String False

Street address.

City String False

City portion of the address.

State String False

State or province portion of the address.

PostalCode String False

Postal code portion of the address.

Country String False

Country portion of the address.

GeocodeAccuracyStandard String False

Field containing GeocodeAccuracyStandard information.

Phone String False

Phone number for the contact or account.

Fax String False

Fax number for the contact or account.

CountryAccessCode String False

Field containing CountryAccessCode information.

PublicIndicator String False

Field containing PublicIndicator information.

StockSymbol String False

Field containing StockSymbol information.

StockExchange String False

Field containing StockExchange information.

SalesVolume Double False

Field containing SalesVolume information.

URL String False

Field containing URL information.

OutOfBusiness String False

Field containing OutOfBusiness information.

EmployeesTotal Double False

Field containing EmployeesTotal information.

FipsMsaCode String False

Field containing FipsMsaCode information.

FipsMsaDesc String False

Field containing FipsMsaDesc information.

TradeStyle1 String False

Field containing TradeStyle1 information.

YearStarted String False

Field containing YearStarted information.

MailingStreet String False

Street address for Mailing purposes.

MailingCity String False

City for Mailing address.

MailingState String False

State or province for Mailing address.

MailingPostalCode String False

Postal code for Mailing address.

MailingCountry String False

Country for Mailing address.

MailingGeocodeAccuracy String False

Accuracy level of the geocode for the Mailing address.

Latitude String False

Used with Longitude to specify the precise geolocation of an address.

Longitude String False

Used with Latitude to specify the precise geolocation of an address.

PrimarySic String False

Field containing PrimarySic information.

PrimarySicDesc String False

Field containing PrimarySicDesc information.

SecondSic String False

Field containing SecondSic information.

SecondSicDesc String False

Field containing SecondSicDesc information.

ThirdSic String False

Field containing ThirdSic information.

ThirdSicDesc String False

Field containing ThirdSicDesc information.

FourthSic String False

Field containing FourthSic information.

FourthSicDesc String False

Field containing FourthSicDesc information.

FifthSic String False

Field containing FifthSic information.

FifthSicDesc String False

Field containing FifthSicDesc information.

SixthSic String False

Field containing SixthSic information.

SixthSicDesc String False

Field containing SixthSicDesc information.

PrimaryNaics String False

Field containing PrimaryNaics information.

PrimaryNaicsDesc String False

Field containing PrimaryNaicsDesc information.

SecondNaics String False

Field containing SecondNaics information.

SecondNaicsDesc String False

Field containing SecondNaicsDesc information.

ThirdNaics String False

Field containing ThirdNaics information.

ThirdNaicsDesc String False

Field containing ThirdNaicsDesc information.

FourthNaics String False

Field containing FourthNaics information.

FourthNaicsDesc String False

Field containing FourthNaicsDesc information.

FifthNaics String False

Field containing FifthNaics information.

FifthNaicsDesc String False

Field containing FifthNaicsDesc information.

SixthNaics String False

Field containing SixthNaics information.

SixthNaicsDesc String False

Field containing SixthNaicsDesc information.

OwnOrRent String False

Field containing OwnOrRent information.

EmployeesHere Double False

Field containing EmployeesHere information.

EmployeesHereReliability String False

Field containing EmployeesHereReliability information.

SalesVolumeReliability String False

Field containing SalesVolumeReliability information.

CurrencyCode String False

Field containing CurrencyCode information.

LegalStatus String False

Status of the Legal.

GlobalUltimateTotalEmployees Double False

Field containing GlobalUltimateTotalEmployees information.

EmployeesTotalReliability String False

Field containing EmployeesTotalReliability information.

MinorityOwned String False

Field containing MinorityOwned information.

WomenOwned String False

Field containing WomenOwned information.

SmallBusiness String False

Field containing SmallBusiness information.

MarketingSegmentationCluster String False

Field containing MarketingSegmentationCluster information.

ImportExportAgent String False

Field containing ImportExportAgent information.

Subsidiary String False

Field containing Subsidiary information.

TradeStyle2 String False

Field containing TradeStyle2 information.

TradeStyle3 String False

Field containing TradeStyle3 information.

TradeStyle4 String False

Field containing TradeStyle4 information.

TradeStyle5 String False

Field containing TradeStyle5 information.

NationalId String False

ID of the National associated with this record.

NationalIdType String False

Type classification for NationalId.

UsTaxId String False

ID of the UsTax associated with this record.

GeoCodeAccuracy String False

Accuracy level of the geocode for the address.

FamilyMembers Int False

Field containing FamilyMembers information.

MarketingPreScreen String False

Field containing MarketingPreScreen information.

GlobalUltimateDunsNumber String False

GlobalUltimateDuns identification number.

GlobalUltimateBusinessName String False

Field containing GlobalUltimateBusinessName information.

ParentOrHqDunsNumber String False

ParentOrHqDuns identification number.

ParentOrHqBusinessName String False

Field containing ParentOrHqBusinessName information.

DomesticUltimateDunsNumber String False

DomesticUltimateDuns identification number.

DomesticUltimateBusinessName String False

Field containing DomesticUltimateBusinessName information.

LocationStatus String False

Status of the Location.

CompanyCurrencyIsoCode String False

Field containing CompanyCurrencyIsoCode information.

Description String False

Text description of the record.

FortuneRank Int False

Field containing FortuneRank information.

IncludedInSnP500 String False

Field containing IncludedInSnP500 information.

PremisesMeasure Int False

Field containing PremisesMeasure information.

PremisesMeasureReliability String False

Field containing PremisesMeasureReliability information.

PremisesMeasureUnit String False

Field containing PremisesMeasureUnit information.

EmployeeQuantityGrowthRate Double False

Field containing EmployeeQuantityGrowthRate information.

SalesTurnoverGrowthRate Double False

Field containing SalesTurnoverGrowthRate information.

PrimarySic8 String False

Field containing PrimarySic8 information.

PrimarySic8Desc String False

Field containing PrimarySic8Desc information.

SecondSic8 String False

Field containing SecondSic8 information.

SecondSic8Desc String False

Field containing SecondSic8Desc information.

ThirdSic8 String False

Field containing ThirdSic8 information.

ThirdSic8Desc String False

Field containing ThirdSic8Desc information.

FourthSic8 String False

Field containing FourthSic8 information.

FourthSic8Desc String False

Field containing FourthSic8Desc information.

FifthSic8 String False

Field containing FifthSic8 information.

FifthSic8Desc String False

Field containing FifthSic8Desc information.

SixthSic8 String False

Field containing SixthSic8 information.

SixthSic8Desc String False

Field containing SixthSic8Desc information.

PriorYearEmployees Int False

Field containing PriorYearEmployees information.

PriorYearRevenue Double False

Field containing PriorYearRevenue information.

SOQL String False

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 False

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 False

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.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

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