BvD

On this page

This article outlines how to configure the BvD (Bureau van Dijk) enricher. BvD is now part of Moody’s and is a global provider of company and business intelligence data. Its Orbis platform contains information on hundreds of millions of public and private companies worldwide, including company identifiers, financial statements, ownership structures, corporate hierarchies, directors, industry classifications, and legal entity information. The purpose of the BvD enricher is to use the Orbis API to retrieve and enrich golden records with verified business information such as company identifiers, financials, ownership information, directors, corporate hierarchies, and industry classifications.

The BvD enricher supports the following endpoints:

  • https://api.bvdinfo.com/v1/orbis/Companies/match
  • https://api.bvdinfo.com/v1/orbis/Companies/data

Add BvD enricher

The enricher requires at least one of the following attributes to search for company information:

  • BvD ID – if your golden records have BvD ID, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the BvD ID to search for company information. If your golden records do not have a BvD ID, then the other attributes will be used for search.

  • Name – if your golden records have organization names, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the organization name to search for company information. If your golden records do not have organization names, then one of the other attributes will be used for search.

  • Country – if your golden records have country, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the country to search for company information. If your golden records do not have country, then one of the other attributes will be used for search (Recommended for use together with other attributes).

  • Address – if your golden records have address, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the address to search for company information. If your golden records do not have address, then one of the other attributes will be used for search (Recommended for use together with other attributes).

  • City – if your golden records have city, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the city to search for company information. If your golden records do not have city, then one of the other attributes will be used for search (Recommended for use together with other attributes).

  • Post Code – if your golden records have post code, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the post code to search for company information. If your golden records do not have post code, then one of the other attributes will be used for search (Recommended for use together with other attributes).

  • State – if your golden records have state, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the state to search for company information. If your golden records do not have state, then one of the other attributes will be used for search (Recommended for use together with other attributes).

  • Website – if your golden records have website, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the website to search for company information. If your golden records do not have website, then one of the other attributes will be used for search (Recommended for use together with other attributes).

  • Email – if your golden records have email, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the email to search for company information. If your golden records do not have email, then one of the other attributes will be used for search.

  • Phone number – if your golden records have phone number, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the phone number to search for company information. If your golden records do not have phone number, then one of the other attributes will be used for search.

  • Fax number – if your golden records have fax number, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the fax number to search for company information. If your golden records do not have fax number, then one of the other attributes will be used for search.

  • National ID – if your golden records have national ID, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the national ID to search for company information. If your golden records do not have national ID, then one of the other attributes will be used for search.

  • Ticker – if your golden records have ticker, you can enter the corresponding vocabulary key to configure the enricher. As a result, the enricher will use the ticker to search for company information. If your golden records do not have ticker, then one of the other attributes will be used for search.

To add the BvD enricher

  1. On the navigation pane, go to Preparation > Enrich. Then, select Add Enricher.

  2. On the Choose Enricher tab, select BvD, and then select Next.

    bvd-enricher-1.png

  3. On the Configure tab, provide the following details:

    • API Key – enter the API key for retrieving information from the BvD/Moody’s API.

    • Accepted Business Domain – enter the business domain to define which golden records will be enriched.

    • BvD ID – enter the vocabulary key that contains company BvD ID that will be used to search for company information.

    • Validate BvD ID – toggle to control whether the BvD ID needs to be validated before enrichment. Toggle only visible when BvD ID vocabulary key is provided.

    • Auto Enrich with First and Highest Score Match – toggle to control whether the enrichment should be based on the first and highest score match if BvD ID validation failed or BvD ID is empty.

    • Enrichment properties – the properties that should be returned to CluedIn as a result of enrichment (e.g., NAME,CITY,ADDRESS_LINE1). Currently, CluedIn only supports up to 496 properties. Get the available properties from the curl command below (copy the FieldId and paste it into the Enrichment properties field) or see Available properties.

         curl --location 'https://api.bvdinfo.com/v1/orbis/Companies/metadata/select' \
         --header 'Content-Type: application/json' \
         --header 'ApiToken: {APIKey}'
      
    • Score Limit – the score limit required for matches to be considered in the validation process. (e.g., if you enter 0.5, only matches with scores more than 0.5 will be used for validation).

    • Name – enter the vocabulary key that contains company name that will be used to search for company information.

    • Country – enter the vocabulary key that contains country of company that will be used to search for company information.

    • Address – enter the vocabulary key that contains company address that will be used to search for company information.

    • City – enter the vocabulary key that contains city of company that will be used to search for company information.

    • Post Code – enter the vocabulary key that contains post code of company that will be used to search for company information.

    • State – enter the vocabulary key that contains state of company that will be used to search for company information.

    • Website – enter the vocabulary key that contains company website that will be used to search for company information.

    • Email – enter the vocabulary key that contains company email that will be used to search for company information.

    • Phone number – enter the vocabulary key that contains company phone number that will be used to search for company information.

    • Fax number – enter the vocabulary key that contains company fax number that will be used to search for company information.

    • National ID – enter the vocabulary key that contains company national ID that will be used to search for company information.

    • Ticker – enter the vocabulary key that contains company ticker that will be used to search for company information.

    • ISIN – enter the vocabulary key that contains company ISIN codes that will be used to search for company information.

    bvd-enricher-2.png

  4. Select Test Connection to make sure the enricher is properly configured, and then select Add.

    The BvD enricher is added and has the active status. It means that it will enrich relevant golden records when they are processed or when you trigger external enrichment.

After the BvD enricher is added, you can modify its details:

  • Settings – add a user-friendly display name, select the description for data coming from the enricher, and define the source quality for determining the winning values.

  • Authentication – modify the details you provided while configuring the enricher.

BvD enricher flow for different configurations

  • Match endpoint results referring to results returned from https://api.bvdinfo.com/v1/orbis/Companies/match endpoint.

BvD ID Present

