Dun & Bradstreet

DNBQuickCheck

The result of a D&B Quick Check, with information on location, situation, size and financial status on the business. For the Netherlands the DNBQuickCheck always returns the main establishment (hoofdvestiging). see: enquiry_duns

duns

DUNS identification number. The D&B DUNS number, which stands for Data Universal Numbering System, is a 9-digit non-indicative identification number assigned by Dun & Bradstreet to each separate commercial entity in the Dun & Bradstreet database. In other words, each record is given a different number. For businesses with multiple locations, each location is assigned its own unique D&B DUNS number. This field is always populated and contains the D&B DUNS number of the business that all other data elements in the record describe.

dnb_key

D&B Business key identifying the business. The D&B business key, like the DUNS number, uniquely identifies a business. However, it can only be used with methods of Webservices.nl, whereas the DUNS number can be used with every database or method by D&B. The advantage of the D&B business key is that it can be obtained at a lower cost than the DUNS number.

enquiry_duns

Identifier of case enquired upon, will be the same as DUNS unless a trade up from a branch to a headquarters location has taken place. When the DUNS of a branch location is given, it is possible that the information of the headquarter is returned instead. This is called a “trade up”. In this case, the DUNS field contains the DUNS number of the headquarter, while the EnquiryDUNS contains the DUNS which was requested. The information returned applies to the headquarter. In the Netherlands, a trade up always happens when a branch location is requested. An example can be retrieved by requesting DUNS 386060771.

business_number

Primary business identification number assigned to the business by a government agency, Chamber of Commerce or Association. This field contains the primary business identification number assigned to the business by a government agency, Chamber of Commerce or association. Optional.

business_number_type

This field contains the code representing the type of business identification number (i.e., Chamber of Commerce, VAT). This two or three letter code specifies what the number in BusinessNumber means. Optional.

9Z	Chamber of Commerce Number
ABQ	National Business Identification Number
AEB	Companies Registry Office Number (CRO)
HL	Systeme Informatique pour le Repertoire des Entreprises (SIREN) Number
VX	Value Added Tax Registration Number (Europe)
Q8	Company Register Number (DE)

business_number_description

This field contains the description representing the type of business identification number (i.e., Chamber of Commerce, VAT). This textual description specifies what the number in BusinessNumber means. Optional.

trade_name

Primary name of business

address

An array with address lines of the physical location.

postcode

Postal (ZIP) code where business is located

city

The name of the town in which the business is located.

region

Main sub-entity within the country in which the business is located, may be State, Province, Region (example, England). In the Netherlands, this field corresponds with the province (e.g. “Zuid-Holland”) Optional.

subregion

Second level country sub-entity, County (or equivalent), where business is located. For the Netherlands this field is not available. Optional.

country_calling_code

International dialing code for country in which the business is located, e.g. “31”.

phone_number

The main telephone number of the business. Different countries may have telephone numbers of varied lengths which may or may not include the country or city access codes. Each country does have an access code (contained in the CountryCallingCode field) which must be used when making an international call. Optional.

fax_number

Main facsimile number of business. Optional.

country

The 2 character ISO 3166-1 code for the country where the business is located.

ceo_name

Name of the primary executive in the company. The name of the individual or company identified as having the chief executive function. Highest ranking person on site: President, Owner, Branch Manager, etc. In some cases the individual’s title is included along with the name in this field. Optional.

ceo_title

Free form position title of primary executive in the company, e.g. “Chairman of the Board”. Optional.

principal_name

Name of the executive in the company. The name of the individual or company identified as having an executive function. In some cases the individual’s title is returned along with the name in this field. Optional.

principal_title

Free form position title of primary executive in the company, e.g. “Chairman of the Board”. Optional.

currency

Default currency code for figures in report code, e.g. “EUR”. Currency code for filing value in 3 character ISO 4217 format.

statement_currency

Currency code of financial statement if different than the default supplied in the ‘currency’ field. Optional.

debtor_inpossession

Indicates whether debtor is in possession of company. Optional.

criminal_proceedings

The Criminal Proceedings indicator provides an indication of whether criminal proceedings related to the case exist in D&B’s database. Optional.

suit_judgement

Indicates whether open suit(s), judgment(s), petition(s) and/or payment remarks exist in the D&B database for the company. A lawsuit may be an action to clear title to property and does not necessarily imply a claim for money against the subject. The public record item(s) that may have impacted this indicator may have been paid, terminated, vacated or released prior to the date this indicator was extracted from D&B’s file. Optional.

