DandBCompany

Represents a Dun & Bradstreet® company record, which is associated with an account added from Data.com. This object is available in API version 25.0 and later.
Warning

Warning

You can update fields in the DandBCompany object; however, field changes may be overwritten by Data.com Clean jobs or by using the Data.com Clean button.

Supported Calls

create(),  delete(),  describeLayout(), describeSObjects(),  getDeleted(),  getUpdated(),  query(),  retrieve(),  search(),  undelete(),  update(),  upsert()

Special Access Rules

Only organizations with Data.com Premium Prospector or Data.com Premium Clean can access this object.

Fields

Field Name Details
Address
Type
address
Properties
Filter, Nillable
Description
The compound form of the address. Read-only. See Address Compound Fields for details on compound address fields.
City
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The city where a company is physically located. Maximum size is 40 characters.
CompanyCurrencyIsoCode
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
The code used to represent a company’s local currency. This data is provided by the International Organization for Standardization (ISO) and is based on their three-letter currency codes. For example, USD is the ISO code for United States Dollar. Maximum size is 3 characters.
Country
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The country where a company is physically located. Maximum size is 40 characters.
CountryAccessCode
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The required code for international calls. Maximum size is 4 characters.
CurrencyCode
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
The currency in which the company’s sales volume is expressed. The full list of values can be found at the Optimizer Resources page maintained by Dun & Bradstreet. Maximum size is 4 characters.
Description
Type
textarea
Properties
Create, Nillable, Update
Description
A brief description of the company, which may include information about its history, its products and services, and its influence on a particular industry. Maximum size is 32000 characters.
DomesticUltimateBusinessName
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The primary name of the Domestic Ultimate, which is the highest ranking subsidiary, specified by country, within an organization’s corporate structure. Maximum size is 255 characters.
DomesticUltimateDunsNumber
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The D-U-N-S Number for the Domestic Ultimate, which is the highest ranking subsidiary, specified by country, within an organization’s corporate structure. Maximum size is 9 characters.
DunsNumber
Type
string
Properties
Create, Filter, Group, Sort, Update
Description
The Data Universal Numbering System (D-U-N-S) number is a unique, nine-digit number assigned to every business location in the Dun & Bradstreet database that has a unique, separate, and distinct operation. D-U-N-S numbers are used by industries and organizations around the world as a global standard for business identification and tracking. Maximum size is 9 characters.
EmployeeQuantityGrowthRate
Type
double
Properties
Create, Filter, Nillable, Sort, Update
Description
The yearly growth rate of the number of employees in a company expressed as a decimal percentage. The data includes the total employee growth rate for the past two years.
EmployeesHere
Type
double
Properties
Create, Filter, Nillable, Sort, Update
Description
The number of employees at a specified location, such as a branch location. Maximum size is 15 characters.
EmployeesHereReliability
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
The reliability of the EmployeesHere figure. Available values include:
  • 0—Actual number
  • 1—Low
  • 2—Estimated (for all records)
  • 3—Modeled (for non-US records)
EmployeesTotal
Type
double
Properties
Create, Filter, Nillable, Sort, Update
Description
The total number of employees in the company, including all subsidiary and branch locations. This data is only available on records that have a value of Headquarters/Parent in the LocationStatus field. Maximum size is 15 characters.
EmployeesTotalReliability
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
The reliability of the EmployeesTotal figure. Available values include:
  • 0—Actual number
  • 1—Low
  • 2—Estimated (for all records)
  • 3—Modeled (for non-US records)
A blank value indicates this data is unavailable.
FamilyMembers
Type
int
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The total number of family members, worldwide, within an organization, including the Global Ultimate, its subsidiaries (if any), and its branches (if any). Maximum size is 5 characters.
Fax
Type
phone
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The company’s facsimile number.
FifthNaics
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional NAICS code used to further classify an organization by industry. Maximum size is 6 characters.
FifthNaicsDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding NAICS code. Maximum size is 120 characters.
FifthSic
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
FifthSic8
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
FifthSic8Desc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
FifthSicDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
FipsMsaCode
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The Federal Information Processing Standards (FIPS) and the Metropolitan Statistical Area (MSA) codes identify the organization’s location. The MSA codes are defined by the US Office of Management and Budget. Maximum size is 5 characters.
FipsMsaDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s FIPS MSA code. Maximum size is 255 characters.
FortuneRank
Type
int
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The numeric value of the company’s Fortune 1000 ranking. A null or blank value means that the company isn’t ranked as a Fortune 1000 company.
FourthNaics
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional NAICS code used to further classify an organization by industry. Maximum size is 6 characters.
FourthNaicsDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding NAICS code. Maximum size is 120 characters.
FourthSic
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
FourthSic8
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
FourthSic8Desc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
FourthSicDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
GeoCodeAccuracy
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
The level of accuracy of a location’s geographical coordinates compared with its physical address. Available values include:
  • A – Non-US rooftop accuracy
  • B – Block level
  • C – Places the address in the correct city
  • D – Rooftop level
  • I – Street intersection
  • M – Mailing address level
  • N – Not matched
  • P – PO BOX location
  • S – Street level
  • T – Census tract level
  • Z – ZIP code level
  • 0 (zero)– Geocode could not be assigned
