Detailed Company Profile - SDMR

This data layer provides details comparable to the Strategic Database Marketing Record (SDMR) batch file.

Requirements & Options

When requesting this D&B Direct product, a valid D-U-N-S Number for a company, its country code, and the appropriate product code will be required. If this information is not available, refer to obtaining a company D-U-N-S Number for assistance. A trade up option exists to request data for the headquarters when the requested organization is a branch.

When ordering information for organizations located in Germany, customers are required to provide a valid order reason code. A list of possible values is included on the respective SOAP or REST operation page.

NOTE: The product code for Detailed Company Profile - SDMR is DCP_SDMR. This product may be included in the Monitoring process.

Business Elements

The following table is an alphabetical list of the unique items delivered in this data layer. Legend: [C] = may be included in a Custom Data product; [M] = may be referenced by the Monitoring process; [M+] = Monitored using an aggregate or attribute XPath.

NOTE: This product will return a set of standard elements (e.g. D-U-N-S Number, Organization Name, Trade Styles, Family Tree Role, Primary Address, Mailing Address, Telephone Number, Fax Number, et al.) along with the business elements listed. In addition, customers who compare the following table to the Data Primer should be advised of several intentional differences.

NOTE: The field PrimaryAddress. TerritoryOfficialName should be used in place of PrimaryAddress. TerritoryName. The TerritoryName field will not be included in future versions of this service.