financial_embarrassment

Indicates whether record of an open or closed bankruptcy, receivership, liquidation, discontinuance with unpaid obligations or an equivalent event related to the company exists in the D&B database. Other specific event categories relate to administrator appointments and orders, Meeting of Creditors, Wind Up Petitions and Statements of Insolvency. The public record item(s) that may have impacted this indicator may have been closed or dismissed prior to the date this indicator was extracted from D&B’s file. Optional.

financial_legal_events

Indicates whether special events exist in D&B’s database that denote financial embarrassment or legal filings related to the business. These include Public Sales, Change of 50% of Assets, Public Filings, Letter of Liability, and Principals Antecedents – Bankruptcy (e.g., voluntary winding ups). The public record item(s) that may have impacted this indicator may have been closed or dismissed prior to the date this indicator was extracted from D&B’s file. Optional.

operational_events

Indicates whether special events exist in the D&B database that concern changes to the business’ operations. These include categories such as name changes; management changes; changes of legal form, control, or capital; business wind up or closure; or moves. Optional.

other_events

Indicates that special events not otherwise specified exist in the D&B database for the business. Optional.

disaster

Indicates if special events exist in the D&B database for the subject company concerning disasters such as fire, flood, earthquake, hurricane, etc. Optional.

secured_filings

Indicates whether open secured filings such as UCC filings, secured charges/mortgages pledgings, or equivalent exist for the business in D&B’s database. Only applicable in the U.S.A., not in the Netherlands. Optional.

out_of_business

Indicates that the company has discontinued operations. Optional.

history_indicator

Reserved for future use. Not available for businesses in Europe. Optional.

history_description

Reserved for future use. Not available for businesses in Europe. Optional.

income_statement_date

Date of Income/Profit & Loss Statement, in YYYYMMDD format, e.g. “20071231”. Indicates the date on the statement, which is usually the end of the period which the statement applies to. This field applies where no start/end dates are supplied. Optional.

income_statement_date_start

Start date of Income/Profit & Loss Statement, in YYYYMMDD format. The statement covers a period, starting on this date. Optional.

income_statement_date_end

End date of Income/Profit & Loss Statement, in YYYYMMDD format. The statement covers a period, ending on this date. Optional.

financial_statement_date

Date of current financial statement, e.g. “20071231”. May be full date in YYYYMMDD format, month and year, or year only. Optional.

incorporation_year

The year the business incorporated. The Incorporation Year may or may not be the same as the year the business started. Optional.

start_year

The year that the entity actually commenced present operations. If the entity was formed to acquire or continue the operations of a pre-existing entity, then the start date may reflect this original start date. Optional.

current_control_year

Year current control was assumed. This year indicates the last time the business switched owner or management. Optional.

local_activity_code

Activity code. The activity code indicates the activity of the business. It is a code in a system specific for the country. In the Netherlands, this field may contain BIK or SBI. Optional.

local_activity_code_type

Type of the code in LocalActivityCode, optional.

SBI	Standaard bedrijfsindeling
BIK	Bedrijfsindeling KvK
NACE_BEL	Belgian NACE 2008

local_activity_description

Description corresponding to the code in LocalActivityCode. Optional.

sic_activity_code

Standard Industrial Classification code. The 4-digit SIC code is an index which describes the function (manufacturer, wholesaler, retailer or service) and the line of business in which the company is engaged.

sic_activity_description

Activity description corresponding to the SICActivityCode. Uppercase, human-readable description such as “COMMERCIAL PHOTOGRAPHY”.

sic_version

Version of SIC in SICActivityCode. Possible values:

1972	used in Europe and Australia
1977	used in Canada
1987	used in the US

legal_form

Legal structure as registered with governmental authorities A code indicating the legal structure of the business as registered with governmental authorities. Examples include LSC/102 (private limited company) or LSC/10 (general partnership).

legal_form_description

A description for the legal structure, corresponding to the code given in LegalForm.

paydex_norm

The industry median or average D&B Paydex score for the subject’s Line of Business. Indications of slowness can be the result of disputes over merchandise, skipped invoices etc. Accounts are sometimes placed for collection even though the existence or amount of the debt is disputed. The D&B payment score (D&B Paydex) is a score that assesses the payment performance of a business. Based on the trade experiences in D&B’s database, the score corresponds to an average days beyond terms or within terms enabling you to predict when your existing or potential customers are likely to pay. Derived from a dollar-weighted average of a company’s combined individual payment experiences, it ranges from 0 to 100 with higher scores representing businesses which pay their bills more promptly. The D&B Paydex Interpretation Tables contain interpretation tables for D&B’s payment score for specific countries. Optional.

