Cookies Settings

Loading

dnb-logo
Office Apps
Collapse

Data Dictionary

Excel Display Name Description Type Length D&B Direct Field Scope
DUNS Number The D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S). This DUNS Number represents the business entity. string 9 D-U-N-S Number Y
Company Name Text recording of a single name by which the organization is primarily known or identified. string 90 Primary Business Name Y
Doing Business As Text recording the name which an organization trades under for commercial purposes although its registered legal name used for contracts and other formal situations may be another name. string 90 Trade Style Name
Street Address Text recording the address number, or post office box number and street name where the business is located. string 64 Street Address Y
Street Address2 Text recording the address number, or post office box number and street name where the business is located. string 64 Street Address (2)
City Text recording the name of a city, town, township, village, borough, etc. where the business is located. string 50 Town Name Y
State Abbrv Text recording the shortened name of the locally governed area which forms part of a centrally governed nation to identify where the business is located. string 10 Territory Abbreviated Name Y
Postal Code An identifier used by the local country Postal Authority to identify where the business is located. string 16 Postal Code Y
Country Text recording the name of the country in which the business is located. string 50 Country Name Y
State/Province Text recording the name of the locally governed area which forms part of a centrally governed nation to identify where the business is located. string 50 Territory Name Y
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. numeric 10 Primary Address Latitude
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. numeric 11 Primary Address Longitude
Mailing Address Text recording an address which is mainly utilized for the purpose of mail delivery to the business. This usually includes a Post Office Box number or similar mailing details. string 64 Mailing Street
Mailing Address2 Text recording an address which is mainly utilized for the purpose of mail delivery to the business. This usually includes a Post Office Box number or similar mailing details. string 64 Mailing Street (2)
Mailing City The address number, or post office box number, and street name which a business uses for mailing purposes. string 50 Mailing Town Name
Mailing State Abbrv Text recording the shortened name of the locally governed area which forms part of a centrally governed nation which the business uses for mailing purposes. string 10 Mailing Territory Abbreviation
Mailing Postal Code An identifier used by the local country Postal Authority which the business uses for mailing purposes. string 16 Mailing Postal Code
Telephone Number The telephone number of the business. string 16 Telephone Number Y
International Dialing Code The telephone number international dialing code of the business. string 4 Telephone Number International Dialing Code
Annual Sales USD The revenue claimed in the income statement data in millions (USD) numeric 15 Sales Revenue Amount (US Dollars) Y
Employees Total A number that defines how many people are directly engaged and paid by the organization to perform or support its business operations. numeric 15 Employee Quantity (All Locations) Y
Employees Total A number that defines how many people are directly engaged and paid by the organization to perform or support its business operations. numeric 15 Employee Quantity (All Locations) Y
Employees Here 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. numeric 15 Employee Quantity (Single Location)
Control Year The date when the current owners took over this business. date 4 Control Year
Location Status Code Text recording of various parts that the Subject plays as a member of an ownership structured family tree. string 15 Family Tree Member Role
Subsidiary Indicator Text recording of various parts that the Subject plays as a member of an ownership structured family tree. string 14 Family Tree Member Role
Small Business Ind 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. boolean 26 Small Business Indicator
Public Private Ind Text that describes the type of controlling ownership e.g. publicly owned, privately owned, state owned. string 7 Ownership Control Type
Legal Status Code Text recording the legal form or structure of a business as registered with government authorities e.g. partnership corporation private limited company government department proprietorship. string 40 Business Legal Structure
Import Export Code A code value that identifies whether the business imports goods or services for re-manufacture or sale, exports products or services to a foreign country, and/or is an agent for goods. string
21

Global Ultimate DUNS 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. string 9 Global Ultimate D-U-N-S Number
Global Ultimate Company Name Text recording the primary name of the global ultimate business. string 90 Global Ultimate Business Name
Domestic Ultimate DUNS 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. string 9 Domestic Ultimate D-U-N-S Number
Domestic Ultimate Company Name Text recording the name of the highest business in the family tree that is in the same country as the subject. string 90 Domestic Ultimate Business Name
Parent DUNS 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.   string 9 Parent D-U-N-S Number
HQ DUNS 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. string 9 Headquarters D-U-N-S Number
HQ/Parent Company Name The primary name of the Parent/Headquarters company. string
90

Total Family Members 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. numeric 5 Number of Family Members Including Subsidiaries
SIC A four digit numeric value identifying the primary business activity of this company based on the Standard Industrial Classification system. string 8 Primary SIC Code Y
3 Year Sales Growth Rate 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. numeric 4 3 Year Growth Percentage on Sales Volume (Trend Data)
3 Year Employees Growth Rate 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 by100. numeric 4 3 Year Growth Percentage on Employees (Trend Data)
Minority Owned Ind 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. boolean 14 Minority Owned Indicator
Diversity Detail A code describing the type of minority business. Can repeat up to five times. string 27 Minority Classification Code
Woman Owned Ind 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 female persons. The percentage of ownership requirement may boolean 11 Woman-Owned Indicator
Veteran Owned Ind When 'true' indicates that the business entity is owned and controlled by a Veteran. boolean 13 Veteran Owned Indicator
Labor Surplus Ind When 'true' indicates that this organization is certified as a business that operates in a labor surplus area, which is a geographical area identified by the Department of Labor as an area of concentrated unemployment or underemployment or an area of labo boolean 18 Labor Surplus Area Indicator
OB Ind Text that records the operating status of the business. string 15 Out of Business Indicator
Marketing Prescreen Score Prescreen score is a D&B marketing tool that predicts the likelihood of a company’s ability to pay all its bills on time over the next 12 months. Updated monthly, it shows the likelihood that a company may become a collection problem. Scores are calculated using statistical models and the most recent payment information in D&B’s commercial database. It is intended to be a marketing tool and should not be used for credit decisions on individual organizations. string 13 Marketing Prescreen Score
SIC Description Text that describes the business activity based on the scheme specified by the attribute type, e.g., 'highway and street construction' is the description of industry code 1611 in the U.S. SIC (Standard Industrial Classification) system. string 65 Primary SIC Description Y