Name Description XML* JSON*
3 Year Base Employee Count (Trend Data) The total number of employees for the Base Year, which is the first (oldest) year of the three year trend calculation period. Trend Data fields are calculated once a year, in June, published the following July and used for the subsequent 12 months. SOAP REST
3 Year Base Employee Count Reliability Text Text that describes the integrity of the employee figures, e.g. audited, actual, estimated, or modeled. SOAP REST
3 Year Base Sales Amount (Trend Data) The Sales Amount from the income statement data in millions (USD) for the Base Year, which is the first (oldest) year of this three year trend calculation period. Trend Data fields are calculated once a year, in June, published the following July and used for the subsequent 12 months. [M] SOAP REST
3 Year Growth Percentage on Employees (Trend Data) The percentage increase or decrease in the number of employees over a three year period. This field is calculated by dividing the difference between the Trend Year and 3 Year Base Employee Count values by the 3 year Base Employee Count and multiplying by 100. [M] SOAP REST
3 Year Growth Percentage on Sales Volume (Trend Data) The percentage increase or decrease in the Sales Amount over a three year period. This field is calculated by dividing the difference between the Trend Year and 3 Year Base Sales Amount by the 3 Year Base Sales Amount and multiplying by 100. [M] SOAP REST
5 Year Base Employee Count (Trend Data) The total number of employees for the Base Year, which is the first (oldest) year of the five year trend calculation period. Trend Data fields are calculated once a year, in June, published the following July and used for the subsequent 12 months. SOAP REST
5 Year Base Employee Count Reliability Text Text that describes the integrity of the employee figures, e.g. audited, actual, estimated, or modeled. SOAP REST
5 Year Base Sales Amount (Trend Data) The Sales Amount from the income statement data in millions (USD) for the Base Year, which is the first (oldest) year of this five year trend calculation period. Trend Data fields are calculated once a year, in June, published the following July and used for the subsequent 12 months. [M] SOAP REST
5 Year Growth Percentage on Employees (Trend Data) The percentage increase or decrease in the number of employees over a five year period. This field is calculated by dividing the difference between the Trend Year and 5 Year Base Employee Count values by the 5 year Base Employee Count and multiplying by 100. [M] SOAP REST
5 Year Growth Percentage on Sales Volume (Trend Data) The percentage increase or decrease in the Sales Amount over a five year period. This field is calculated by dividing the difference between the Trend Year and 5 Year Base Sales Amount by the 5 Year Base Sales Amount and multiplying by 100. [M] SOAP REST
Accountant Name Text recording the name of either an individual or the name of an accounting firm. [M+] SOAP REST
Agent Indicator When 'true' indicates that the subject acts as an agent promoting the goods or services of another organization, e.g., Sales Agent, Purchasing Agent. When 'false' indicates that the subject does not act as an agent of another organization. [M] SOAP REST
Business Legal Structure Text that describes the legal form or structure of a business, as registered with government authorities, e.g., partnership, corporation, private limited company, government department, proprietorship. [M+] SOAP REST
Carrier Route Code A code assigned by the United States Postal Service (USPS) that sorts mail pieces to the individual carrier routes within a 5-digit ZIP Code. SOAP REST
Carrier Route Code Type Text describing the value contained in the Carrier Route Code field. SOAP REST
Company Principal First Name Text recording the first name of the principal. [M+] SOAP REST
Company Principal Job Title Text recording the job held by the principal or manager. E.g. e.g., Leader Global Communication, Manager National Technical Support Center. [M+] SOAP REST
Company Principal Last Name Text recording the last name of the principal. [M+] SOAP REST
Company Principal Management Responsibility Text identifying the business function of the principal derived from a standard Management Responsibility Code (MRC). [M+] SOAP REST
Company Principal Middle Name Text recording the middle name of the principal. [M+] SOAP REST
Company Principal Name Prefix Text that describes the correct form of address for this principal. For example, Dr., Professor, Lord, etc. SOAP REST
Company Principal Name Suffix Text recording a familial suffix to the principal's name (e.g. Senior, Junior, III. ) or a professional/qualification suffix to the principal's name (e.g. MD, PhD etc.) or some other suffix to the principals name (e.g. Retired). SOAP REST
Continent Code (World Region ID) Text recording the name of the region as defined by D&B for this address i.e. Africa, Australia/Asia, Europe, Middle East, South & Central America, North America. [M+] SOAP REST
Control Year The year current control was assumed. [M] SOAP REST
Country Name Text recording the name of the country in which the business is located. [M+] SOAP REST
D&B City Code D&B proprietary geographical code which indicates the city where the business is located. For US records, the code is unique within COUNTY, for non-US records, the code is unique within COUNTRY. [M+] SOAP REST
D&B Country Code D&B three-digit code which indicates the country where the business is located. SOAP REST
D&B County Code D&B geographical code which identifies the county where the business is located. Code is unique within state/province. [M+] SOAP REST
D&B Hoovers Industry Code An alphanumeric industry code identifying a business activity, based on a three-tier taxonomy developed by D&B as a complement to NAICS and SIC codes, that are assigned according to companies’ primary and secondary business activities. SOAP REST
D&B Industry Code An alphanumeric value identifying a business activity based on the scheme specified by the Standard Industrial Classification (SIC) Code. The first four digits are external codes created by the U.S. Government. D&B has created extensions to more precisely define an activity as in the case of the SIC 2+2 (the last 4 digits of an 8-digit SIC). SOAP REST
D&B State/Province Code D&B geographical code which indicates the state/province (aka primary subdivision) where the business is located. Only validated state/province names carry a state/province code. [M+] SOAP REST
Domestic Ultimate Business Name Text recording the name of the highest business in the family tree that is in the same country as the subject. [M] SOAP REST
Domestic Ultimate D&B Country Code D&B code of the country where the domestic ultimate is located. [M+] SOAP REST
Domestic Ultimate D-U-N-S Number The D-U-N-S Number of the highest level parent within a corporate family tree that is domiciled in the same country as the requested company. A parent is a corporation that owns more than 50% of another corporation's capital stock. A subject may be its own domestic ultimate. [M] SOAP REST
Domestic Ultimate FIPS Country Code The Federal Information Processing Standards (FIPS) code value which identifies the country where the domestic ultimate is located. SOAP REST
Domestic Ultimate Territory Abbreviated Name Text recording the shortened name of the locally governed area which forms part of a centrally governed nation to identify where the domestic ultimate is located. [M+] SOAP REST
Economic Area of Influence Code A code assigned by the U.S Bureau of Economic Analysis to identify the subject's regional market that surrounds a metropolitan or micropolitan statistical area serving as a regional center of economic activity. SOAP REST
Employee Quantity (All Locations) A number that defines how many people are directly engaged and paid by the organization to perform or support its business operations. [M] SOAP REST
Employee Quantity (Single Location) A number that defines how many people are directly engaged and paid by the organization to perform or support its business operations at the subject's location. [M] SOAP REST
Employee Quantity Reliability Text (All Locations) Text that describes the integrity of the employee figures, e.g. audited, actual, estimated, or modeled. [M+] SOAP REST
Employee Quantity Reliability Text (Single Location) Text that describes the integrity of the employee figures, e.g. audited, actual, estimated, or modeled. [M+] SOAP REST
Export Indicator When 'true' indicates that the subject company exports goods to other countries. [M] SOAP REST
Family Tree Hierarchy Level Code A two-position counter that indicates the number of family tree levels below the global ultimate business in its corporate hierarchy. The hierarchy level value of the global ultimate will always be 1. Each subsidiary level below the global ultimate is incremented by one. Branch locations in a family tree will have the same hierarchy code as its associated headquarter. [M] SOAP REST
FEIN Tax ID Number A number recording a unique nine-digit FEIN number assigned by the U.S. Internal Revenue Service to business entities (and in some cases individuals) operating in the United States for the purposes of identification. SOAP REST
Financial Statement Period (Key Financial Figures) The period of the financial statement expressed as a number of years, months or days. (e.g. P3M is 3 months or quarterly, P1Y is 1 year or annual) SOAP REST
FIPS Country Code The Federal Information Processing Standards (FIPS) code value which identifies the country where this subject is located. SOAP REST
FIPS County Code The Federal Information Processing Standards code value which identifies the county where this subject is located. SOAP REST
FIPS MSA Code The Federal Information Processing Standards (FIPS) code value which identifies the Metropolitan Statistical Area (MSA) where this subject is located. SOAP REST
FIPS State Code The Federal Information Processing Standards (FIPS) territory code for where this subject is located. SOAP REST
Geographical Precision Text Text that identifies the accuracy of the match used for an address. [M+] SOAP REST
Global Ultimate Business Name Text recording the primary name of the global ultimate business. [M] SOAP REST
Global Ultimate D&B Country Code D&B code of the country where the global ultimate is located. [M+] SOAP REST
Global Ultimate D-U-N-S Number The D-U-N-S number of the highest level parent within a corporate family tree. A parent is a corporation that owns more than 50% of another corporation's capital stock. A subject may be its own global ultimate. [M] SOAP REST
Global Ultimate FIPS Country Code The Federal Information Processing Standards (FIPS) code value which identifies the country where the global ultimate is located. SOAP REST
Global Ultimate Territory Abbreviated Name Text recording the shortened name of the locally governed area which forms part of a centrally governed nation to identify where the global ultimate is located. [M+] SOAP REST
Headquarter Business Name The business name of the headquarters company. A headquarters is a business establishment that has branches or divisions reporting to it. [M] SOAP REST
Headquarter D&B Country Code D&B code of the country where the company headquarters is located. [M+] SOAP REST
Headquarter D-U-N-S Number The D-U-N-S Number of the headquarters company. A headquarters is a business establishment that has branches or divisions reporting to it. [M] SOAP REST
Headquarter FIPS Country Code The Federal Information Processing Standards (FIPS) code value which identifies the country where the company headquarters is located. SOAP REST
Headquarter Territory Abbreviated Name Text recording the shortened name of the locally governed area which forms part of a centrally governed nation to identify where the headquarters is located. [M+] SOAP REST
Import Indicator When 'true' indicates that the subject company imports a quantity of goods from other countries. [M] SOAP REST
Last Update Date The date when the record was last updated in D&B's system. [M] SOAP REST
Line of Business Text recording the description of the operations conducted by a business. [M+] SOAP REST
Local Activity Industry Code Records the business activities in which an organization is actively engaged using standardized coding schemes such as European NACE and other country-specific Classification of Economic Activities. SOAP REST
Location Ownership Text Text specifying the terms under which this subject occupies the premises (i.e., one or more facilities) at the primary address, e.g., owned, rented or leased. [M+] SOAP REST
Major Industry Category A narrative description of the operations or activities of the business. Relates to the primary four-digit 1987 US SIC. In English. [M] SOAP REST
Metropolitan Statistical Area Code A code describing a geographical region with a relatively high population density at its core and close economic ties throughout the area. [M+] SOAP REST
Minority Owned Indicator When 'true' indicates that this organization is certified as a business that is greater than 50% owned by and whose management and daily business operations are controlled by one or more minority group members. [M] SOAP REST
Most Senior Principal First Name Text recording the first name of the most senior principal. [M+] SOAP REST
Most Senior Principal Full Name Text recording the name of the CEO. [M+] SOAP REST
Most Senior Principal Gender Text identifying the gender of the individual who has the highest ranking authority for the business at this location. SOAP REST
Most Senior Principal Job Title Text recording the job held by the most senior principal; For example, CEO, President and CEO. [M+] SOAP REST
Most Senior Principal Last Name Text recording the last name of the most senior principal. [M+] SOAP REST
Most Senior Principal Management Responsibility Text identifying the business function of the principal derived from a standard Management Responsibility Code (MRC). [M+] SOAP REST
Most Senior Principal Middle Name Text recording the middle name of the most senior principal. [M+] SOAP REST
Most Senior Principal Name Prefix Text that describes the correct form of address for this principal. For example, Dr., Professor, Lord, etc. SOAP REST
Most Senior Principal Name Suffix Text recording a familial suffix to the principal's name (e.g. Senior, Junior, III. ) or a professional/qualification suffix to the principal's name (e.g. MD, PhD etc.) or some other suffix to the principals name (e.g. Retired). SOAP REST
NAICS Code An alphanumeric value identifying the business activity based on the NAICS Code. Can repeat multiple times. SOAP REST
Number of Family Members Including Subsidiaries This is the number of linkages in the upward and downward directions of the entire family tree that the subject belongs to, starting from the global ultimate. [M] SOAP REST
Organization Identification Number A number assigned by an external body or by D&B which either uniquely identifies or helps to identify an organization. SOAP REST
Ownership Control Type Text that describes the type of controlling ownership e.g. publicly owned, privately owned, state owned. [M] SOAP REST
Parent Business Name Text recording the business name of the parent company. A parent is a corporation that owns more than 50% of another corporation's capital stock; these owned companies are subsidiaries to the parent company. [M] SOAP REST
Parent D&B Country Code D&B code of the country where the parent organization is located. [M+] SOAP REST
Parent D-U-N-S Number The D-U-N-S number of the parent company. A parent is a corporation that owns more than 50% of another corporation's capital stock; these owned companies are subsidiaries to the parent company.   [M] SOAP REST
Parent FIPS Country Code The Federal Information Processing Standards (FIPS) code value which identifies the country where the parent organization is located. SOAP REST
Parent Territory Abbreviated Name Text recording the shortened name of the locally governed area which forms part of a centrally governed nation to identify where the parent company is located. [M+] SOAP REST
Population Code A numeric value assigned by D&B that describes the density of the residential population for the geographical area where the business is located. SOAP REST
Premises Area Measurement Text that records the measurement of the premises. [M+] SOAP REST
Premises Function Text Text specifying an activity that is performed or is not performed at this facility by the subject, e.g., manufacturing, warehousing, printing, packaging, office work. [M+] SOAP REST
Primary Address Latitude The angular distance of the organization's primary physical address north or south from the Earth's equator measured through 90 degrees expressed in decimal numbers. [M+] SOAP REST
Primary Address Longitude The angular distance of the organization's primary physical address east or west from an imaginary line (called the prime meridian) that goes from the North Pole to the South Pole measured through 90 degrees expressed in decimal numbers. [M+] SOAP REST
Primary SIC Code The first listed alphanumeric value identifying the primary business activity based on the scheme specified by the Standard Industrial Classification (SIC) Code. The first four digits are external codes created by the U.S. Government. D&B has created extensions to more precisely define an activity as in the case of the SIC 2+2 (the last 4 digits of an 8-digit SIC). SOAP REST
Registration Number - All Countries Except US A registration/identifier number assigned by local government agencies to identify a business within the local market. Examples include the France Siret Number, UK CRO Number, Europe VAT Number, Australia Company Number, and Brazilian State Registry Number. SOAP REST
Sales Revenue Amount (Local Currency) The monetary value of income received from customers from the sale of the business' goods and/or services. This means it is the gross sales minus any returns, rebates/discounts, allowances for damages or shortages, shipping expenses passed on to the customer. [M] SOAP REST
Sales Revenue Amount (US Dollars) The revenue claimed in the income statement data in millions (USD) [M] SOAP REST
Secondary SIC Code An alphanumeric value identifying a business activity based on the scheme specified by the Standard Industrial Classification (SIC) Code. Clarification Note: These are generally external codes created by an external authoritative body like the U.S. Office of Management and Budget but D&B may have created extensions to more precisely define an activity as in the case of the SIC 2+2 (the last 4 digits of an 8-digit SIC). Can repeat up to five times. SOAP REST
Small Business Indicator When 'true' indicates that the subject qualifies as small business, eligible for assistance from SBA, with a place of business located in the United States. It must operate primarily within the United States or make a significant contribution to the U.S. economy through payment of taxes or use of American products, materials or labor. Together with its affiliates, it must meet the numerical size standards as defined in the Small Business Size Regulations 13 CFR 121. [M] SOAP REST
Time Period (Trend Data) Text that describes the time period reflecting the calculation of related Trend Data fields. Values include "Between 0 and 12 months" (trend year), "1-3 years" (3-year base) and "1-5 years" (5-year base). SOAP REST
Trend Year Employee Count (Trend Data) The total number of employees for the Trend Year, which is the last (most current) year. Trend Data fields are calculated once a year, in June, published the following July and used for the subsequent 12 months. SOAP REST
Trend Year Employee Count Reliability Text Text that describes the integrity of the employee figures, e.g. audited, actual, estimated, or modeled. SOAP REST
Trend Year Sales Amount (Trend Data) The Sales Amount from the income statement data in millions (USD) for the Trend Year, which is the last (most current) year. Trend Data fields are calculated once a year, in June, published the following July and used for the subsequent 12 months. [M] SOAP REST
UK SIC Code The first listed alphanumeric value identifying the primary business activity based on the UK SIC Code. SOAP REST