paydex_score

D&B PAYDEX Score for last 12 months experiences. Optional.

dnb_rating

Rating assigned by D&B. D&B uses several different rating classifications. The most common (e.g., 4A3) D&B Rating is divided into two parts: financial strength and composite credit appraisal. Financial Strength reflects company size based on worth computed by D&B. The Composite Credit Appraisal is an overall evaluation of credit worthiness. It takes into account the financial condition but also several non-financial factors such as trade payment history, length of operation, employee numbers, legal structure, management experience and any adverse listings. In some countries, D&B will use other information in its databases to assign ER (size by employee range) to businesses within specific industries or “1R”, “2R,” etc. ratings for companies without current financial statements on file. The Rating Interpretation Tables contain specific rating definitions and interpretation tables for countries around the world. See also ratings_scores_paydex.pdf

maximum_credit

Maximum amount of credit recommended. For Europe only. Optional.

maximum_credit_currency

Currency Code for credit recommendation amount if different than the default supplied in the ‘currency’ field.

intangible_assets

Total of intangible assets (goodwill, patents, research & development, non-issued capital, organizational expenses). May or may not be net of depreciation/ amortization. Optional.

net_worth

Total amount of Equity (Net Worth). Includes capital stock, retained earnings treasury stock, etc. Is not the Tangible Net Worth. May be negative. Optional.

tangible_net_worth

A DNBMonetaryAmount with the tangible net worth (net worth minus intangibles). Optional. Only returned when no financial statement exists.

sales

Net sales for the period after returns, allowances, and discounts are deducted. In Europe, this is the Sales for the period less taxes. Optional.

annual_sales

A DNBMonetaryAmount with annual sales generated by the business. Optional. Only returned when no financial statement exists.

employees_primary

An DNBEmployeeCount with the number of employees at the referenced address. Not available for the Netherlands. Optional.

employees_total

An DNBEmployeeCount with the total number of personnel employed by business. Includes personnel at branches and divisions. Includes subsidiaries only in Canada and the United States. Optional.

trade_names

An array with trade styles used by business. Trade Styles are additional business names used by the company - also referred to as a DBA (doing business as) or AKA (also known as) names. In some jurisdictions, these names are shown to be registered to, and therefore owned by, a company. They are used to secure the name, advertise a particular product or to distinguish between different parts of the company’s operations or divisions. Optional.

DNBBusinessVerification

For the Netherlands the DNBQuickCheck always returns the main establishment (hoofdvestiging). see: enquiry_duns

duns

dnb_key

enquiry_duns

business_number

business_number_type

9Z	Chamber of Commerce Number
ABQ	National Business Identification Number
AEB	Companies Registry Office Number (CRO)
HL	Systeme Informatique pour le Repertoire des Entreprises (SIREN) Number
VX	Value Added Tax Registration Number (Europe)
Q8	Company Register Number (DE)

business_number_description

trade_name

Primary name of business

address

An array with address lines of the physical location.

postcode

Postal (ZIP) code where business is located

city

The name of the town in which the business is located.

region

Main sub-entity within the country in which the business is located, may be State, Province, Region (example, England). Optional.

subregion

Second level country sub-entity, County (or equivalent), where business is located. Optional.

country_calling_code

International dialing code for country in which the business is located, e.g. “31”.

phone_number

fax_number

Main facsimile number of business. Optional.

country

The 2 character ISO 3166-1 code of the country where the business is located.

main_branch_indication

Indication whether this dossier is for a branch or a headoffice. If true, this dossier is for a headoffice. If false, it is for a branch. Optional.

out_of_business

Indicates that the company has discontinued operations. Optional.

incorporation_year

The year the business incorporated. The Incorporation Year may or may not be the same as the year the business started. Optional.

start_year

sic_activity_code

sic_activity_description

Activity description corresponding to the SICActivityCode. Uppercase, human-readable description such as “COMMERCIAL PHOTOGRAPHY”.

sic_version

Version of SIC in SICActivityCode. Possible values:

1972	used in Europe and Australia
1977	used in Canada
1987	used in the US

trade_names

An array with trade styles used by business. Trade Styles are additional business names used by the company

also referred to as a DBA (doing business as) or AKA (also known as) names. In some jurisdictions, these names are shown to be registered to, and therefore owned by, a company. They are used to secure the name, advertise a particular product or to distinguish between different parts of the company’s operations or divisions. Optional.

