Identifier missing (rule category)
From CDQ Wiki
Public:Rule category/Identifier missing
| Property | Value |
|---|---|
| The human-friendly name shown for this concept in the user interface, used instead of the technical name to improve readability and understanding. Display name | Identifier missing |
| Informal and comprehensive human-readable definition of a concept. Description | Checks whether an identifier is missing even though mandatory (ERROR) or nice to have (INFO) |
| Dimensional categorization of a concept, e.g., a data quality dimension of a data quality rule. Dimension | Completeness |
| Hierachical parent concept of a concept. Parent | Mandatory concept (rule category) |
Data quality rules
| Rule | Country | Description | Criticality |
|---|---|---|---|
| Identifier missing (BTW number (Belgium)) | BE (Belgium) | Each legal entity in Belgium should have a BTW number. | WARNING |
| Identifier missing (Branch Unit Number (Belgium)) | BE (Belgium) | Each legal entity in Belgium should have a Branch Unit Number. | WARNING |
| Identifier missing (Business Number (Australia)) | AU (Australia) | Each legal entity in Australia should have a Business Number. | WARNING |
| Identifier missing (Business Registration Number (Algeria)) | DZ (Algeria) | Each legal entity in Algeria should have a business registration number | INFO |
| Identifier missing (Business Registration Number (China)) | CN (China) | Each business partner in China requires a business registration number. | ERROR |
| Identifier missing (Business Registration Number (Egypt)) | EG (Egypt) | Each legal entity in Egypt should have a Business Registration Number. | ERROR |
| Identifier missing (Business Registration Number (Estonia)) | EE (Estonia) | Each business partner in Estonia has a Business Registration Number | INFO |
| Identifier missing (Business Registration Number (Germany)) | DE (Germany) | Business partners in Germany should have a business registration number maintained. | INFO |
| Identifier missing (Business Registration Number (Lithuania)) | LT (Lithuania) | Business partners in Lithuania should have a business registration number maintained. | WARNING |
| Identifier missing (Business Registration Number (Malaysia)) | MY (Malaysia) | Each business partner in Malaysia requires a Business Registration Number. | ERROR |
| Identifier missing (Business Registration Number (New Zealand)) | NZ (New Zealand) | Each legal entity in New Zealand should have a New Zealand Business Number. | WARNING |
| Identifier missing (Business Registration Number (Nigeria)) | NG (Nigeria) | Each legal entity in Guatemala should have a business registration number | INFO |
| Identifier missing (Business Registration Number (Turkey)) | TR (Turkey) | Each legal entity in Turkey should have a Business Registration Number. | ERROR |
| Identifier missing (Business identity code (Finland)) | FI (Finland) | Each legal entity in Finland should have a business identity code. | INFO |
| Identifier missing (Business number (Canada)) | CA (Canada) | Each legal entity in Canada requires a business number. | WARNING |
| Identifier missing (CNPJ number (Brazil)) | BR (Brazil) | Each legal entity in Brazil should have a CNPJ number. | ERROR |
| Identifier missing (CPR number (Greenland)) | GL (Greenland) | Each individual in Greenland must have a CPR number. | INFO |
| Identifier missing (CUIT number (Argentina)) | AR (Argentina) | Each legal entity in Argentina should have a CUIT number (Argentina). | ERROR |
| Identifier missing (CVR number (Denmark)) | DK (Denmark) | Each business partner in Denmark requires a CVR number. | INFO |
| Identifier missing (Chamber of Commerce Number (Egypt)) | EG (Egypt) | Each legal entity in Egypt should have a Chamber of Commerce Number. | ERROR |
| Identifier missing (Chamber of Commerce Number (Morocco)) | MA (Morocco) | Each legal entity in Morocco should have a Chamber of Commerce Number. | ERROR |
| Identifier missing (Chamber of Commerce Number (Turkey)) | TR (Turkey) | Each legal entity in Turkey should have a Chamber of Commerce Number. | ERROR |
| Identifier missing (Common business identifier (Morocco)) | MA (Morocco) | Each legal entity in Morocco should have a Common business identifier. | ERROR |
| Identifier missing (Company identification number (Switzerland)) | CH (Switzerland) | In Switzerland, a business partner must have a national identifier. | ERROR |
| Identifier missing (Company registration number (United Kingdom)) | GB (United Kingdom of Great Britain and Northern Ireland) | Each legal entity in the United Kingdom should have a Company registration number. | INFO |
| Identifier missing (Corporate number (Japan)) | JP (Japan) | Business partners in Japan should have a corporate number maintained. | WARNING |
| Identifier missing (Corporation ID (South Korea)) | KR (South Korea) | Each business partner in South Korea requires a Corporation ID. | ERROR |
| Identifier missing (Corporation number (Canada)) | CA (Canada) | Each legal entity in Canada requires a corporation number. | WARNING |
| Identifier missing (D-U-N-S (World)) | WORLD (World) | Business partners may have a D-U-N-S number maintained. The rule identifies partners without a D-U-N-S. | INFO |
| Identifier missing (Employer identification number (United States)) | US (United States of America) | Checks whether there is an Employer identification number maintained for this partner, if not then the rule is violated. | INFO |
| Identifier missing (European value added tax identifier (Austria)) | AT (Austria) | Each legal entity in Austria should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Belgium)) | BE (Belgium) | Each legal entity in Belgium should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Bulgaria)) | BG (Bulgaria) | Each legal entity in Bulgaria should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Croatia)) | HR (Croatia) | Each legal entity in Croatia should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Cyprus)) | CY (Cyprus) | Each legal entity in Cyprus should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Czech Republic)) | CZ (Czechia) | Each legal entity in Czech Republic should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (Denmark)) | DK (Denmark) | Each legal entity in Denmark should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (Estonia)) | EE (Estonia) | Each legal entity in Estonia should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Finland)) | FI (Finland) | Each legal entity in Finland should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (France)) | FR (France) | Each legal entity in France should have a European value added tax identifier. | ERROR |
| Identifier missing (European value added tax identifier (Germany)) | DE (Germany) | Each legal entity in Germany should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Greece)) | GR (Greece) | Each legal entity in Greece should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Hungary)) | HU (Hungary) | Each legal entity in Hungary should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (Ireland)) | IE (Ireland) | Each legal entity in Ireland should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Italy)) | IT (Italy) | Each legal entity in Italy should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (Latvia)) | LV (Latvia) | Each legal entity in Latvia should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Lithuania)) | LT (Lithuania) | Each legal entity in Lithuania should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Malta)) | MT (Malta) | Each legal entity in Malta should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Poland)) | PL (Poland) | Each legal entity in Poland should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (Portugal)) | PT (Portugal) | Each legal entity in Portugal should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Romania)) | RO (Romania) | Each legal entity in Romania should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Slovakia)) | SK (the Slovak Republic) | Each legal entity in Slovakia should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Slovenia)) | SI (Slovenia) | Each legal entity in Slovenia should have a European value added tax identifier. | WARNING |
| Identifier missing (European value added tax identifier (Spain)) | ES (Spain) | Each legal entity in Spain should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (Sweden)) | SE (Sweden) | Each legal entity in Sweden should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (The Netherlands)) | NL (Netherlands) | Each legal entity in The Netherlands should have a European value added tax identifier. | INFO |
| Identifier missing (European value added tax identifier (United Kingdom)) | GB (United Kingdom of Great Britain and Northern Ireland) | Each legal entity in the United Kingdom should have a European value added tax identifier. | INFO |
| Identifier missing (Faroese Identification Number (Faroe Islands)) | FO (Faroe Islands) | Each individual resident or non-resident eligible for paying taxes in Faroe Islands should have a Faroese Identification Number. | INFO |
| Identifier missing (Faroese P Number (Faroe Islands)) | FO (Faroe Islands) | Each individual in Faroe Islands should have a Faroese P Number. | INFO |
| Identifier missing (Faroese V Number (Faroe Islands)) | FO (Faroe Islands) | Each legal entity in Faroe Islands should have a Faroese V Number. | INFO |
| Identifier missing (Fiscal code (Italy)) | IT (Italy) | Each business partner in Italy requires a Fiscal code. | INFO |
| Identifier missing (GER number (Greenland)) | GL (Greenland) | Each legal entity in Greenland should have a GER number. | INFO |
| Identifier missing (GST number (India)) | IN (India) | Each business partner in India requires a GST number (India) | INFO |
| Identifier missing (GUI registration number (Taiwan)) | TW (Taiwan) | Each legal entity in Taiwan should have a GUI registration number | INFO |
| Identifier missing (Government Gazette Number (Turkey)) | TR (Turkey) | Each legal entity in Turkey should have a Government Gazette Number. | ERROR |
| Identifier missing (ICO number (Czech Republic)) | CZ (Czechia) | Each business partner in Czech Republic requires a ICO number. | INFO |
| Identifier missing (INN (Russia)) | RU (Russian Federation) | Each business partner in Russia requires an INN. | ERROR |
| Identifier missing (Icelandic Identification Number (Iceland)) | IS (Iceland) | Each individual in Iceland must have a Icelandic Identification Number. | INFO |
| Identifier missing (KPP number (Russia)) | RU (Russian Federation) | Each business partner in Russia requires an KPP number. | ERROR |
| Identifier missing (NIP number (Poland)) | PL (Poland) | Each legal entity in Poland should have a NIP number (Poland). | INFO |
| Identifier missing (NIT number (Bolivia)) | BO (Bolivia) | Each legal entity in Bolivia should have a Tax Identification Number. | ERROR |
| Identifier missing (NIT number (Guatemala)) | GT (Guatemala) | Each legal entity in Guatemala should have a NIT number | INFO |
| Identifier missing (Organization Number (Norway)) | NO (Norway) | Each business partner in Norway requires an Organization Number. | INFO |
| Identifier missing (Organization Registration Number (Sweden)) | SE (Sweden) | Each legal entity in Sweden should have a Organization Registration Number | INFO |
| Identifier missing (PAN code (India)) | IN (India) | Each business partner in India requires a PAN code. | INFO |
| Identifier missing (Personal Identification Number (Croatia)) | HR (Croatia) | The Personal Identification Number is mandatory for
| ERROR |
| Identifier missing (Personal Identification Number (Kenya)) | KE (Kenya) | Business partners in Kenya should have a personal identification number maintained. | WARNING |
| Identifier missing (REGON (Poland)) | PL (Poland) | Each legal entity in Poland should have a REGON. | INFO |
| Identifier missing (RIF number (Venezuela)) | VE (Venezuela) | Each legal entity in Venezuela should have a RIF number. | ERROR |
| Identifier missing (RNC number (Dominican Republic)) | DO (Dominican Republic) | Each legal entity in the Dominican Republic should have a RNC number | INFO |
| Identifier missing (RUC number (Panama)) | PA (Panama) | Business partners in Panama should have a RUC number (Panama) maintained. | WARNING |
| Identifier missing (RUC number (Peru)) | PE (Peru) | Each legal entity in Peru should have a RUC number | ERROR |
| Identifier missing (RUT number (Chile)) | CL (Chile) | Each legal entity in Chile should have a RUT number | ERROR |
| Identifier missing (SIREN number (France)) | FR (France) | Each legal entity in France should have a SIREN number. | WARNING |
| Identifier missing (SIRET number (France)) | FR (France) | Each business partner in France requires a SIRET number. | WARNING |
| Identifier missing (Sales and Services Tax number (Malaysia)) | MY (Malaysia) | Business partners in Malysia should have a Rales and Services Tax number (Malaysia) maintained. | WARNING |
| Identifier missing (Social Security Number (Jersey)) | JE (Jersey) | Each individual in Jersey should have a Social Security Number. | INFO |
| Identifier missing (Social Security Number (San Marino)) | SM (San Marino) | Each individual in San Marino should have a Social Security Number. | INFO |
| Identifier missing (Social security number (United States)) | US (United States of America) | ... | INFO |
| Identifier missing (TVA number (Tunisia)) | TN (Tunisia) | Each legal entity in Tunisia should have a Tax Identification Number. | ERROR |
| Identifier missing (Tax ID (Thailand)) | TH (Thailand) | Business partners in Thailand should have a Tax ID. | INFO |
| Identifier missing (Tax Identification Number (Angola)) | AO (Angola) | Business partners in Angola should have a Tax Identification Number maintained. | WARNING |
| Identifier missing (Tax Identification Number (Bangladesh)) | BD (Bangladesh) | Business partners in Bangladesh should have a tax identification number maintained. | ERROR |
| Identifier missing (Tax Identification Number (El Salvador)) | SV (El Salvador) | Each legal entity in El Salvador should have a tax identifier | ERROR |
| Identifier missing (Tax Identification Number (Indonesia)) | ID (Indonesia) | Each business partner in Indonesia requires a Tax Identification Number. | ERROR |
| Identifier missing (Tax Identification Number (Pakistan)) | PK (Pakistan) | Business partners in Pakistan should have a tax identification number maintained. | INFO |
| Identifier missing (Tax Identification Number (Sri Lanka)) | LK (Sri Lanka) | Each legal entity in Sri Lanka should have a tax identification number | INFO |
| Identifier missing (Tax Reference Number (Jersey)) | JE (Jersey) | Each legal entity in Jersey should have a Tax Reference Number. | INFO |
| Identifier missing (Tax Registration Number (Algeria)) | DZ (Algeria) | Business partners in Algeria should have a tax registration number (NIF) maintained. | INFO |
| Identifier missing (Tax Registration Number (Egypt)) | EG (Egypt) | Each legal entity in Egypt should have a Tax Registration Number. | ERROR |
| Identifier missing (Tax Registration Number (Morocco)) | MA (Morocco) | Each legal entity in Morocco should have a VAT Tax Registration Number. | ERROR |
| Identifier missing (Tax Registration Number (San Marino)) | SM (San Marino) | Each legal entity in San Marino should have a Tax Registration Number. | INFO |
| Identifier missing (Tax identification number (Egypt)) | EG (Egypt) | Each legal entity in Egypt should have a Tax identification number. | ERROR |
| Identifier missing (Tax number (Hungary)) | HU (Hungary) | Each legal entity in Hungary should have a tax identifier | INFO |
| Identifier missing (Tax number (Turkey)) | TR (Turkey) | Each legal entity in Turkey should have a VAT Tax Number. | ERROR |
| Identifier missing (Tax office name (Turkey)) | TR (Turkey) | Each legal entity in Turkey should have a Tax office name. | ERROR |
| Identifier missing (Taxpayer identification number (Philippines)) | PH (Philippines) | Business partners in the Philippines should have a taxpayer identification number maintained. | WARNING |
| Identifier missing (Taxpayer identification number (Ukraine)) | UA (Ukraine) | Each legal entity in Ukraine should have a taxpayer identification number | INFO |
| Identifier missing (UEN number (Singapore)) | SG (Singapore) | Each legal entity in Singapore should have a UEN number (Singapore). | ERROR |
| Identifier missing (USREOU number (Ukraine)) | UA (Ukraine) | Each legal entity in Ukraine should have a USREOU number (from Ukrainian "Код ЄДРПОУ"). It is a unique identification number of a legal entity in the Unified State Register of Enterprises and Organizations of Ukraine. It is mandatory for use in all types of reporting and accounting documents of the business entity and is indicated on its seals and stamps. In all documents - administrative, financial or other, where the enterprise (organization) appears, the identification number must be indicated in accordance with the EDRPOU. | INFO |
| Identifier missing (VAT Registration Number (Kenya)) | KE (Kenya) | A legal entity in Kenya should have a VAT registration number | INFO |
| Identifier missing (VAT Registration Number (Saudi Arabia)) | SA (Saudi Arabia) | Business partners in Saudi Arabia should have a VAT Registration Number (Saudi Arabia) maintained. | WARNING |
| Identifier missing (VAT number (Japan)) | JP (Japan) | Business partners in Japan should have a VAT number (Japanese Consumption Tax Number) maintained. | INFO |
| Identifier missing (VAT registration number (South Korea)) | KR (South Korea) | Each business partner in South Korea requires a VAT registration number | ERROR |
| Identifier missing (VAT registration number (Switzerland)) | CH (Switzerland) | In Switzerland, a business partner should have a VAT registration number | INFO |
| Identifier missing (VAT registration number (Ukraine)) | UA (Ukraine) | Each legal entity in Ukraine should have a VAT registration number | INFO |
| Identifier missing (VAT registration number (United Kingdom)) | GB (United Kingdom of Great Britain and Northern Ireland) | A business partner in UK requires a VAT registration number. | INFO |
| Identifier missing (Value Added Tax Number (Iceland)) | IS (Iceland) | Each legal entity in Iceland should have a Value Added Tax Number. | INFO |
| Mandatory identifier not maintained (Czech Republic) | CZ (Czechia) | A business partner in Czech Republic should have at least European value added tax identifier (Czech Republic) or a ICO number (Czech Republic) or a DIC number (Czech Republic). If none of these three is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Denmark) | DK (Denmark) | A business partner in Denmark should have at least European value added tax identifier (Denmark) or a CVR number (Denmark). If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Finland) | FI (Finland) | A business partner in Finland should have at least European value added tax identifier (Finland) or a Business identity code (Finland). If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Hungary) | HU (Hungary) | A business partner in Hungary should have at least a European value added tax identifier (Hungary), a Tax number (Hungary) or a Company registry number (Hungary). If none of these three is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (India) | IN (India) | A business partner in India should have at least a PAN code (India) or a GST number (India). If none of these two is available the record is invalid. | INFO |
| Mandatory identifier not maintained (Italy) | IT (Italy) | A business partner in Italy should have at least a European value added tax identifier (Italy) or a Fiscal code (Italy). If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Lithuania) | LT (Lithuania) | A business partner in Lithuania should have at least European value added tax identifier (Lithuania) or a Business Registration Number (Lithuania) or a Tax Registration Number (Lithuania). If none of these three is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Netherlands) | NL (Netherlands) | A business partner in the Netherlands should have at least an European value added tax identifier (The Netherlands) or a KVK number (Netherlands). If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Norway) | NO (Norway) | A business partner in Norway should have at least a VAT number (Norway) or an Organization Number (Norway). If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Pakistan) | PK (Pakistan) | A business partner in Pakistan should have at least a Tax Identification Number (Pakistan) (legal entity) or a Computerized National Identity Card (Pakistan) (individuals). If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Poland) | PL (Poland) | A business partner in Poland should have at least European value added tax identifier (Poland) or a NIP number (Poland). If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (South Africa) | ZA (South Africa) | A business partner in South Africa should have at least a VAT registration number (South Africa) or a Company registration number (South Africa). If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Spain) | ES (Spain) | A business partner in Spain should have at least European value added tax identifier (Spain) or a CIF number (Spain) or a NIF number (Spain). If none of these three is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (Sweden) | SE (Sweden) | A business partner in Sweden should have at least a European value added tax identifier (Sweden) or a Organization Registration Number (Sweden). If none of these two is available the record is considered as defective. | ERROR |
| Mandatory identifier not maintained (Thailand) | TH (Thailand) | A business partner in Thailand should have at least a Personal ID (for individuals) or a tax id. If none of these two is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (United Kingdom) | GB (United Kingdom of Great Britain and Northern Ireland) | A business partner in the United Kingdom should have at least a European value added tax identifier (United Kingdom) (still supported for now), a VAT registration number (United Kingdom) or a Company registration number (United Kingdom). If none of these three is available the record is invalid. | ERROR |
| Mandatory identifier not maintained (United States) | US (United States of America) | A business partner in US should have at least a Employer identification number (United States) or a state business register ID. If none of these two is available the record is invalid. | ERROR |