*The links in this column provide the technical characteristics for the data field of the respective business element in the XML or JSON response.

The preceding list is not presented in the order, nor manner, in which the information is packaged and delivered via the D&B Direct API.

While data for a particular company may not contain values for all of the business elements, there may be items that are considered by D&B to be essential to yield the maximum benefit of a data layer. If any of these essential elements do not contain a value for a particular company, an error code will be returned, and your organization will not incur a usage credit for the request.

The Product Availability Lookup feature may be utilized to determine if this D&B Direct product is available for a given D-U-N-S Number.

The availability of certain scores delivered by this product may be limited due to a lack of sufficient company or industry specific data to perform the calculations.

Major Industry Categories

D&B Direct

SDMR  Batch

Agriculture, Forestry and Fishing

Transportation, Communications, Electric, Gas and Sanitary Services

Wholesale Trade

Retail Sale

Finance, Insurance and Real Estate

Public Administration

WorldBase Compatibility

The following fields are included in this data layer for existing D&B customers who may have internal systems and/or processes that rely upon these codes:

New implementations should be developed using the corresponding fields that are based on coding standards for geographic locations. For example, instead of CountryWorldBaseCode, please use CountryISOAlpha2Code.

A conversion table for WorldBase to ISO codes is available on the Country Chart tab (far right column contains the WorldBase codes) of the downloadable Data Primer.

Dias Code, in a batch environment, is a sequence number of the monthly linkage file. In a batch environment, the Linkage file is updated on only a monthly basis. The Dias Code has the potential to change on a monthly basis due to linkage changes – additional linked records or closing of locations. The attempt to use Dias Codes across different monthly updates may cause issues in a customer’s database. Transactional Linkage processing does not access the monthly linkage file but a daily linkage file which does not have a Dias Code because it would have to change daily. Therefore, the Dias Code is not a field that is populated on a transactional response.

Additional Details

Access to this information is provided on a metered basis; and will require data layer entitlement prior to use in the production environment. A built-in feature exists to prevent duplicate billing when multiple requests with the same D-U-N-S Number and product code are submitted on the same calendar day (which is based on Eastern Standard Time [GMT-5]).

An option exists to retain the results from all successful requests for this product in a Product Request Archive, which may be retrieved without incurring additional usage charges.

Technical Specification

For details on how to obtain this data layer, please refer to the Firmographic.OrderProduct (SOAP) or Firmographic.OrderProduct (REST) page.

Back to Top