GlobalUltimateBusinessName
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The primary name of the Global Ultimate, which is the highest entity within an organization’s corporate structure and may oversee branches and subsidiaries. Maximum size is 255 characters.
GlobalUltimateDunsNumber
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The D-U-N-S Number of the Global Ultimate, which is the highest entity within an organization’s corporate structure and may oversee branches and subsidiaries. Maximum size is 9 characters.
GlobalUltimateTotalEmployees
Type
double
Properties
Create, Filter, Nillable, Sort, Update
Description
The total number of employees at the Global Ultimate, which is the highest entity within an organization’s corporate structure and may oversee branches and subsidiaries. Maximum size is 15 characters.
ImportExportAgent
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Identifies whether a business imports goods or services, exports goods or services, and/or is an agent for goods. Available values include:
  • A—Importer/exporter/agent
  • B—Importer/exporter
  • C—Importer
  • D—Importer/agent
  • E—Exporter/agent
  • F—Agent (keeps no inventory and does not take title goods)
  • G—None or data not available
  • H—Exporter
IncludedInSnP500
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A true or false value. If true, the company is listed in the S&P 500 Index. If false, the company isn’t listed in the S&P 500 Index.
Latitude
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
Used with longitude to specify a precise location, which is then used to assess the Geocode Accuracy. Maximum size is 11 characters.
LegalStatus
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Identifies the legal structure of an organization.
LocationStatus
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Identifies the organizational status of a company. Available values are Single location, Headquarters/Parent, and Branch. Available values include:
  • 0—Single location (no other entities report to the business)
  • 1—Headquarters/parent (branches and/or subsidiaries report to the business)
  • 2—Branch (secondary location to a headquarters location)
Longitude
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
Used with latitude to specify a precise location, which is then used to assess the Geocode Accuracy. Maximum size is 11 characters.
MailingAddress
Type
address
Properties
Filter, Nillable
Description
The compound form of the mailing address. Read-only. See Address Compound Fields for details on compound address fields.
MailingCity
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The city where a company has its mail delivered. Maximum size is 40 characters.
MailingCountry
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The country where a company has its mail delivered. Maximum size is 40 characters.
MailingPostalCode
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The postal code that a company uses on its mailing address. Maximum size is 20 characters.
MailingState
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The state where a company has its mail delivered. Maximum size is 20 characters.
MailingStreet
Type
textarea
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The street address where a company has its mail delivered. Maximum size is 255 characters.
MarketingPreScreen
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
The probability that a company will pay with a significant delay compared to the agreed terms. The risk level is based on the standard Commercial Credit Score, and ranges from low risk to high risk. Available values include:
  • L—Low risk of delinquency
  • M—Moderate risk of delinquency
  • H—High risk of delinquency
Important

Important

Use this information for marketing pre-screening purposes only.

MarketingSegmentationCluster
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Twenty-two distinct, mutually exclusive profiles, created as a result of cluster analysis of Dun & Bradstreet data for US organizations.
MinorityOwned
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Indicates whether an organization is owned or controlled by a member of a minority group. Available values include:
  • Y—Minority owned
  • N—Not minority owned
Name
Type
string
Properties
Create, Filter, Group, Sort, Update
Description
The primary or registered name of a company. Maximum size is 255 characters.
NationalId
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The identification number used in some countries for business registration and tax collection. Maximum size is 255 characters.
NationalIdType
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
A code value that identifies the type of national identification number used. The full list of values can be found at the Optimizer Resources page maintained by Dun & Bradstreet. Maximum size is 5 characters.
OutOfBusiness
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Indicates whether the company at the specified address has discontinued operations. Available values include:
  • Y—Out of business
  • N—Not out of business
OwnOrRent
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Indicates whether a company owns or rents the building it occupies. Available values include:
  • 0—Unknown or not applicable
  • 1—Owns
  • 2—Rents
