DandBCompany

Represents a D&B Company record, which is associated with an account. This object is available in API version 25.0 and later.

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

Warning

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 D&B. 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 D&B 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.
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 are `Actual number`, `Low`, `Estimated (for all records)`, `Modeled (for non-US records)`. A blank value indicates this data is unavailable.
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 are `Actual number`, `Low`, `Estimated (for all records)`, `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 4 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.
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 4 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.
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. Available values include `Cooperative`, `Nonprofit organization`, `Local government body`, `Partnership of unknown type`, and `Foreign company`.
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`.
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 are `High risk of delinquency`, `Low risk of delinquency`, and `Moderate risk of delinquency`. Use this information for marketing pre-screening purposes only. Important
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 D&B data for US organizations. Available values include `High-Tension Branches of Insurance/Utility Industries`, `Rapid-Growth Large Businesses`, `Labor-Intensive Giants`, `Spartans`, `Main Street USA`.
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.
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 D&B. 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.
OwnOrRent	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort, Update Description Indicates whether a company owns or rents the building it occupies.
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.
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 D&B. 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 D&B. Maximum size is 4 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.
PublicIndicator	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort, Update Description Indicates whether ownership of the company is public or private.
SalesVolume	Type double Properties Create, Filter, Nillable, Sort, Update Description The total annual sales revenue in local currency. D&B 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.
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 4 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 4 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.
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.
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 4 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.
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.

Object Reference for Salesforce and Force.com

DandBCompany

Supported Calls

Special Access Rules

Fields

Usage