WORLD (World)

From CDQ Wiki
< Business Partner (CDQ) | Address (CDQ) | Country (CDQ)
DataModel:CDQ/Business Partner/Address/Country/WORLD
Jump to navigation Jump to search
Property Value
A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code WORLD
Language-specific name. Monolingual name World (en)
The offical langauge of a country. Official language en
Language used in a country, beside the administrative languages. other language en

Regions

No regions maintained for World.

Legal forms

No legal forms maintained for World.

Identifiers

IdentifierNameRegistration authority
ANID (ANID)Ariba Network ID (en)
AR_IATAIN (AR - Int. Air Trans. Assoc. ID)Travel Industry Designator Service (en)
BIC (Business Identifier Code)Business Identifier Code (en)
BVD_ID (Bureau van Dijk Identifier)Bureau van Dijk Identifier (en)
CDQ_GR (CDQ GR)CDQ Golden Record Identifier (en)
CDQ_ID (CDQ ID)CDQ ID (en)
CDQ_POOL_ID (CDQ Pool ID)CDQ Pool ID (en)
CREFO_ID (CREFO)CREFO number (en)
CREFO_IDENT (CREFO Ident)CREFO Ident number (en)
CRIF_ID (CRIF)CRIF number (en)
CX_BPN (Business Partner Number)Geschäftspartnernummer (de)
Business Partner Number (en)
CX_POOL_ID (Catena-X Pool ID)Catena-X Pool ID (en)
DUNS_ID (DUNS Number)DUNS Number (en)
DUNS_ID_CU (Commercial ultimate DUNS)Commercial ultimate DUNS (en)
DUNS_ID_DU (Domestic ultimate DUNS)Domestic ultimate DUNS (en)
DUNS_ID_GU (Global ultimate DUNS)Global ultimate DUNS (en)
EORI (Econ. Operators Reg. & ID Num.)Economic Operators Registration and Identification number (en)
EU_CUST_REF (EU - Cust Off)EU Customs Office Reference Number (en)
EU_ID (EUID)European Unique Identifier (en)
EU_VAT_ID (VAT identification number)Value added tax identification number (en)
GOOGLE_PLACE_ID (Place ID)Google Place ID (en)
GOOGLE_PLUS_CODE (Plus Code)Google Plus Code (en)
GS1_GLN (Global location number)Global location number (en)
ISIN (International Securities ID Number)International Securities Identification Number (en)
LEI_ID (Legal Entity Identifier)Legal Entity Identifier (en)
OPENCORP_ID (OpenCorporates ID)OpenCorporates ID (en)
ORBIS_ID (Orbis ID)Orbis ID (en)
PAN (Primary Account Number)Primary Account Number (en)
PEPPOL_ID (Peppol ID)Peppol ID (en)
PIC_ID (Participant Identification Code)Participant Identification Code (en)
QCC_CODE (QCC Code)Qichacha Company Code (en)
RIAD (RIAD Code)Register of Institutions and Affiliates Data Code (en)
SCI_ID (SEPA Creditor Identifier)SEPA Creditor Identifier (en)
SPCOMP_ID (S&P Global Company ID)S&P Global Company ID (en)
SPOR_LOC_ID (SPOR OMS Location ID)SPOR OMS Location ID (en)
SPOR_ORG_ID (SPOR OMS Organisation ID)SPOR OMS Organisation ID (en)
UNKNOWN_ID (Unknown)Unknown ID (en)
WR_CAGE (CAGE Code)Commercial And Government Entity Code (en)
WR_CINS (CINS Number)CINS Number (en)

Data quality rules