ParentOrHqBusinessName
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The primary name of the parent or headquarters company. Maximum size is 255 characters.
ParentOrHqDunsNumber
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The D-U-N-S Number for the parent or headquarters. Maximum size is 9 characters.
Phone
Type
phone
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A company’s primary telephone number.
PostalCode
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The postal code that corresponds to a company’s physical location. Maximum size is 20 characters.
PremisesMeasure
Type
int
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A numeric value for the measurement of the premises.
PremisesMeasureReliability
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A descriptive accuracy of the measurement such as actual, estimated, or modeled.
PremisesMeasureUnit
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A descriptive measurement unit such as acres, square meters, or square feet.
PrimaryNaics
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The six-digit North American Industry Classification System (NAICS) code is the standard used by business and government to classify business establishments according to their economic activity for the purpose of collecting, analyzing, and publishing statistical data related to the US business economy. The full list of values can be found at the Optimizer Resources page maintained by Dun & Bradstreet. Maximum size is 6 characters.
PrimaryNaicsDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on its NAICS code. Maximum size is 120 characters.
PrimarySic
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The four-digit Standard Industrial Classification (SIC) code is used to categorize business establishments by industry. The full list of values can be found at the Optimizer Resources page maintained by Dun & Bradstreet. Maximum size is 4 characters.
PrimarySic8
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The eight-digit Standard Industrial Classification (SIC) code is used to categorize business establishments by industry. The full list of values can be found at the Optimizer Resources page maintained by Dun & Bradstreet. Maximum size is 8 characters.
PrimarySic8Desc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on its SIC code. The full list of values can be found at the Optimizer Resources page maintained by Dun & Bradstreet. Maximum size is 80 characters.
PrimarySicDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on its SIC code. Maximum size is 80 characters.
PriorYearEmployees
Type
int
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The total number of employees for the prior year.
PriorYearRevenue
Type
double
Properties
Create, Filter, Nillable, Sort, Update
Description
The annual revenue for the prior year.
PublicIndicator
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Indicates whether ownership of the company is public or private. Available values include:
  • Y—Public
  • N—Private
SalesTurnoverGrowthRate
Type
double
Properties
Create, Filter, Nillable, Sort, Update
Description
The increase in annual revenue from the previous value for an equivalent period expressed as a decimal percentage.
SalesVolume
Type
double
Properties
Create, Filter, Nillable, Sort, Update
Description
The total annual sales revenue in the headquarters’ local currency. Dun & Bradstreet tracks revenue data for publicly traded companies, Global Ultimates, Domestic Ultimates, and some headquarters.
SalesVolumeReliability
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
The reliability of the SalesVolume figure. Available values include:
  • 0—Actual number
  • 1—Low
  • 2—Estimated (for all records)
  • 3—Modeled (for non-US records)
SecondNaics
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional NAICS code used to further classify an organization by industry. Maximum size is 6 characters.
SecondNaicsDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding NAICS code. Maximum size is 120 characters.
SecondSic
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
SecondSic8
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
SecondSic8Desc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
SecondSicDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
SixthNaics
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional NAICS code used to further classify an organization by industry. Maximum size is 6 characters.
SixthNaicsDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding NAICS code. Maximum size is 120 characters.
SixthSic
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
SixthSic8
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
SixthSic8Desc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
SixthSicDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
SmallBusiness
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Indicates whether the company is designated a small business as defined by the Small Business Administration of the US government. Available values include:
  • Y—Small business site
  • N—Not small business site
State
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The state where a company is physically located. Maximum size is 20 characters.
StockExchange
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The corresponding exchange for a company’s stock symbol. For example: NASDAQ or NYSE. Maximum size is 16 characters.
StockSymbol
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The abbreviation used to identify publicly traded shares of a particular stock. Maximum size is 6 characters.
Street
Type
textarea
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The street address where a company is physically located. Maximum size is 255 characters.
Subsidiary
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Indicates whether a company is more than 50 percent owned by another organization. Available values include:
  • 0—Not subsidiary of another organization
  • 3—Subsidiary of another organization
ThirdNaics
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional NAICS code used to further classify an organization by industry. Maximum size is 6 characters.
ThirdNaicsDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding NAICS code. Maximum size is 120 characters.
ThirdSic
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
ThirdSic8
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional SIC code used to further classify an organization by industry. Maximum size is 8 characters.
ThirdSic8Desc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
ThirdSicDesc
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A brief description of an organization’s line of business, based on the corresponding SIC code. Maximum size is 80 characters.
TradeStyle1
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
A name, different from its legal name, that an organization may use for conducting business. Similar to “Doing business as” or “DBA”. Maximum size is 255 characters.
TradeStyle2
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional tradestyle used by the organization. Maximum size is 255 characters.
TradeStyle3
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional tradestyle used by the organization. Maximum size is 255 characters.
TradeStyle4
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional tradestyle used by the organization. Maximum size is 255 characters.
TradeStyle5
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An additional tradestyle used by the organization. Maximum size is 255 characters.
URL
Type
url
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
An organization’s primary website address. Maximum size is 104 characters.
UsTaxId
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The identification number for the company used by the Internal Revenue Service (IRS) in the administration of tax laws. Also referred to as Federal Taxpayer Identification Number. Maximum size is 9 characters.
WomenOwned
Type
picklist
Properties
Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description
Indicates whether a company is more than 50 percent owned or controlled by a woman. Available values include:
  • Y—Owned by a woman
  • N—Not owned by a woman, or unknown
YearStarted
Type
string
Properties
Create, Filter, Group, Nillable, Sort, Update
Description
The year the company was established or the year when current ownership or management assumed control of the company. Maximum size is 4 characters.

Usage

Use this object to manage D&B Company records in your organization.