DNBEnterpriseManagement

The result of a D&B Enterprise Management, with information on location, situation, size and financial status on the business.

quickcheck

A DNBQuickCheck with QuickCheck information for this business.

main_branch_indication

Boolean which indicates whether this business is a branch or a headoffice. If true, this dossier is for a headoffice. If false, it is for a branch. Optional.

indate_indicator

Indicator containing in date status. This indicates whether the data is up to date. If data for this company is available, but out of date, the value false (Investigation Recommended) is returned. Optional.

true	Indate
false	Investigation Recommended

registration_type

Type of registration (e.g. non profit)

RTC/1	cooperative
RTC/2	federally chartered
RTC/3	professional
RTC/4	profit
RTC/5	state chartered
RTC/6	nonprofit
RTC/7	provincially chartered

import_indicator

Indicates whether the business imports

export_indicator

Indicates whether the business exports

location_ownership

Indicates whether premises at physical address are owned or rented.

E	Co-Owns
G	Other (free form available)
H	Shares
L	Leases
O	Owns
R	Rents
U	Utilizes

claims_indicator

Indicates if open claim(s), lien(s), protested bill(s), warrant(s), Social Securities Summon(s) and/or equivalent exist in the D&B database for the case company.

paydex_score_earlier

D&B Paydex Score from 3 months ago.

average_high_credit

The average high credit represents the median of the highest credit extended to the subject business over the past 12 months. It is calculated by taking the sum of all high credit dollar amounts (unique vendor account experiences) divided by the total number of account experiences.

high_credit

Highest balance of the account during the past 12 months.

total_payments

The total number of payment experiences contained in D&B’s database for the subject company.

headquarters

A DNBRelatedBusiness with the headquarters name, its D&B DUNS number and the country code in which it is located.

parent

A DNBRelatedBusiness with the parent company. The parent company is that which has a majority interest in the subject entity (i.e., directly owns more than 50%). The subject entity is then referred to as a ‘subsidiary.’

domestic_ultimate

A DNBRelatedBusiness with the domestic ultimate parent. The domestic ultimate is the highest corporate family member in the same country as the subject business entity if you walk up the “branch” of the corporate family tree. A case may be its own domestic ultimate. The fields will be blank if the subject case is a single location (not linked) in the D&B database. The Domestic Ultimate Name is the legal business name. The domestic ultimate can be a headquarters or a branch/division. A country can have more than one domestic ultimate. There will be a separate Domestic Ultimate for each “limb” of a tree.

global_ultimate

A DNBRelatedBusiness with the global ultimate parent. The global ultimate is the highest member of the corporate family worldwide. Fields will be blank if the business has a single location (i.e., not linked) in the D&B database. The global ultimate Name is the legal business name. The Country code is the 2 character ISO code for the country in which the global ultimate is located.

is_subsidiary_location

Indicates whether the subject business is a subsidiary.

location_status

Indicates whether the subject business is a branch, headquarters, or single location.

HQ	Headquarters
BR	Branch
SL	Single Location

accounts_audited

Indicates whether D&B has been able to determine whether the financial statement was prepared by audit.

statement_consolidated

Indicates whether statement is consolidated or not.

figures_estimated

Indicates whether the financial statement figures are estimated or measured/actual.

figures_forecast

Indicates financial statement figures are future projections. Only present in Taiwan.

year_period

Indicates whether the financial statement period is 12 months or not.

figures_final

Indicates if financial statement figures are the final closing statement for a business which has ceased trading.

opening_statement

Indicates figures that are the opening statement for the business.

figures_proforma

Indicates the financial statement figures are pro forma. Typically used to represent the state of a company as a result of a pending change (i.e., merger, consolidation) based on actual or known performance.

trial_balance

Indicates that financial statement figures are trial balance.

figures_signed

Indicates if figures are signed by principals.

figures_restated

Indicates figures resubmitted after corrections to original statement for period.

figures_unbalanced

Indicates submitted balance sheet figures do not balance. This may be caused by arithmetic errors contained in the financial data that was provided to Dun & Bradstreet.

figures_qualified

Indicates auditors have made qualifying remarks about the fairness and accuracy of the figures.

accounts_receivable

Amount of sales made and billed to customers on credit terms. This is money owed by customers and not yet received. Also called Trade Debtors. The value may or may not be net of bad debts. In Italy, Accounts Receivable include Cambiali Debtors where applicable.

liquid_assets

Amount of Cash on hand and in banks and other liquid assets where available.