Data quality ruleDescriptionCriticality
Business partner name missingIt is necessary that each business partner has at least one name. With respect to the CDL data model it is at least required that a name of type LOCAL or INTERNATIONAL is present.ERROR
Business partner name missing (Name LOCAL)It is necessary that each business partner has at least one name. With respect to the CDQ data model it is at least required that a name of type LOCAL or INTERNATIONAL is present.ERROR
Care of information misplacedCare of (typicall indicated by "c/o") information must not be maintained in the business partner's name, locality or thoroughfare but is to be managed as care of attribute. If there is care of information found as an attribute value other than "care of" the rule is violated.ERROR
Care of information misplaced (Locality CITY)Care of (typicall indicated by "c/o") information must not be maintained in the business partner's name, locality or thoroughfare but is to be managed as care of attribute. If there is care of information found as an attribute value other than "care of" the rule is violated.ERROR
Care of information misplaced (Name INTERNATIONAL)Care of (typicall indicated by "c/o") information must not be maintained in the business partner's name, locality or thoroughfare but is to be managed as care of attribute. If there is care of information found as an attribute value other than "care of" the rule is violated.ERROR
Care of information misplaced (business partner name)Care of (typicall indicated by "c/o") information must not be maintained in the business partner's name, locality or thoroughfare but is to be managed as care of attribute. If there is care of information found as an attribute value other than "care of" the rule is violated.ERROR
Contact information misplacedContact information is not allowed in the registered name, trade name or international name. This rule checks whether contact information is misplaced by identifying e.g. common keywords such as "attn:" or "z.Hd." and additionally parsing the company name for natural person names that are not meant to be part of the legal name (e.g. when natural person names are placed after the legal form)INFO
Contact information misplaced (Name LOCAL)Contact information is not allowed in the registered name, trade name or international name. This rule checks whether contact information is misplaced by identifying e.g. common keywords such as "attn:" or "z.Hd." and additionally parsing the company name for natural person names that are not meant to be part of the legal name (e.g. when natural person names are placed after the legal form)INFO
Country shortname format invalidThe country shortname format consists of exactly two charts.ERROR
Country shortname missingThe country shortname is mandatory.ERROR
Country shortname unknownCountry shortname should exist in the CDL reference data.ERROR
Country value missingA missing country value is identified as data defect.INFO
Country value unknownCountry should exist in the cdl reference data (Category:Country).INFO
Dummy post code detectedThis rule checks the post code format against defined dummy post code format patterns (see Regular expression library). If the post code format matched the defined pattern, then the rule is violated.

Postal code patterns example:

  • -
    .
    ......


  • 0


2
3

  • 123456
  • 1111
    999999
  • 874358743787439
  • S
    SO
    T
    XX
    xxx
    XXXX
  • n.a
    N.A
    N.T
    n/a
    N/A
    na
    NA
    NP
    none
    NONE
    NULL
    NO POSTCODE
    NOT APPLICABLE
    Not Available
    nicht vorhanden
  • 00 00
    000-000
    00000-0000
    999-9999
ERROR
IBAN checksum invalidChecks the integrity of a given IBAN by validating the checkdigit using the ISO-7604 MOD97-10 algorithm.ERROR
IBAN format invalidChecks the format of a given IBAN with respect to any possible combination of alphanumeric digits across all countries worldwide. This rule is not that precise and may allow formats that are valid in one country but not for the concrete bank country where the IBAN is issued. However, if this rule fails the IBAN is definitely wrong.ERROR
Identifier Qualification (EORI number (European Union), Data source:EU.EORI)This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the EORI numberINFO
Identifier checkdigit invalid (Global location number)This rule checks the checkdigit of Global location number.ERROR
Identifier format deprecated (Legal Entity Identifier (World))The technical specification for LEI is ISO 17442:2012 (deprecated) The new LEI specification was released in ISO 17442:2019. An LEI consists of a 20-character alphanumeric string, with the first 4 characters identifying the Local Operating Unit (LOU) that issued the LEI. Characters 5 and 6 are reserved as '00'. Characters 7-18 are the unique alphanumeric string assigned to the organisation by the LOU. The final 2 characters are checksum digits.INFO
Identifier format invalid (D-U-N-S)The D-U-N-S consists of exact 9 numerical digits. This rule checks the existence of exact 9 digits without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits or non-numeric digits the rule is violated.ERROR
Identifier format invalid (EORI number)This rule checks presence of one of the following patterns corresponding to the format of the EORI number:

1) European Union countries:

  • the country code of the issuing Member State (2 uppercase letters) followed by a code or number that is unique in the Member State (15 alphanumeric characters), e.g. DE615405745138871, PL1234567890ABCDE

2) TIR Carnet holders:

  • the country code of the issuing Member State (2 uppercase letters) followed by 'T' letter and followed by the code of the national association through which the holder of the TIR Carnet has been authorized (3 digits) and unique TIR Carnet holder identification number (10 digits), e.g. CZT0530123456789

3) United Kingdom:

  • start with ‘GB’ followed by 12 or 15 digits, e.g. GB123456789133
ERROR
Identifier format invalid (Global location number)This rule checks the format of the Global location number (GLN). The GLN is a 13 digit globally unique identifier for any location, physical, operational, or legal.ERROR
Identifier format invalid (Legal Entity Identifier (World))The technical specification for LEI is ISO 17442. An LEI consists of a 20-character alphanumeric string, with the first 4 characters identifying the Local Operating Unit (LOU) that issued the LEI. Characters 5 and 6 are reserved as '00'. Characters 7-18 are the unique alphanumeric string assigned to the organisation by the LOU. The final 2 characters are checksum digits.ERROR
Identifier missing (D-U-N-S (World))Business partners may have a D-U-N-S number maintained. The rule identifies partners without a D-U-N-S.INFO
Identifier unknown (Legal Entity Identifier)This business rule checks the validity of the LEI number against the Global Legal Entity Identifier Foundation Database. The LEI number will be judged valid by this rule if it is available in the Global Legal Entity Identifier Foundation.ERROR
Inconsistency between Post code and Locality in CountryThe rule checks if given postal code, city and country occur together in the reference data source. We are checking against Geonames database.INFO
Invalid country nameThis rule checks whether the given country name is a known country name according to CDQ metadata, see country list). If the name is not in this list the rule is violated.WARNING
Invalid legal formEach country has different legal forms that an organization can possess. This rule ensures that an organization can never possess a legal form that is not a valid legal form in the country of the organization's legal address.INFO
Legal form missingIn general, each business partner must have exactly one legal form. For example, a business partner can never be an Aktiengesellschaft and a Gesellschaft mit beschraenkter Haftung at the same time. However, business partners that are marked by a no legal form required category are valid also without a legal form value.INFO
Locality Qualification (EORI number, Data source:EU.EORI)This data quality rule checks the congruency of the given city against the city maintained as reference for the EORI numberINFO
Name Qualification (EORI number, Data source:EU.EORI)This data quality rule checks the congruency of the given name against the name maintained as reference for the EORI numberINFO
Natural person identifiedIn the CDQ community pool no natural persons are managed. This rule checks whether a record represents a natural person. In course of the CDQ collaboration process these records would be preventively deleted.INFO
PO Box information misplaced (Locality CITY)Post office box information must not be maintained in the locality attributes.ERROR
PO Box information misplaced (Name LOCAL)Post office box information must not be maintained in the name attributes.ERROR
PO Box information misplaced (Post code REGULAR)Post office box information must not be maintained in the post code attributes.ERROR
PO Box information misplaced (Thoroughfare STREET)Post office box information must not be maintained in the thoroughfare attributes.INFO
PO Box information misplaced in locality informationPost office box information must not be maintained in the locality attributes.ERROR
PO Box information misplaced in name informationPost office box information must not be maintained in the name attributes.ERROR
PO Box information misplaced in post code informationPost office box information must not be maintained in the post code attributes.ERROR
PO Box information misplaced in street informationPost office box information must not be maintained in the thoroughfare attributes.ERROR
Post code Qualification (EORI number, Data source:EU.EORI)This data quality rule checks the congruency of the given post code against the post code maintained as reference for the EORI numberINFO
Post office box information misplacedPost office box information must not be maintained in the post code or thoroughfare attributes.ERROR
Telephone number misplacedTelephone number should not be placed in the name fields.ERROR
Thoroughfare Qualification (EORI number, Data source:EU.EORI)This data quality rule checks the congruency of the given street against the street maintained as reference for the EORI numberINFO
Unallowed name valuesThe rule searches for patterns of unallowed values in the name such as links to duplicate or new records in order to identify data records that are not really representing company records. Precisely, the following patterns are checked:
  • Record is a known duplicate and this information is included in the name (e.g. "use creditor 1234")
  • Deletion information in the name (e.g. "DEL-" as prefix, or DELETE)
  • Non-company names (e.g. "ACCRUAL 2017")
    		• ERROR
    Unallowed pattern detected (name local)The rule searches for patterns of unallowed values in the name such as links to duplicate or new records in order to identify data records that are not really representing company records. All patterns are documented in the regular expression library. See below the applied patterns:INFO

    Data sources

    Data source An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates Release status
    [[BVD (data source)]]
    Orbis database (Bureau van Dijk)
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Orbis database offers information on companies and financial institutions for academic research and learning resources worldwide. LIVE
    [[CDQ.AA (data source)]]
    CDQ Administrative Areas
    [[ADDRESS]]A fatal error occurred in the #info parser function     		First and second level administrative areas (regions, counties), managed by CDQ, according to ISO standards. LIVE
    [[CDQ.BANKPOOL (data source)]]
    CDQ Banking Data
    [[BANK_ACCOUNT]]A fatal error occurred in the #info parser function     		Bank account data and anonymized transaction data to derive trustworthiness of bank accounts from. LIVE
    [[CDQ.CRS (data source)]]
    CDQ Company Registers
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Company registers per country, with mappings to CDQ Data Model, managed by CDQ. LIVE
    [[CDQ.CTRY (data source)]]
    CDQ Countries
    [[ADDRESS]]A fatal error occurred in the #info parser function     		Country information managed by CDQ, according to ISO standards. LIVE
    [[CDQ.IDS (data source)]]
    CDQ Identifiers
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		A list of identifiers for companies and other business partners, on a global scale, managed by CDQ. LIVE
    [[CDQ.LF (data source)]]
    CDQ Legal Forms
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Legal forms for business partner names, with their abbreviations and country-relations, managed by CDQ. LIVE
    [[CDQ.POOL (data source)]]
    CDQ Community Data
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Business partner data collaboratively managed by the CDQ Data Sharing Community. LIVE
    [[CX.POOL (data source)]]
    CX POOL
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Catena-X Pool LIVE
    [[DNB (data source)]]
    D&B Data
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Data pool from Dun & Bradstreet. LIVE
    4 records
    [[DNB.LINKAGE.LNKELI (data source)]]
    D&B Extended Linkages
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Extended Linkages from Dun & Bradstreet. LIVE
    [[DNB.MASTER.DATA.BASIC (data source)]]
    D&B MDM Basic
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Data blocks from Dun & Bradstreet. LIVE
    [[DNB.MASTER.DATA.EXTENDED (data source)]]
    D&B MDM Extended
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Data blocks from Dun & Bradstreet. LIVE
    [[GEON (data source)]]
    GeoNames
    [[ADDRESS]]A fatal error occurred in the #info parser function     		GeoNames.org is compiling a worldwide database of public domain geographical data from various sources. GeoNames is a user-editable database. LIVE
    [[GMAPS (data source)]]
    Google Maps
    [[ADDRESS]]A fatal error occurred in the #info parser function     		Google Maps is a web mapping service developed by Google, see Wikipedia for further details. LIVE
    [[GOOGLEPLACES (data source)]]
    Google Places
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Google Places is Google's listing for local business search results LIVE
    1,469 records
    [[GTRANSLATE (data source)]]
    GTRANSLATE
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Google Translate LIVE
    [[HERE (data source)]]
    Here.com
    [[ADDRESS]]A fatal error occurred in the #info parser function     		Here is a company that provides mapping and location data and related services to individuals and companies. LIVE
    6 records
    [[LEI (data source)]]
    Legal Entity Identifier Records
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Legal Entity Identifiers (LEIs) and related LEI reference data published by the Global Legal Entity Identifier Foundation (GLEIF). LIVE
    3,086,648 records
    [[OSM (data source)]]
    OpenStreetMap
    [[ADDRESS]]A fatal error occurred in the #info parser function     		free editable map of the world with many location data such as city names, street names, postal codes, etc. LIVE
    [[PEPPOL (data source)]]
    Peppol
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Data pool from OpenPeppol LIVE
    2,520,123 records
    [[SAP (data source)]]
    SAP
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		SAP outbound mapping fields LIVE
    [[SPOR.OMS (data source)]]
    SPOR OMS
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Data source that offers business partner and location information about healthcare organisations and manufacturers LIVE
    172,774 records
    [[WIKIDATA (data source)]]
    Wikidata
    [[ADDRESS]]A fatal error occurred in the #info parser function     		Free and open knowledge base, also with location names and translations. LIVE
    [[CDQ.GLNCONNECT (data source)]]
    CDQ GLN Connect
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		CDQ GLN Connect BETA
    12 records
    [[CDQ.INTEL (data source)]]
    CDQ Intelligence
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		CDQ Intelligence BETA
    53,424,978 records
    [[CDQ.TEST (data source)]]
    CDQ Test Data Source
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		A test data source for demo accounts. BETA
    559 records
    [[DNB.MASTER.DATA.LNKG (data source)]]
    D&B MDM Lnkg
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Data blocks from Dun & Bradstreet. BETA
    [[DNB.MASTER.DATA.MGMT (data source)]]
    D&B MDM Mgmt
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Data blocks from Dun & Bradstreet. BETA
    [[GEONAMES (data source)]]
    GeoNames
    [[ADDRESS]]A fatal error occurred in the #info parser function     		GeoNames is integrating geographical data such as names of places in various languages, elevation, population and others from various sources. BETA
    [[SAP.ODM (data source)]]
    SAP ODM
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		Coherent domain model for all SAP cloud applications. BETA
    [[AIRP (data source)]]
    Airport database (World)     		n/a IDEA
    28,828 records
    [[DNB.UPIK (data source)]]
    D&B UPIK
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		UPIK® (“Unique Partner Identification Key”) is an online platform relating to use of the D&B D-U-N-S Number. IDEA
    0 records
    [[ISO.3166 (data source)]]
    ISO 3166     		n/a IDEA
    [[OUR.AIRPORTS (data source)]]
    OurAirports (World)
    [[ADDRESS]]A fatal error occurred in the #info parser function     		n/a IDEA
    [[REX (data source)]]
    REX
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function     		The Registered Exporter system (the REX system) is a system of certification of origin of goods based on a principle of self-certification. IDEA
    [[SEAP (data source)]]
    Sea ports database (World)
    [[ADDRESS]]A fatal error occurred in the #info parser function     		n/a IDEA
    [[ACCUITY (data source)]]
    Bankers Almanac for Payments
    [[BANK_ACCOUNT]]A fatal error occurred in the #info parser function     		Up to date bank reference data (addresses, codes and names). EOL
    [[SGW (data source)]]
    SupplierGATEWAY
    [[BUSINESS_PARTNER]], [[CERTIFICATE]]A fatal error occurred in the #info parser function     		SupplierGATEWAY offers supplier diversity & CSR solutions and thereby provides data about supplier certificates and diversity information EOL

    Banking metadata

    Property Value
    Full metadata DataModel:CDQ/Business_Partner/Bank_Account_Model/WORLD
    Retrieved from "https://meta.cdq.com/w/index.php?title=DataModel:CDQ/Business_Partner/Address/Country/WORLD&oldid=181557"