Activity Indicator

Describes a specific activity code by system and/or component (Canadian government SIC, U.S. government two digit 1977 SIC code). Table of code values available upon request. Example: ‘60’ = U.S. 1972 format.

Annual Sales in U.S. dollars

Sales of the business in U.S. dollars. Currency exchange rate is updated once each year.

Annual Sales Indicator

0 = actual
1 = low end of range
2 = estimated or not available if sales value is zero
blank = not available

Annual Sales Local

Sales of the business generally in local currency. Refer to currency code to determine currency used.

Business Name

Primary name of the business.

Cable Telex

Cable or telex number of the business. Provided as entered in the local database. No edits performed.

Chief Executive Officer Name

Highest authority at this location.

Chief Executive Officer Title

Title of the highest authority at this location. May be abbreviated.

City Code

Code for the city where business is located. U.S.: unique within county. Other countries: unique within country.
Only validated city names carry a city code, otherwise code is blank.

City Name

Name of the city where business is located. Generally in local language.

Continent Code

1 = Africa
2 = Australia/Asia
3 = Europe
4 = Middle East
5 = South & Central America
6 = North America (US and Canada)

Control Indicator

Field currently not used.

Country Code

Three digit code for the country where the business is located. Assigned to D&B WorldBase.

Country Name

Name of the country where the business is located.

Country Telephone Access Code

Dialling code used to access the country phone system from outside the country. Can be 1 to 4 digits.

County Code

Code for the county where the business is located. Populated in U.S. & Canada only. Unique within state/province. AKA secondary subdivision. Zeroes if not available.

Currency Code

Code indicating in which currency the annual sales volume, net worth, and profit-loss are expressed. Table available. Example: German ‘1200’ = mark

DIAS Code

A code that sequences a file in order by ultimate parent name and family sequence within each group. Blank if not linked.

Domestic Ultimate Business Name

Primary name of the Domestic Ultimate business. Blank if not linked.

Domestic Ultimate City Code

Code for the city where the Domestic Ultimate is located. Blank if not linked.

Domestic Ultimate City Name

Name of the city where the Domestic Ultimate is located. Blank if not linked.

Domestic Ultimate Country Code

Code for the country where the Domestic Ultimate is located. Blank if not linked.

Domestic Ultimate D-U-N-S Numbers

D-U-N-S number for the Domestic Ultimate, which is the highest family member in the same country as this business entity as you walk up this ‘branch’ of the tree. A case may be its own Domestic Ultimate.

Domestic Ultimate Post Code

Post code for the city in which the Domestic Ultimate is located. Blank if not linked.

Domestic Ultimate State Abbreviation

Abbreviated name of the state or province in which the Domestic is located. Blank if not linked.

Domestic Ultimate State/Province Name

Name of the state or province in which the Domestic Ultimate is located. Blank if not linked.

Domestic Ultimate Street Address

Physical street address of the Domestic Ultimate company. Blank if not linked.

D-U-N-S Number

A randomly generated nine digit number assigned by D&B to identify unique business establishments.

Employees Here

The number of employees at this location. Available only for U.S. and Canadian records at this time.

Employees Here Indicator

0 = actual
1 = low end of range
2 = estimated or not available if employees here value is zero
blank = not available

Employees Total

Total number of employees in the business.

Employees Total Indicator

0 = actual
1 = low end of range
2 = estimated or not available if employees here value is zero
blank = not available

Family Update Date

Date (YYYYMMDD) when the entire family tree linkage (all members) was reviewed and verified by the ultimate business. Linkage on individual records may have been reviewed and updated since this date. Populated on Global Ultimate record only. Blank if not linked.

Fax Number

Fax number of the business. Provided as entered in the local database. No edits are performed.

Global Ultimate City Code

Code for the city where the ultimate company is located. Blank if not linked.

Global Ultimate City Name

Name of the city where the ultimate company is located. Blank if not linked.

Global Ultimate Continent Code