inventory

Includes Merchandise on hand that is ready to be sold. May also include work in progress and Raw Materials minus depreciation.

total_current_assets

Total amount of all current (< 1 year) assets.

total_assets

Total amount of current and long-term assets.

accounts_payable

Amount of merchandise purchased on credit and not paid for by the balance sheet date. Also known as Trade Creditors. In Italy, Accounts Payable include Cambiali Creditors where applicable.

total_current_liabilities

Total amount of all current (< 1 year) liabilities.

total_liabilities

Total liabilities owed by business.

net_income

Amount left over after all expenses and taxes are deducted. Also called Net Profit or Loss after Taxes.

quick_ratio

Cash plus Accounts Receivable divided by Current Liabilities.

current_ratio

Current Assets divided by Current Liabilities.

previous_net_worth

Previous Net Worth minus intangibles. May be negative to reflect a deficit net tangible worth position.

previous_sales

Net sales for previous period.

previous_statement_date

Date of previous financial statement. May be full date, month and year, or year only.

line_of_business

Summary of the business activities. Derived from the SIC code.

failure_score

A DNBScoreGroup with the failure risk score. D&B’s Failure Risk (Financial Stress) Scores predict the probability of severe financial distress or failure.

credit_score

A DNBScoreGroup with the credit score. The Credit (Delinquency) Score is a statistically modeled D&B Score indicating the risk of delinquent payments based on the information in D&B’s file. The higher the Credit (Delinquency) Score, the lower the probability of payment delinquency.

global_failure_score

A DNBScoreGroup with the global failure risk score. D&B’s Global Failure Risk Score predicts the likelihood of a firm ceasing business without paying all creditors in full over the next 12 months. The precise definition of failure varies from country to country because of differences in law, how business is conducted and how statistics are collected.

DNBScoreGroup

score

The Credit (Delinquency) Score is a statistically modeled D&B Score indicating the risk of delinquent payments based on the information in D&B’s file. The higher the Credit (Delinquency) Score, the lower the probability of payment delinquency.

score_commentaries

A Patterns::{Type}Array of DNBCommentary entries. The Credit (Delinquency) Score Commentary field is a repeating field containing codes which explain the conditions driving the score assigned to the business.

score_class

The Credit (Delinquency) Score Class enables a customer to quickly segment their new and existing accounts into various risk segments to determine appropriate marketing or credit policies.

national_percentile

The Credit (Delinquency) Score Percentile illustrates where a company falls among businesses in the D&B information base, and is most effectively used by customers to rank order their portfolios from highest to lowest risk of delinquency. The Percentile is based on a 1 – 100 scale, where a 1 represents businesses that have the highest probability of severe delinquency, and a 100 which represents businesses with the lowest probability of severe delinquency.

score_override_code

Credit (Delinquency) Score Override Code will be populated for special case instances in Australia where the delinquency score is a special value (0, 893-895) or cannot be calculated.

incidence_of_default

The Incidence of Delinquent Payment shows the percentage of firms in a given score range that paid in a delinquent manner (90 + days past terms) over the past year. The Incidence of Delinquent Payment among all firms in D&B’s files represents the national delinquency rate and is provided for comparative purposes. All Commercial Credit Class, Percentile, Score and Incidence statistics are based on 2001.

score_date

The date on which the score was determined.

industry_norm

Industry norm for the credit score.

industry_incidence_of_default

The Incidence of Delinquent Payment provides the percentage of firms within a given score range in D&B’s file that paid creditors in a severely delinquent manner over the last year.

industry_percentile

unnormalized_score

Absolute, unnormalized score.

algorithm_id

Identifies the model used to calculate the score. For the Netherlands, the following three score models are available, depending on the legal form:

NL- SEG A	For non-private companies
NL- SEG B	For private companies
NL- SEG C	For private holding companies

Service methods

The Netherlands

Belgium

Great Britain

Germany

Ireland

Italy

France

Spain

Portugal

Austria

Malta

dnbSearchReference

Parameters

Returns

See also

dnbGetReference

Parameters

Returns

dnbQuickCheck

Parameters

Returns

See also

dnbBusinessVerification

Parameters

Returns

See also

dnbEnterpriseManagement

Parameters

Returns

Type definitions

DNBBusinessReference

DNBQuickCheck

DNBBusinessVerification

DNBEnterpriseManagement

DNBScoreGroup

DNBCommentary

DNBRelatedBusiness

DNBEmployeeCount

DNBMonetaryAmount