| Validate | Auto Match | Match Endpoint Result | Outcome | | — | — | — | — | | Disabled | Disabled | Not applicable | Enrich using provided BvD ID | | Disabled | Enabled | Not applicable | Enrich using provided BvD ID | | Enabled | Disabled | Empty | Skip (throw) | | Enabled | Enabled | Empty | Skip (throw) | | Enabled | Disabled | BvD ID found in matches (pass) | Enrich using provided BvD ID | | Enabled | Enabled | BvD ID found in matches (pass) | Enrich using provided BvD ID | | Enabled | Disabled | BvD ID not in matches (fail) | Store Raw_Matches + Bvd_Id_Needs_Attention=true | | Enabled | Enabled | BvD ID not in matches (fail) | Enrich using first match from match endpoint result |

BvD ID Not Present (Empty/Not Provided)

Validate Auto Match Match Endpoint Result Outcome
Either Either Empty Skip (throw)
Disabled Disabled Non-empty Skip (throw)
Enabled Disabled Non-empty Store Raw_Matches + Bvd_Id_Needs_Attention=true
Disabled Enabled Non-empty Enrich using first match from match endpoint result
Enabled Enabled Non-empty Enrich using first match from match endpoint result
  • Note: BvD.organization.bvdIdNeedsAttention=true indicates that the BvD ID is not passing validation and it requires a manual update.

    Properties from BvD enricher

To quickly find the properties added to golden records from the BvD enricher, use the integrations filter on the Properties page.

bvd-enricher-3.png

For a more detailed information about the changes made to a golden record by the BvD enricher, check the corresponding data part on the History page.

bvd-enricher-4.png

Available enrichment properties from BvD API