Code for the continent is which the ultimate company is located. Blank if not located.

Global Ultimate Country Code

Code for the country where the company is located. Blank if not linked.

Global Ultimate Country Name

Name of the country where the ultimate company is located. Blank if not linked.

Global Ultimate County Code

Code for the county where the ultimate company is located. Present when U.S. or Canadian ultimate. Blank if not linked.

Global Ultimate D-U-N-S Number

The D-U-N-S number of the uppermost parent of a corporate family. Global Ultimate records carry their own case D-U-N-S number in this field so that a common sort and/or match area is available for all family members. Blank if not linked.

Global Ultimate Indicator

If ‘Y’, this case is the Global Ultimate, otherwise ‘N’. Blank if not linked.

Global Ultimate Name

Name of the ultimate company. Blank if not linked.

Global Ultimate Post Code

Post (ZIP) code of the ultimate company. Blank if not linked.

Global Ultimate State/Province

Name of the state or province in which the ultimate company is located. Blank if not linked.

Global Ultimate Street Address

Physical address of the ultimate company. Blank if not linked.

Headquarters/Parent Business Name

Primary name of the business’s headquarters or parent. Blank if not linked.

Headquarters/Parent Continent Code

Code for the continent where the headquarters or parent is located. Blank if not linked.

Headquarters/Parent Country Code

Code for the country where the parent or headquarters is located. Blank if not linked.

Headquarters/Parent Country Name

Name of the country in English where the parent or headquarters is located. Blank if not linked.

Headquarters/Parent County Code

Code for the county where the parent or headquarters is located. Present when U.S. or Canadian parent/headquarters. Blank if not linked.

Headquarters/Parent D-U-N-S Number

D-U-N-S number of the parent/headquarter organisation. Blank if not linked.

Headquarters/Parent Post Code

Post (ZIP) code where the headquarters or parent is located. Blank if not linked.

Headquarters/Parent State/Province

State/province name is which the headquarters or parent is located. Blank if not linked.

Headquarters/Parent State/Province Abbreviation

Abbreviated state name where the headquarters or parent is located. Blank if not linked.

Headquarters/Parent Street Address

Physical street address of the headquarters or parent company. Blank if not linked.

Headquarters/Parents City

Name of the city where the headquarters or parent is located. Blank if not linked.

Headquarters/Parents City Code

Code of the city where the parent or headquarters is located. Blank if not linked.

Hierarchy Code

Blank if not linked.

Import/Export/ Agent Indicator

A Import/Export/Agent
B Imports & Exports
C Imports
D Imports and Agents
E Exports and Agents
F Agent - Keeps no inventory and does not tale title to goods.
G Not Available or None
H Exports

Include Principles Indicator

Indicates that the principles are included in the Employee Total figure. (‘Y’ = included) Primarily available on non-U.S. records.

Legal Status

Shows the legal status of this business. Updated table can be obtained from the Integrated Solutions Consultant in your region of Customer Database Services.

Line of Business

Narrative description in English of the operations or activities of the business. Relates to the four digit primary SIC code which is the 1987 U.S. government code.

Mailing Address

Mailing location of the establishment (e.g., post office box).

Mailing City Code

City code used for mailing address. In U.S. unique within county. Elsewhere unique within the country.

Mailing City Name

City name used for mailing address. Generally in local language.

Mailing Continent Code

1 = Africa
2 = Australia/Asia
3 = Europe
4 = Middle East
5 = South & Central America
6 = North America (US and Canada)

Mailing Country Code

Three digit country code used for mailing address. Assigned for D&B WorldBase.

Mailing Country Name

Name of the country housing the city, used for mailing address in English language.

Mailing County Code

Code of the county used for mailing address on U.S. & Canadian records only.

Mailing County name

Name of the county housing the city, used for mailing address. On U.S. & Canada records only. Also known as secondary subdivision.

Mailing State/Province Abbreviation

