| VARIABLE |
DESCRIPTION |
| PRIMARY_COMPANY_NAME |
The single name by which the organization is primarily known / identified. |
| DUNS_NUMBER |
The D-U-N-S® Number, a proprietary organizational identifier owned and managed by Dun & Bradstreet Inc, provides unique identification of a subject organization, in accordance with the Data Universal Numbering System (D-U-N-S®). |
| REGISTRATION_NUMBER |
The details of the organization’s identifiers issued by a recognized external authority to uniquely identify subjects. The issuing authority may be a Registration Authority, Government Department or Commercial Enterprise (e.g., Chamber of Commerce numbers, VAT numbers). |
| COUNTRY |
The 2 letter alpha country code assigned by the International Organization for Standardization (ISO) identifying the Country/Region where the organization’s Primary address is located or conducts operations . |
| PRIMARY_ADDRESS_COUNTRY_NAME |
The Country or Region where the organization’s Primary Address is located or conducts operations . |
| PRIMARY_ADDRESS_COUNTY_NAME |
The name of the geographical area of a Country or Region where the organization’s address is located or conducts operations. Countries subdivide their geography into smaller sub divisions. County is an example of a commonly used subdivision, often found in the UK. |
| PRIMARY_ADDRESS_LOCALITY_NAME |
The name of the locality where the organization’s Primary Address is located or conducts operations. Locality defined as a district population cluster. City, town, township, village, borough etc. |
| PRIMARY_ADDRESS_REGION_NAME |
The name of the geographical area where the organization’s Primary Address is located or conducts operations. For Example New Jersey. |
| PRIMARY_ADDRESS_STREET_NUMBER |
The numerical part of the street address where the organization’s Primary Address is located or conducts operations. This may be a single number, a number with an appendix, or a range of street numbers. |
| PRIMARY_ADDRESS_REGION_ABBREVIATED_NAME |
The shortened name of the geographical area where the organization’s Primary Address is located or conducts operations For example NJ for the US State New Jersey within Country United States. |
| PRIMARY_ADDRESS_MINOR_TOWN_NAME |
The name of the village, town or suburb where the organization’s Primary Address is located or conducts operations. For example Booker in Booker, High Wycombe. |
| PRIMARY_ADDRESS_POSTAL_CODE |
The postal code of the organization’s Primary Address.Also known locally in various English-speaking countries throughout the world as a postcode, post code, Eircode, PIN or ZIP Code) is a series of letters or digits or both, sometimes including spaces or punctuation, included in a postal address for the purpose of sorting mail. The code is used by the country's postal authority to identify the address where the organization is located or conducts operations . |
| PRIMARY_ADDRESS_STREET_ADDRESS_1 |
The first line of the address where the entity is located.The first line of the Primary Address where the organization is located or conducts operations. |
| PRIMARY_ADDRESS_STREET_ADDRESS_2, |
The second line of the Primary Address where the organization is located or conducts operations |
| PRIMARY_ADDRESS_STREET_NAME |
The name of the street where the organization’s Primary address is located or conducts operations. |
| INDUSTRY_CODES |
The details of the business activities in which the organization is actively engaged using a standardized coding schemes such as European NACE and U.S. Standard Industry Classification (SIC). Note: Since some of the industry coding schemes are derived, multiple codes from a more granular coding scheme can result in same code in another less granular coding scheme |
| PRIMARY_INDUSTRY_CODE |
The 4-digit code in the U.S. SIC (Standard Industrial Classification) 1987 system assigned to an organization categorizing the primary business activities performed at its location. For example, 1611 represents the highway and street construction industry. |
| PRIMARY_INDUSTRY_CODE_DESCRIPTION |
The description of the business activities represented by the Primary US SIC Code. For example, ‘highway and street construction’ is the description of industry code 1611. |
| CORPORATE_LINKAGE_GLOBAL_ULTIMATE_DUNS |
The unique identification number assigned by Dun and Bradstreet identifying the top most organisation in the family tree. |
| CORPORATE_LINKAGE_GLOBAL_ULTIMATE_PRIMARY_ NAME |
Single name by which the organization is primarily known or identified. |
| CORPORATE_LINKAGE_GLOBAL_ULTIMATE_COUNTRY |
The details of the country or region where the address of the organization is located or conducts operations. |
| CORPORATE_LINKAGE_DOMESTIC_ULTIMATE_DUNS |
The D-U-N-S® number of the highest ranking member of a family tree within the same country/region within a limb of a family tree. |
| CORPORATE_LINKAGE_DOMESTIC_ULTIMATE_PRIMARY_ NAME |
Single name by which the organization is primarily known or identified. |
| CORPORATE_LINKAGE_PARRENT_DUNS |
The D-U-N-S® number of the organization that owns more than 50% of the subject organization. |
| CORPORATE_LINKAGE_PARRENT_PRIMARY_NAME |
Single name by which the organization is primarily known or identified. |
| CONTROL_OWNERSHIP_TYPE_CODE |
A unique code assigned by Dun & Bradstreet to identify the type of controlling ownership. |
| CONTROL_OWNERSHIP_TYPE_DESCRIPTION |
The name for the type of controlling ownership (e.g., publicly owned, privately owned, state owned). Note: For some countries, controlling ownership can be derived from the legal form. |
| CORPORATE_LINKAGE_GLOBAL_ULTIMATE_FAMILY_ TREE_MEMBERS_COUNT |
The total number of entities in the entity’s Family tree starting from Global Ultimate. |
| CORPORATE_LINKAGE_BRANCHES_COUNT |
The total number of branch companies that report to the subject in the family tree. |
| LEGALFORM_DNB_CODE |
A unique code assigned by D&B for the Global Legal Form. |
| LEGALFORM_DESCRIPTION |
The text description of the unique code assigned by Dun & Bradstreet for the Global Legal Form. |
| REGISTERED_DETAILS_LEGALFORM_DNB_CODE |
The unique code assigned by D&B for the Legal Form. |
| REGISTERED_DETAILS_LEGALFORM_DESCRIPTION |
The text description of the unique code assigned by D&B for the Legal Form. |
| BUSINESS_ENTITY_TYPE_DNB_CODE |
A unique code assigned by D&B to identify the Legal Form Class. |
| BUSINESS_ENTITY_TYPE_DESCRIPTION |
The text description of the unique code assigned by Dun & Bradstreet for the Legal Form Class. |
| TELEPHONE_NUMBER |
The details of the Telephone contact information used for voice communication with the organization. |
| EMAIL |
The details of the email address used to contact the entity. |
| WEBSITE_ADDRESS_URL |
The details of the internet URLs used for online information and communication with the Organization. |
| ACTIVITY_DESCRIPTION |
The details of the descriptions of operations in different languages. |
| INCORPORATED_DATE |
The date on which a legal form was first registered with the appropriate Government body for this organization. |
| NUMBER_OF_EMPLOYEES |
The details of the number of individuals engaged by a business for various purposes, e.g., to perform its business operations. |
| FINANCIALS |
The details of the standardized summary view of the financial results (actual or estimated) for the organization. |
| DUNS_CONTROL_STATUS_OPERATING_STATUS_DESCRIPTION |
The entity’s functional state or trading status summarized into either active or out of business. |
| DUNS_CONTROL_STATUS_OPERATING_STATUS_CODE |
A unique code assigned by Dun & Bradstreet to identify the entity’s functional state or trading status. |
| DUNS_CONTROL_STATUS_OPERATING_STATUS_START_ DATE |
A date identifying the beginning of the time period in which this Operating Status is or was applicable. |
| DUNS_CONTROL_STATUS_ISMARKETABLE |
Indicates whether the data on the entity satisfies Dun & Bradstreet’s marketability rules for Sales & Marketing Solutions products. |
| IS_STANDALONE |
Indicates if the entity is a member of a legal family tree. |
| IS_EXPORTER |
Indicates if the entity is an exporter. |
| IS_IMPORTER |
Indicates if the entity is an importer. |