CF_CRMTable=CRM Table
COMPANY_FLAGS=Flags
ADDRESS_LINE1=Address line 1
ADDRESS_LINE2=Address line 2
ADDRESS_LINE3=Address line 3
ADDRESS_LINE4=Address line 4
POSTCODE=Postcode
CITY=City
CITY_STANDARDIZED=Standardized city
COUNTRY=Country
COUNTRY_ISO_CODE=Country ISO code
TERRITORY_ISO_CODE=ISO territory code
LATITUDE=Latitude
LONGITUDE=Longitude
COUNTRY_REGION=Region in country
COUNTRY_REGION_TYPE=Type of region in country
NUTS1=NUTS1
NUTS2=NUTS2
NUTS3=NUTS3
MSA=Metropolitan Statistical Area
WORLD_REGION=World region
US_STATE=State or province (in US or Canada)
COUNTY=County (in UK)
ADDRESS_TYPE=Type
PHONE_NUMBER=Telephone number
FAX_NUMBER=Fax number
DOMAIN=Domain
WEBSITE=Website address
EMAIL=E-mail address
BUILDING=Building
STREET=Street
STREET_NUMBER=Street number
STREET_NUMBER_EXTENSION=Street number extension
STREET_AND_STREET_NUMBER=Street & street number
STREET_SUPPLEMENT=Street supplement
PO_BOX=PO Box
MINOR_TOWN=Minor town
STANDARDIZED_ADDRESS_LINE1=Address line 1
STANDARDIZED_ADDRESS_LINE2=Address line 2
STANDARDIZED_ADDRESS_LINE3=Address line 3
STANDARDIZED_ADDRESS_LINE4=Address line 4
STANDARDIZED_ADDRESS_LINE5=Address line 5
STANDARDIZED_ADDRESS_LINE6=Address line 6
STANDARDIZED_ADDRESS_LINE7=Address line 7
STANDARDIZED_ADDRESS_LINE8=Address line 8
STANDARDIZED_ADDRESS_LINE9=Address line 9
STANDARDIZED_ADDRESS_LINE10=Address line 10
STANDARDIZED_COUNTRY=Country
STANDARDIZED_COUNTRYISO2_CODE=Country ISO 2 code
STANDARDIZED_COUNTRYISO3_CODE=Country ISO 3 code
STANDARDIZED_VERIFICATION_LEVEL=Verification level
STANDARDIZED_BUILDING=Building
STANDARDIZED_PREMISE=Premise
STANDARDIZED_SUBBUILDING=Sub-building
STANDARDIZED_STREET=Street
STANDARDIZED_DEPENDENTSTREET=Dependent street
STANDARDIZED_SUPERADMINAREA=Super-administrative area
STANDARDIZED_ADMINAREA=Administrative area
STANDARDIZED_SUBADMINAREA=Sub-administrative area
STANDARDIZED_LOCALITY=Locality
STANDARDIZED_DEPENDENTLOCALITY=Dependent locality
STANDARDIZED_DOUBLEDEPENDENTLOCALITY=Double-dependent locality
STANDARDIZED_POSTALCODE=Postal code
STANDARDIZED_POSTBOX=Post box
ADDRESS_LINE1_ADDITIONAL=Address line 1
ADDRESS_LINE2_ADDITIONAL=Address line 2
ADDRESS_LINE3_ADDITIONAL=Address line 3
ADDRESS_LINE4_ADDITIONAL=Address line 4
POSTCODE_ADDITIONAL=Postcode
CITY_ADDITIONAL=City
CITY_STANDARDIZED_ADDITIONAL=Additional address(es) - Standardized city
COUNTRY_ADDITIONAL=Country
COUNTRY_ISO_CODE_ADDITIONAL=Country ISO code
LATITUDE_ADDITIONAL=Latitude
LONGITUDE_ADDITIONAL=Longitude
COUNTRY_REGION_ADDITIONAL=Region in country
COUNTRY_REGION_TYPE_ADDITIONAL=Type of region in country
ADDRESS_TYPE_ADDITIONAL=Type
PHONE_NUMBER_ADDITIONAL=Telephone number
FAX_NUMBER_ADDITIONAL=Fax number
BUILDING_ADDITIONAL=Building
STREET_ADDITIONAL=Street
STREET_NUMBER_ADDITIONAL=Street number
STREET_NUMBER_EXTENSION_ADDITIONAL=Street number extension
STREET_AND_STREET_NUMBER_ADDITIONAL=Street & street number
STREET_SUPPLEMENT_ADDITIONAL=Street supplement
PO_BOX_ADDITIONAL=PO Box
MINOR_TOWN_ADDITIONAL=Minor town
TRADE_DESCRIPTION_EN=Trade description (English)
TRADE_DESCRIPTION_ORIGINAL=Trade description in original language
TRADE_DESCRIPTION_LANGUAGE=Ibid, language
PRODUCTS_SERVICES=Products & services
DESCRIPTION_HISTORY=Description and history
BVD_SECTOR_CORE_LABEL=BvD sectors
SPECIALISATION=Specialisation
REINSURANCE_COMPANY_INDICATOR=Reinsurance company indicator
INDUSTRY_CLASSIFICATION=National industry classification used by the IP
INDUSTRY_PRIMARY_CODE=Primary code(s) in this classification
INDUSTRY_PRIMARY_LABEL=Ibid, description
INDUSTRY_SECONDARY_CODE=Secondary code(s) in this classification
INDUSTRY_SECONDARY_LABEL=Ibid, description
NACE2_MAIN_SECTION=NACE Rev. 2 main section
NACE2_CORE_CODE=NACE Rev. 2, core code (4 digits)
NACE2_CORE_LABEL=Ibid, description
NACE2_PRIMARY_CODE=NACE Rev. 2, primary code(s)
NACE2_PRIMARY_LABEL=Ibid, description
NACE2_SECONDARY_CODE=NACE Rev. 2, secondary code(s)
NACE2_SECONDARY_LABEL=Ibid, description
NAICS2022_CORE_CODE=NAICS 2022, core code (4 digits)
NAICS2022_CORE_LABEL=Ibid, description
NAICS2022_PRIMARY_CODE=NAICS 2022, primary code(s)
NAICS2022_PRIMARY_LABEL=Ibid, description
NAICS2022_SECONDARY_CODE=NAICS 2022, secondary code(s)
NAICS2022_SECONDARY_LABEL=Ibid, description
USSIC_CORE_CODE=US SIC, core code (3 digits)
USSIC_CORE_LABEL=Ibid, description
USSIC_PRIMARY_CODE=US SIC, primary code(s)
USSIC_PRIMARY_LABEL=Ibid, description
USSIC_SECONDARY_CODE=US SIC, secondary code(s)
USSIC_SECONDARY_LABEL=Ibid, description
OPGNAME=Peer Group Name
OPGDESC=Peer Group Description
OPGSIZE=Peer Group Size
OVERVIEW_FULL_OVERVIEW=Full overview
OVERVIEW_HISTORY=History
OVERVIEW_PRIMARY_BUSINESS_LINE=Primary business line
OVERVIEW_SECONDARY_BUSINESS_LINE=Secondary business line
OVERVIEW_MAIN_ACTIVITY=Main activity
OVERVIEW_SECONDARY_ACTIVITY=Secondary activity
OVERVIEW_MAIN_PRODUCTS_SERVICES=Main products and services
OVERVIEW_SIZE_ESTIMATE=Size estimate
OVERVIEW_STRATEGY_ORGANIZATION_AND_POLICY=Strategy, organization and policy
OVERVIEW_STRATEGIC_ALLIANCES=Strategic alliances
OVERVIEW_NETWORK_MEMBERSHIP=Membership of a network
OVERVIEW_MAIN_BRAND_NAMES=Main brand names
OVERVIEW_COUNTRY_NAME=Main domestic country
OVERVIEW_MAIN_FOREIGN_COUNTRIES_OR_REGIONS=Main foreign countries or regions
OVERVIEW_MAIN_PRODUCTION_SITES=Main production sites
OVERVIEW_MAIN_DISTRIBUTION_SITES=Main distribution sites
OVERVIEW_MAIN_SALES_REPRESENTATION_SITES=Main sales representation sites
OVERVIEW_MAIN_CUSTOMERS=Main customers
OVERVIEW_CONCISE_INFORMATION_INDICATOR=Concise information indicator
BVD_ID_NUMBER=BvD ID number 
BVD_ACCOUNT_NUMBER=BvD account number 
ORBISID=Orbis ID number
NATIONAL_ID=National ID 
NATIONAL_ID_LABEL=National ID label 
NATIONAL_ID_TYPE=National ID type 
TRADE_REGISTER_NUMBER=Trade register number 
VAT_NUMBER=VAT/Tax number 
EUROPEAN_VAT_NUMBER=European VAT number 
ECB_FVC_ID=ESCB Financial Vehicle Corporation ID
ECB_MFI_ID=ESCB Monetary Financial Institution ID
TIN=Tax Identification Number (TIN)
LEI=LEI (Legal Entity Identifier)
STATISTICAL_NUMBER=Statistical number 
COMPANY_ID_NUMBER=Other company ID number 
NATIONAL_ID_PREVIOUS=Previous SIRET number (France)
NATIONAL_ID_DATE_PREVIOUS=Previous SIRET number date (France)
SWIFT_CODE=SWIFT_CODE
INFORMATION_PROVIDER_ID=Information provider ID
INFORMATION_PROVIDER_ID_LABEL=Information provider ID label
TICKER=Ticker symbol 
ISIN=ISIN number 
ISIN_ALL=ISIN number (All)
LEI_STATUS=Status
LEI_FIRST_ASSIGNMENT_DATE=First assignment date
LEI_ANNUAL_RENEWAL_DATE=Annual renewal date
LEI_MANAGING_LOCAL_OFFICE_UNIT_STR=Managing Local Operating Unit
RELEASE_DATE=Release date
INFORMATION_PROVIDER=Information provider
INFORMATION_PROVIDER_COLLECTION_DATE=Information provider collection date
COMPANY_CATEGORY=Size classification
NAME=Company name
PREVIOUS_NAME=Previous company name
PREVIOUS_NAME_DATE=Name change date
AKA_NAME=Also known as name
STATUS=Status
STATUS_DATE=Status date
STATUS_CHANGE_DATE=Status updated date
LOCAL_STATUS=Local status
LOCAL_STATUS_DATE=Local status date
LOCAL_STATUS_CHANGE_DATE=Local status change date
STANDARDISED_LEGAL_FORM=Standardized legal form
NATIONAL_LEGAL_FORM=National legal form
BRANCH_INDICATOR=Branch indicator
INCORPORATION_DATE=Date of incorporation
INCORPORATION_STATE=State or province of incorporation (in US or Canada)
INCORPORATION_STATE_CODE=State or province of incorporation (in US or Canada)
ENTITY_TYPE=Type of entity
WOMAN_OWNED_INDICATOR=Woman owned indicator (in US)
MINORITY_OWNED_INDICATOR=Ethnic minority owned indicator (in US)
BANK_HISTORY=History (for banks)
CONSOLIDATION_CODE=Consolidation code
FILING_TYPE=Filing type
CLOSING_DATE_LAST_ANNUAL_ACCOUNTS=Latest annual account closing date
CLOSING_DATE_LAST_INTERIM_ACCOUNTS=Latest interim account closing date
YEAR_LAST_ACCOUNTS=Last available year
LIMITED_FINANCIAL_INDICATOR=Limited financial indicator
NO_RECENT_FINANCIAL_INDICATOR=No recent financial indicator
NUMBER_YEARS=Number of available years
ORIGINAL_CURRENCY=Original currency
ACCOUNTING_TEMPLATE=Accounting template
ADDITIONAL_ACCOUNTS_PRESENCE_INDICATOR=Additional accounts presence indicator
HISTORICAL_RECORD_INDICATOR=Historical record indicator
HISTORICAL_RECORD_DATE=Historical record since
FILING_EXEMPTION=Reason of filing exemption
FILING_EXEMPTION_MOTHER_NAME=Mother deposing liability statements - Name
FILING_EXEMPTION_MOTHER_BVD_ID_NUMBER=Mother deposing liability statements - BvD ID number
FILING_EXEMPTION_START_DATE=Start date of liability
FILING_EXEMPTION_LAST_YEAR=Latest annual account year of liability statement
GSIFI_TYPE=Type
GSIFI_BUCKET=Bucket
GSIFI_DATE=Date
GSIFI_SOURCE=Source
LEGAL_EVENTS_DATE=Date
LEGAL_EVENTS_DESCRIPTION=Description
LEGAL_EVENTS_SOURCE=Source
LEGAL_EVENTS_ID=Official identifier
LEGAL_EVENTS_TYPES_VALUE=Type
LEGAL_EVENTS_DETAILS=Details
CHARITY_REGISTRATION_DATE=Registration date
CHARITY_DATE_ORGANISATION_ESTABLISHED=Date established
CHARITY_SIZE=Size
CHARITY_OPERATING_COUNTRIES=Countries of operations
CHARITY_REGISTER_NAME=Register name
CHARITY_TYPE=Charity type
CHARITY_BENEFICIARIES=Charity beneficiaries
CHARITY_REGISTRATION_STATUS=Registration status
CHARITY_LAST_DELIVERY_DATE=Last delivery date
CHARITY_NUMBER_OF_RESPONSIBLE_PERSONS=Number of responsible persons
GST_Registration_status=Registration status
GST_Registration_date=Registration date
CLOSING_DATE=Closing date
FISCAL_YEAR=Fiscal year
QUARTER_YEAR=Quarter year
NUMBER_MONTHS=Number of months
AUDIT_STATUS=Audit status
ACCOUNTS_STATUS=Accounts status
ACCOUNTING_PRACTICE=Accounting practice
ACCOUNTS_SOURCE_CODE=Source of financials
ORIGINAL_UNIT=Original unit
ORIGINAL_CURRENCY=Original currency
EXCHANGE_RATE=Exchange rate from original currency
OPRE=Operating revenue (Turnover)
PLBT=P/L before tax
PL=P/L for period [=Net income]
CF=Cash flow [Net Income before D&A]
TOAS=Total assets
SHFD=Shareholders funds
CURR=Current ratio (x)
PRMA=Profit margin (%)
RSHF=ROE using P/L before tax (%)
RCEM=ROCE using P/L before tax (%)
SOLR=Solvency ratio (Asset based) (%) 
EMPL=Number of employees
MODEL_DATA_SUBJECT_CORPORATE_GROUP_LINKAGE_DESCRIPTION=Model data -  Subject corporate group linkage description
MODEL_DATA_GLOBAL_PARENT_BVDID=Model data - Global parent bvdid
MODEL_DATA_GLOBAL_PARENT_OPERATING_REVENUE=Model data - Global parent operating revenue
MODEL_DATA_GLOBAL_PARENT_OPERATING_REVENUE_ACCURACY_INDICATOR=Model data - Global parent operating revenue accuracy indicator
MODEL_DATA_GLOBAL_PARENT_NUMBER_OF_EMPLOYEES=Model data - Global parent number of employees
MODEL_DATA_GLOBAL_PARENT_NUMBER_OF_EMPLOYEES_ACCURACY_INDICATOR=Model data - Global parent number of employees accuracy indicator
MODEL_DATA_GLOBAL_PARENT_TOTAL_ASSETS=Model data - Global parent total assets
MODEL_DATA_GLOBAL_PARENT_TOTAL_ASSETS_ACCURACY_INDICATOR=Model data - Global parent total assets accuracy indicator
MODEL_DATA_CALCULATION_DATE=Model data - Calculation date
QUOTED_IN_STR=Listing status
MAINEXCHANGE=Main exchange
CDS_DATE=Date
CDS_SPREAD_5Y=Spread 5 years Senior Unsecurred
CDS_RECOVERY_RATE=Recovery rate
CDS_RATING_5Y=Rating 5 years
CDS_IMPLIED_RATING=Implied rating
CDS_DATE_MOST_RECENT=Date
CDS_SPREAD_5Y_MOST_RECENT=Spread 5 years Senior Unsecurred
CDS_RECOVERY_RATE_MOST_RECENT=Recovery rate
CDS_RATING_5Y_MOST_RECENT=Rating 5 years
CDS_IMPLIED_RATING_MOST_RECENT=Implied rating
MANAGED_FUNDS_NAME=Managed funds - Name
MANAGED_FUNDS_BVD_ID_NUMBER=Managed funds - BvD ID number
MANAGED_FUNDS_ORBISID=Managed funds - Orbis ID number
MANAGED_FUNDS_LEI=Managed funds - Legal Entity Identifier (LEI)
MANAGED_FUNDS_COUNTRY_ISO_CODE=Managed funds - Country ISO code
MANAGED_FUNDS_CITY=Managed funds - City
MANAGED_FUNDS_INFORMATION_DATE=Managed funds - Information date
MANAGED_FUNDS_INFORMATION_SOURCE=Managed funds - Information source
MANAGED_FUNDS_CURRENT_INDICATOR=Managed funds - Current/Archived
MANAGED_FUNDS_NATIONAL_ID=National number
MANAGED_FUNDS_AKA_NAME=Also known as name
MANAGED_FUNDS_PREVIOUS_NAME=Previously known as name
MANAGED_FUNDS_ADDRESS_LINE1=Street, no., building etc, line 1
MANAGED_FUNDS_ADDRESS_LINE2=Street, no., building etc, line 2
MANAGED_FUNDS_ADDRESS_LINE3=Street, no., building etc, line 3
MANAGED_FUNDS_ADDRESS_LINE4=Street, no., building etc, line 4
MANAGED_FUNDS_POSTCODE=Postal code
MANAGED_FUNDS_PHONE_NUMBER=Telephone number
MANAGED_FUNDS_WEBSITE=Website address
CPYCONTACTS_MEMBERSHIP_DIFFERENT_PERSONS_CNT=Number of directors & managers
CPYCONTACTS_HEADER_FullNameOriginalLanguagePreferred=Full name
CPYCONTACTS_HEADER_IdDirector=UCI (Unique Contact Identifier)
CPYCONTACTS_HEADER_BvdId=Corresponding BvDID (when applicable)
CPYCONTACTS_MEMBERSHIP_Function=Job title (in English)
CPYCONTACTS_MEMBERSHIP_FunctionOriginalOriginalLanguagePreferred=Job title (in local language when available)
CPYCONTACTS_MEMBERSHIP_BeginningNominationDate=Appointment date
CPYCONTACTS_MEMBERSHIP_EndExpirationDate=Resignation date
CPYCONTACTS_MEMBERSHIP_CurrentPrevious=Current or previous
CPYCONTACTS_HEADER_BareTitle=Title (i.e. Dr, Lord)
CPYCONTACTS_HEADER_PrefixSalutation_Translated=Salutation
CPYCONTACTS_HEADER_FirstNameOriginalLanguagePreferred=First name
CPYCONTACTS_HEADER_MiddleNameOriginalLanguagePreferred=Middle name
CPYCONTACTS_HEADER_LastNameOriginalLanguagePreferred=Last name
CPYCONTACTS_HEADER_Suffix=Suffix
CPYCONTACTS_HEADER_Gender=Gender
CPYCONTACTS_HEADER_Birthdate=Birth date
CPYCONTACTS_HEADER_Age=Age
CPYCONTACTS_HEADER_AgeRange=Age bracket
CPYCONTACTS_HEADER_PLACEOFBIRTH=Birth place
CPYCONTACTS_HEADER_MultipleNationalitiesLabel=Country/ies of nationality
CPYCONTACTS_MEMBERSHIP_WorkFullAddress=Address
CPYCONTACTS_HEADER_CountryLabel=Country
CPYCONTACTS_HEADER_Email=E-mail address
CPYCONTACTS_HEADER_Biography=Biography
CPYCONTACTS_MEMBERSHIP_BoardMnemonic=Type of role
CPYCONTACTS_MEMBERSHIP_DepartmentFromHierCo...=Board, committee or department
GUO_NAME=Global ultimate owner information Name
GUO_BVD_ID_NUMBER=Global ultimate owner information BvD ID number
GUO_ORBISID=Global ultimate owner information Orbis ID number
GUO_LEI=Global ultimate owner information Legal Entity Identifier (LEI)
GUO_TICKER=Global ultimate owner information Ticker symbol
GUO_COUNTRY_ISO_CODE=Global ultimate owner information Country ISO code
GUO_TERRITORY_ISO_CODE=Territory ISO code
GUO_STATE_PROVINCE=Global ultimate owner information State or province (in US or Canada)
GUO_CITY=Global ultimate owner information City
GUO_ENTITY_TYPE=Global ultimate owner information Type
GUO_NACE_CORE_CODE=Global ultimate owner information NACE,Core code
GUO_NACE_CORE_LABEL=Global ultimate owner information NACE,text description
GUO_NAICS_CORE_CODE=Global ultimate owner information NAICS, Core code
GUO_NAICS_CORE_LABEL=Global ultimate owner information NAICS, text description
GUO_USSIC_CORE_CODE=Global ultimate owner information US SIC, Core code
GUO_USSIC_CORE_LABEL=Global ultimate owner information US SIC, text description
GUO_DIRECT_PCT=Global ultimate owner information Direct %
GUO_TOTAL_PCT=Global ultimate owner information Total %
GUO_INFORMATION_SOURCE=Global ultimate owner information Information source
GUO_INFORMATION_DATE=Global ultimate owner information Information date
GUO_OPRE=Global ultimate owner information Operating revenue (Turnover)
GUO_TOAS=Global ultimate owner information Total assets
GUO_EMPL=Global ultimate owner information Number of employees
GUO_CURRENT_PREVIOUS_MANAGER=Global ultimate owner information Also a manager
GUO_NATIONAL_ID=National number
GUO_SWIFT_CODE=SWIFT code
GUO_AKA_NAME=Also known as name
GUO_PREVIOUS_NAME=Previously known as name
GUO_ADDRESS_LINE1=Street, no., building etc, line 1
GUO_ADDRESS_LINE2=Street, no., building etc, line 2
GUO_ADDRESS_LINE3=Street, no., building etc, line 3
GUO_ADDRESS_LINE4=Street, no., building etc, line 4
GUO_POSTCODE=Postal code
GUO_PHONE_NUMBER=Telephone number
GUO_FAX_NUMBER=Fax number
GUO_WEBSITE=Website address
GUO_PLBT=Global ultimate owner information P/L before tax
GUO_PL=Global ultimate owner information P/L for period [=Net income]
GUO_SHFD=Global ultimate owner information Shareholders funds
DUO_NAME=Domestic ultimate owner information Name
DUO_BVD_ID_NUMBER=Domestic ultimate owner information BvD ID number
DUO_ORBISID=Domestic ultimate owner information Orbis ID number
DUO_LEI=Domestic ultimate owner information Legal Entity Identifier (LEI)
DUO_TICKER=Domestic ultimate owner information Ticker symbol
DUO_COUNTRY_ISO_CODE=Domestic ultimate owner information Country ISO code
DUO_TERRITORY_ISO_CODE=Territory ISO code
DUO_STATE_PROVINCE=Domestic ultimate owner information State or province (in US or Canada)
DUO_CITY=Domestic ultimate owner information City
DUO_ENTITY_TYPE=Domestic ultimate owner information Type
DUO_NACE_CORE_CODE=Domestic ultimate owner information NACE,Core code
DUO_NACE_CORE_LABEL=Domestic ultimate owner information NACE,text description
DUO_NAICS_CORE_CODE=Domestic ultimate owner information NAICS, Core code
DUO_NAICS_CORE_LABEL=Domestic ultimate owner information NAICS, text description
DUO_USSIC_CORE_CODE=Domestic ultimate owner information US SIC, Core code
DUO_USSIC_CORE_LABEL=Domestic ultimate owner information US SIC, text description
DUO_DIRECT_PCT=Domestic ultimate owner information Direct %
DUO_TOTAL_PCT=Domestic ultimate owner information Total %
DUO_INFORMATION_SOURCE=Domestic ultimate owner information Information source
DUO_INFORMATION_DATE=Domestic ultimate owner information Information date
DUO_OPRE=Domestic ultimate owner information Operating revenue (Turnover)
DUO_TOAS=Domestic ultimate owner information Total assets
DUO_EMPL=Domestic ultimate owner information Number of employees
DUO_CURRENT_PREVIOUS_MANAGER=Domestic ultimate owner information Also a manager
DUO_NATIONAL_ID=National number
DUO_SWIFT_CODE=SWIFT code
DUO_AKA_NAME=Also known as name
DUO_PREVIOUS_NAME=Previously known as name
DUO_ADDRESS_LINE1=Street, no., building etc, line 1
DUO_ADDRESS_LINE2=Street, no., building etc, line 2
DUO_ADDRESS_LINE3=Street, no., building etc, line 3
DUO_ADDRESS_LINE4=Street, no., building etc, line 4
DUO_POSTCODE=Postal code
DUO_PHONE_NUMBER=Telephone number
DUO_FAX_NUMBER=Fax number
DUO_WEBSITE=Website address
DUO_PLBT=Domestic ultimate owner information P/L before tax
DUO_PL=Domestic ultimate owner information P/L for period [=Net income]
DUO_SHFD=Domestic ultimate owner information Shareholders funds
CSH_NAME=Controlling shareholders Name
CSH_BVD_ID_NUMBER=Controlling shareholders BvD ID number
CSH_ORBISID=Controlling shareholders Orbis ID number
CSH_LEI=Controlling shareholders Legal Entity Identifier (LEI)
CSH_TICKER=Controlling shareholders Ticker symbol
CSH_COUNTRY_ISO_CODE=Controlling shareholders Country ISO code
CSH_TERRITORY_ISO_CODE=Territory ISO code
CSH_STATE_PROVINCE=Controlling shareholders State or province (in US or Canada)
CSH_CITY=Controlling shareholders City
CSH_ENTITY_TYPE=Controlling shareholders Type
CSH_NACE_CORE_CODE=Controlling shareholders NACE,Core code
CSH_NACE_CORE_LABEL=Controlling shareholders NACE,text description
CSH_NAICS_CORE_CODE=Controlling shareholders NAICS, Core code
CSH_NAICS_CORE_LABEL=Controlling shareholders NAICS, text description
CSH_USSIC_CORE_CODE=Controlling shareholders US SIC, Core code
CSH_USSIC_CORE_LABEL=Controlling shareholders US SIC, text description
CSH_DIRECT_PCT=Controlling shareholders Direct %
CSH_TOTAL_PCT=Controlling shareholders Total %
CSH_POSSIBLE_PCT_CHANGE_DESCRIPTION=Controlling shareholders Information on possible change in %
CSH_LEVEL=Controlling shareholders Level
CSH_INFORMATION_SOURCE=Controlling shareholders Information source
CSH_INFORMATION_DATE=Controlling shareholders Information date
CSH_SALUTATION=Controlling shareholders Salutation
CSH_FIRST_NAME=Controlling shareholders First name
CSH_LAST_NAME=Controlling shareholders Last name
CSH_UCI=Controlling shareholders UCI
CSH_OPRE=Controlling shareholders Operating revenue (Turnover)
CSH_TOAS=Controlling shareholders Total assets
CSH_EMPL=Controlling shareholders Number of employees
CSH_CURRENT_PREVIOUS_MANAGER=Controlling shareholders Also a manager
CSH_NATIONAL_ID=National number
CSH_SWIFT_CODE=SWIFT code
CSH_AKA_NAME=Also known as name
CSH_PREVIOUS_NAME=Previously known as name
CSH_ADDRESS_LINE1=Street, no., building etc, line 1
CSH_ADDRESS_LINE2=Street, no., building etc, line 2
CSH_ADDRESS_LINE3=Street, no., building etc, line 3
CSH_ADDRESS_LINE4=Street, no., building etc, line 4
CSH_POSTCODE=Postal code
CSH_PHONE_NUMBER=Telephone number
CSH_FAX_NUMBER=Fax number
CSH_WEBSITE=Website address
CSH_PLBT=Controlling shareholders P/L before tax
CSH_PL=Controlling shareholders P/L for period [=Net income]
CSH_SHFD=Controlling shareholders Shareholders funds
SUB_COMMENTS=Subsidiary Comments (text)
SUB_COUNT=No of subsidiaries
ULTIMATELY_OWNED_SUB_INCLUDED_COUNT=No of subsidiaries (ultimately-owned included)
SUB_NAME=Subsidiary Name
SUB_BVD_ID_NUMBER=Subsidiary BvD ID number
SUB_ORBISID=Subsidiary Orbis ID number
SUB_LEI=Subsidiary Legal Entity Identifier (LEI)
SUB_TICKER=Subsidiary Ticker symbol
SUB_COUNTRY_ISO_CODE=Subsidiary Country ISO code
SUB_TERRITORY_ISO_CODE=Territory ISO code
SUB_STATE_PROVINCE=Subsidiary State or province (in US or Canada)
SUB_CITY=Subsidiary City
SUB_ENTITY_TYPE=Subsidiary Type
SUB_NACE_CORE_CODE=Subsidiary NACE,Core code
SUB_NACE_CORE_LABEL=Subsidiary NACE,text description
SUB_NAICS_CORE_CODE=Subsidiary NAICS, Core code
SUB_NAICS_CORE_LABEL=Subsidiary NAICS, text description
SUB_USSIC_CORE_CODE=Subsidiary US SIC, Core code
SUB_USSIC_CORE_LABEL=Subsidiary US SIC, text description
SUB_LEVEL=Subsidiary Level
SUB_DIRECT_PCT=Subsidiary Direct %
SUB_TOTAL_PCT=Subsidiary Total %
SUB_POSSIBLE_PCT_CHANGE_DESCRIPTION=Subsidiary Information on possible change in %
SUB_LINK_TYPE=Subsidiary Status
SUB_INFORMATION_SOURCE=Subsidiary Information Source
SUB_INFORMATION_DATE=Subsidiary Information date
SUB_OPRE=Subsidiary Operating revenue (Turnover)
SUB_TOAS=Subsidiary Total assets
SUB_EMPL=Subsidiary Number of employees
SUB_LIABILITY_INDICATOR=Subsidiary Company for which liability is held
SUB_BENEFICIALLY_HELD_INDICATOR=Beneficially held
SUB_NATIONAL_ID=National number
SUB_SWIFT_CODE=SWIFT code
SUB_AKA_NAME=Also known as name
SUB_PREVIOUS_NAME=Subsidiary Previously known as name
SUB_ADDRESS_LINE1=Street, no., building etc, line 1
SUB_ADDRESS_LINE2=Street, no., building etc, line 2
SUB_ADDRESS_LINE3=Street, no., building etc, line 3
SUB_ADDRESS_LINE4=Street, no., building etc, line 4
SUB_POSTCODE=Postal code
SUB_PHONE_NUMBER=Telephone number
SUB_FAX_NUMBER=Fax number
SUB_WEBSITE=Website address
SUB_PLBT=Subsidiary P/L before tax
SUB_PL=Subsidiary P/L for period [=Net income]
SUB_SHFD=Subsidiary Shareholders funds
CURRENT_PORTFOLIO_NAME=Current portfolio Name
CURRENT_PORTFOLIO_BVD_ID_NUMBER=Current portfolio BvD ID number
CURRENT_PORTFOLIO_COUNTRY_ISO_CODE=Current portfolio Country ISO code
CURRENT_PORTFOLIO_STATE_PROVINCE=Current portfolio State or province (in US or Canada)
CURRENT_PORTFOLIO_CITY=Current portfolio City
CURRENT_PORTFOLIO_ENTITY_TYPE=Current portfolio Type
CURRENT_PORTFOLIO_NACE_CORE_CODE=Current portfolio NACE,Core code
CURRENT_PORTFOLIO_NACE_CORE_LABEL=Current portfolio NACE,text description
CURRENT_PORTFOLIO_NAICS_CORE_CODE=Current portfolio NAICS, Core code
CURRENT_PORTFOLIO_NAICS_CORE_LABEL=Current portfolio NAICS, text description
CURRENT_PORTFOLIO_USSIC_CORE_CODE=Current portfolio US SIC, Core code
CURRENT_PORTFOLIO_USSIC_CORE_LABEL=Current portfolio US SIC, text description
CURRENT_PORTFOLIO_ENTRY_DATE=Current portfolio Entry date
CONTROLLING_PORTFOLIO_COMPANY_NAME=Controlling portfolio company Name
CONTROLLING_PORTFOLIO_COMPANY_BVD_ID_NUMBER=Controlling portfolio company BvD ID number
CONTROLLING_PORTFOLIO_COMPANY_COUNTRY_ISO_CODE=Controlling portfolio company Country ISO code
CONTROLLING_PORTFOLIO_COMPANY_STATE_PROVINCE=Controlling portfolio company State or province (in US or Canada)
CONTROLLING_PORTFOLIO_COMPANY_NACE_CORE_CODE=Controlling portfolio company NACE,Core code
CONTROLLING_PORTFOLIO_COMPANY_NACE_CORE_LABEL=Controlling portfolio company NACE,text description
CONTROLLING_PORTFOLIO_COMPANY_NAICS_CORE_CODE=Controlling portfolio company NAICS, Core code
CONTROLLING_PORTFOLIO_COMPANY_NAICS_CORE_LABEL=Controlling portfolio company Société holding - NAICS, text description
CONTROLLING_PORTFOLIO_COMPANY_USSIC_CORE_CODE=Controlling portfolio company US SIC, Core code
CONTROLLING_PORTFOLIO_COMPANY_USSIC_CORE_LABEL=Controlling portfolio company US SIC, text description
PE_FIRM_NAME=PE firms Name
PE_FIRM_BVD_ID_NUMBER=PE firms BvD ID number
PE_FIRM_COUNTRY_ISO_CODE=PE firms Country ISO code
BRANCH_COUNT=No of branches
BRANCH_NAME=Branches Branch - Name
BRANCH_BVD_ID_NUMBER=Branches Branch - BvD ID number
BRANCH_ORBISID=Branches Branch - Orbis ID number
BRANCH_COUNTRY_ISO_CODE=Branches Branch - Country ISO code
BRANCH_TERRITORY_ISO_CODE=Territory ISO code
BRANCH_STATE_PROVINCE=Branches Branch - State or province (in US or Canada)
BRANCH_CITY=Branches Branch - City
BRANCH_NACE_CORE_CODE=Branches Branch - NACE,Core code
BRANCH_NACE_CORE_LABEL=Branches Branch - NACE,text description
BRANCH_NAICS_CORE_CODE=Branches Branch - NAICS, Core code
BRANCH_NAICS_CORE_LABEL=Branches Branch - NAICS, text description
BRANCH_USSIC_CORE_CODE=Branches Branch - US SIC, Core code
BRANCH_USSIC_CORE_LABEL=Branches Branch - US SIC, text description
BRANCH_OPRE=Branches Branch - Operating revenue (Turnover)
BRANCH_TOAS=Branches Branch - Total assets
BRANCH_EMPL=Branches Branch - Number employees
BRANCH_NATIONAL_ID=National number
BRANCH_SWIFT_CODE=SWIFT code
BRANCH_AKA_NAME=Also known as name
BRANCH_PREVIOUS_NAME=Branches Branch - Previously known as name
BRANCH_ADDRESS_LINE1=Street, no., building etc, line 1
BRANCH_ADDRESS_LINE2=Street, no., building etc, line 2
BRANCH_ADDRESS_LINE3=Street, no., building etc, line 3
BRANCH_ADDRESS_LINE4=Street, no., building etc, line 4
BRANCH_POSTCODE=Postal code
BRANCH_PHONE_NUMBER=Telephone number
BRANCH_FAX_NUMBER=Fax number
BRANCH_WEBSITE=Website address
BRANCH_PLBT=Branches Branch - P/L before tax
BRANCH_PL=Branches Branch - P/L for period [=Net income]
BRANCH_SHFD=Branches Branch - Shareholders funds
HQ_NAME=Headquarters Name
HQ_BVD_ID_NUMBER=Headquarters BvD ID number
HQ_ORBISID=Headquarters Orbis ID number
HQ_LEI=Headquarters Shareholder - Legal Entity Identifier (LEI)
HQ_TICKER=Headquarters Ticker Symbol
HQ_COUNTRY_ISO_CODE=Headquarters Country ISO code
HQ_STATE_PROVINCE=Headquarters State or province (in US or Canada)
HQ_CITY=Headquarters City
HQ_ENTITY_TYPE=Headquarters Type
HQ_NACE_CORE_CODE=Headquarters NACE,Core code
HQ_NACE_CORE_LABEL=Headquarters NACE,text description
HQ_NAICS_CORE_CODE=Headquarters NAICS, Core code
HQ_NAICS_CORE_LABEL=Headquarters NAICS, text description
HQ_USSIC_CORE_CODE=Headquarters US SIC, Core code
HQ_USSIC_CORE_LABEL=Headquarters US SIC, text description
HQ_INFORMATION_SOURCE=Headquarters Information source
HQ_INFORMATION_DATE=Headquarters Information date
HQ_CURRENT_INDICATOR=Headquarters Current/Archived
HQ_OPRE=Headquarters Operating revenue (Turnover)
HQ_TOAS=Headquarters Total assets
HQ_EMPL=Headquarters Number of employees
HQ_NATIONAL_ID=National number
HQ_SWIFT_CODE=SWIFT code
HQ_AKA_NAME=Also known as name
HQ_PREVIOUS_NAME=Previously known as name
HQ_ADDRESS_LINE1=Street, no., building etc, line 1
HQ_ADDRESS_LINE2=Street, no., building etc, line 2
HQ_ADDRESS_LINE3=Street, no., building etc, line 3
HQ_ADDRESS_LINE4=Street, no., building etc, line 4
HQ_POSTCODE=Postal code
HQ_PHONE_NUMBER=Telephone number
HQ_FAX_NUMBER=Fax number
HQ_WEBSITE=Website address
HQ_PLBT=Headquarters HEADQUARTERS - P/L before tax
HQ_PL=Headquarters HEADQUARTERS - P/L for period [=Net income]
HQ_SHFD=Headquarters HEADQUARTERS - Shareholders funds
HQ_FALCON_YEAR=Date of FALCON scores
HQ_WVB_YEAR=Date of FALCON scores
UPDATE_NUMBER=Update number
NEW_COMPANY_DATE=Addition of company in database
NAME_UPDATE=Last update - Company name
ADDRESS_UPDATE=Last update - Address
PHONE_NUMBER_UPDATE=Last update - Telephone number
DOMAIN_UPDATE=Last update - Domain update
WEBSITE_UPDATE=Last update - Website address
EMAIL_UPDATE=Last update - E-mail address
IDENTIFIERS_UPDATE=Last update - Identification numbers
STATUS_UPDATE=Last update - Status (any change)
NATIONAL_LEGAL_FORM_UPDATE=Last update - National legal form
COMPANY_CATEGORY_UPDATE=Last update - Size classification
INDUSTRY_UPDATE=Last update - Industry classifications
NEW_ANNUAL_ACCOUNTS_DATE=Addition of last annual accounts
NEW_INTERIM_ACCOUNTS_DATE=Addition of last interim accounts
ANNUAL_ACCOUNTS_UPDATE=Last update - Annual accounts
INTERIM_ACCOUNTS_UPDATE=Last update - Interim accounts
BVD_INDEPENDENCE_INDICATOR_UPDATE=Last update - BvD Independence Indicator