Abbreviated state/province name used for mailing address. Abbreviated to two characters in U.S. & Canada. Left justified.

Mailing State/Province Code

State/province codes used for mailing address. Only validated state/province names carry a state/province code.

Mailing State/Province Name

Name of state/province used for mailing address. Generally in local language. Also known as primary subdivision.

National Identification Number

Business identification number used in some countries for business registration and tax collection. Examples include CRO numbers in the U.K. and the French Siren numbers.

National Identification System Code

Identifies the type of national ID number system used, for example ‘12’ = CRO, ‘14’ = Siren. A table describing each code value is available.

Number of Family Members

Number of family members including the Global Ultimate and all subsidiaries and branches of the entire family tree world-wide. Every family member of tree carries the same count. Blank if not linked.

Post Code For Mailing Address

Post or zip code for the mailing location.

Post Code for Street Address

Post or zip code for the physical location.

Previous D-U-N-S Number

D-U-N-S number that was previously assigned to this business. Available only on U.S. records at this time.

Primary Local Activity Code

Represents the locally used activity code. Examples include 1972 U.S. SIC, SBA, APE, and NACE.

Registered Address Indicator

Records in Europe that have been bulk loaded from public registry sources will carry a registered address only, unless the business has been investigated by D&B or another source has provided address data. If the registered address is the only available address, it will be provided in the physical street address and this indicator will be equal to Y. The registered address can be the office of the solicitor registering the business name.

Report Date

Date on which a D&B analyst completed review of all the information reported about the business. The format of this field is YYYYMMDD.

Secondary Name

Trade style or secondary name, if used by the company.

State/Province Abbreviation

Abbreviations for the physical state/province name of the establishment. The state or province name is abbreviated to two characters in U.S. & Canada. Left justified.

State/Province Code

Code of the state/province where the business is located. AKA primary subdivision. Only validated state/province names carry a state/province code. Zeroes if not available.

State/Province Name

Name of the state/province where the business is located. Generally in local language.

Status Code

0 Single Location - no other entities report to it
1 Headquarter/Parent - branches and/or subs report to it
2 Branch - secondary location to a Headquarter
4 Division - a separate operation

Street Address

Physical location of the establishment. Generally in local language.

Street Address 2

Physical address line 2 of the establishment. Generally in local language.

Subsidiary Code

0 No subsidiary
3 Subsidiary

Telephone Number

Telephone number for the business. In the U.S., these are direct dialling telephone numbers with area code and no punctuation. In other countries, the number is provided as entered in the local database, which may include punctuation. Different countries may have differing length telephone numbers which may or may not include the area code, country or city access code. No edits are performed on this field.

U.S. 1987 SIC 1

The 1987 standard industrial classification code system categorises business establishments based upon the type of activity done by that establishment at that location. A business can have up to six SIC codes. The first SIC code represents the primary function of the business. After that, SIC codes are assigned in descending order according to the percentage of the revenue contribution by each function of the business (see below). The SIC code of a parent/ultimate may include the activities of its subsidiaries. All input is converted as closely as possible to the U.S. 1987 for-digit standard code.

U.S. 1987 SIC 2

Secondary SIC code of the business in the U.S. 1987 format.

U.S. 1987 SIC 3

Third SIC code of the business in the U.S. 1987 format.

U.S. 1987 SIC 4

Fourth SIC code of the business in the U.S. 1987 format.

U.S. 1987 SIC 5

Fifth SIC code of the business in the U.S. 1987 format.

U.S. 1987 SIC 6

Sixth SIC code of the business in the U.S. 1987 format.

Ultimate State/Province Abbreviation

Abbreviated name of the state/province where the ultimate company is located. Blank if not linked.

User Area

The user may place a defined value here. Typical uses are for key codes, dealer codes and/or special information requested by the user. If not requested, this field will be blank.

Year Started

A four-digit numeric field representing the year that current ownership took control or the year established if no control change took place. Not available on branch records.