NL (Netherlands)
DataModel:CDQ/Business Partner/Address/Country/NL
| Property | Value |
|---|---|
| A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code | NL
|
| Language-specific name. Monolingual name | Pays-Bas (fr), 荷蘭 (zh), Königreich der Niederlande (de), Nederland (nl), Netherlands (en) |
| Language-specific short name. Monolingual short name | 荷兰 (zh), Nederland (nl), Netherlands (en), Niederlande (de), Pays-Bas (fr) |
| The offical langauge of a country. Official language | nl
|
| Language used in a country, beside the administrative languages. other language | nl
|
| Continent a country belongs to. Part of | Europe |
Regions
| Region (controlled vocabulary) | A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code | Language-specific name. Monolingual name |
|---|---|---|
| NL-AW (Aruba) | NL-AW
|
Aruba (de), Aruba (en), Aruba (fr), Aruba (nl), 阿魯巴 (zh) |
| NL-BQ1 (Bonaire) | NL-BQ1
|
Bonaire (de), Bonaire (en), Bonaire (fr), Bonaire (nl), 博奈尔 (zh) |
| NL-BQ2 (Saba) | NL-BQ2
|
Saba (de), Saba (en), Saba (fr), Saba (nl), 薩巴 (zh) |
| NL-BQ3 (Sint Eustatius) | NL-BQ3
|
Saint-Eustache (fr), Sint Eustatius (de), Sint Eustatius (en), Sint Eustatius (nl), 圣尤斯特歇斯 (zh) |
| NL-CW (Curaçao) | NL-CW
|
Curaçao (de), Curaçao (en), Curaçao (fr), Curaçao (nl), 库拉索 (zh) |
| NL-DR (Drenthe) | NL-DR
|
Drenthe (de), Drenthe (en), Drenthe (fr), Drenthe (nl), 德伦特省 (zh) |
| NL-FL (Flevoland) | NL-FL
|
Flevoland (de), Flevoland (en), Flevoland (fr), Flevoland (nl), 弗莱福兰省 (zh) |
| NL-FR (Friesland) | NL-FR
|
Friesland (en), Friesland (nl), Frise (fr), Provinz Friesland (de), 弗里斯兰省 (zh) |
| NL-GE (Gelderland) | NL-GE
|
Gelderland (de), Gelderland (en), Gelderland (nl), Gueldre (fr), 海尔德兰省 (zh) |
| NL-GR (Groningen) | NL-GR
|
Groningen (de), Groningen (en), Groningen (nl), Groningue (fr), 格罗宁根省 (zh) |
| NL-LI (Limburg) | NL-LI
|
Limbourg (fr), Limburg (de), Limburg (en), Limburg (nl), 林堡省 (zh) |
| NL-NB (North Brabant) | NL-NB
|
Brabant-Septentrional (fr), Noord-Brabant (de), Noord-Brabant (nl), North Brabant (en), 北布拉班特省 (zh) |
| NL-NH (North Holland) | NL-NH
|
Hollande-Septentrionale (fr), Noord-Holland (de), Noord-Holland (nl), North Holland (en), 北荷兰省 (zh) |
| NL-OV (Overijssel) | NL-OV
|
Overijssel (de), Overijssel (en), Overijssel (fr), Overijssel (nl), 上艾瑟尔省 (zh) |
| NL-SX (Sint Maarten (Dutch part)) | NL-SX
|
Saint-Martin (partie néerlandaise) (fr), Sint Maarten (de), Sint Maarten (nl), Sint Maarten (Dutch part) (en), 荷屬聖馬丁 (zh) |
| NL-UT (Utrecht Province) | NL-UT
|
Utrecht (de), Utrecht (fr), Utrecht (nl), Utrecht Province (en), 乌得勒支省 (zh) |
| NL-ZE (Zeeland) | NL-ZE
|
Zeeland (de), Zeeland (en), Zeeland (nl), Zélande (fr), 泽兰省 (zh) |
| NL-ZH (South Holland) | NL-ZH
|
Hollande-Méridionale (fr), South Holland (en), Zuid-Holland (de), Zuid-Holland (nl), 南荷蘭省 (zh) |
Legal forms
| Legal form | ELF code | Name | Main abbreviation |
|---|---|---|---|
| NL_0281 (CDQ) | NL_0281 | Vereniging van eigenaars (nl) | VVE (nl) |
| NL_0492 (CDQ) | NL_0492 | Maatschap (nl) | Mts (nl) |
| NL_0594 (CDQ) | NL_0594 | Vennootschap onder firma (nl) | VOF (nl) |
| NL_1026 (CDQ) | NL_1026 | European Economic Interest Grouping (nl) | EEIG (nl) |
| NL_2830 (CDQ) | NL_2830 | Naamloze vennootschap (nl) | NV (nl) |
| NL_4424 (CDQ) | NL_4424 | Stichting (nl) | Stichting (nl) |
| NL_4833 (CDQ) | NL_4833 | Besloten vennootschap (nl) | BV (nl) |
| NL_5026 (CDQ) | NL_5026 | Commanditaire vennootschap (nl) | C.V. (nl) |
| NL_5416 (CDQ) | NL_5416 | Eenmanszaak (nl) | Eenmanszaak (nl) |
| NL_7323 (CDQ) | NL_7323 | Wettelijke Aansprakelijkheid (nl) | W.A (nl) |
| NL_7576 (CDQ) | NL_7576 | Uitsluiting van Aansprakelijkheid (nl) | U.A. (nl) |
| NL_7756 (CDQ) | NL_7756 | Onderlinge waarborgmaatschappij (nl) | OWM (nl) |
| NL_9327 (CDQ) | NL_9327 | Beperkte Aansprakelijkheid (nl) | B.A. (nl) |
| NL_9396 (CDQ) | NL_9396 | Societas Cooperativa Europaea (nl) | SCE (nl) |
| NL_9687 (CDQ) | NL_9687 | Societas Europaea (nl) | SE (nl) |
Identifiers
| Identifier | Name | Registration authority |
|---|---|---|
| EU_VAT_ID_NL (Value added tax identification number) | Omzetbelastingnummer (nl) Value added tax identification number (en) | |
| ID_NL_OB (Value added tax identification number) | Omzetbelastingnummer (nl) Value added tax identification number (en) | |
| KVK_NL (Business register ID) | Kamer van Koophandel (nl) Business register ID (en) | |
| NL_BSN (Citizen service number) | Burgerservicenummer (nl) Citizen service number (en) | Ministry of the Interior and Kingdom Relations |
| NL_SI_ID (SI registration number) | SI registration number (nl) SI registration number (en) | |
| NL_TAX_ID (Tax registration number) | Tax registration number (nl) Tax registration number (en) | Tax and Customs Administration |
| RSIN_NL (Legal Entities and Partnerships Identification Number) | Rechtspersonen Samenwerkingsverbanden Informatie Nummer (nl) Legal Entities and Partnerships Identification Number (en) | Tax and Customs Administration |
| VEN_NL (Branch number) | Vestigingsnummer (nl) Branch number (en) |
Data quality rules
| Data quality rule | Description | Criticality |
|---|---|---|
| Dummy post code detected (NL) | Regular expression/Not available post code Regular expression/One digit multiplied several times post code Regular expression/Ordinal sequence of numbers Regular expression/Single digit post code Regular expression/Very long digits post code. This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for NL (Netherlands) are the following: Regular expression/Mononumerical post code with delimeter | ERROR |
| Identifier Qualification (European value added tax identifier (The Netherlands), Data source:AT.FON) | This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Identifier Qualification (European value added tax identifier (The Netherlands), Data source:BZST) | This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Identifier Qualification (European value added tax identifier (The Netherlands), Data source:VIES) | This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Identifier format inaccurate (European value added tax identifier (The Netherlands)) | This rule checks the syntax, i.e. format of the European value added tax identifier in the Netherlands with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation. The European value added tax identifier in Netherlands consists of the prefix "NL", followed by 9 numerical digits + the character "B" + 2 numerical digits. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, hyphens or dots then the rule is violated. | INFO |
| Identifier format invalid (European value added tax identifier (The Netherlands)) | The European value added tax identifier in Netherlands consists of the prefix "NL", followed by 9 numerical digits + the character "B" + 2 numerical digits. This rule checks the presence of exact 12 ciphers including a letter "B" on a right place according to this scheme without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. | ERROR |
| Identifier missing (European value added tax identifier (The Netherlands)) | Each legal entity in The Netherlands should have a European value added tax identifier. | INFO |
| Identifier unknown (European value added tax identifier (The Netherlands)) | European value added tax identifier (The Netherlands) | ERROR |
| Inconsistency between RSIN and European value added tax identifier (The Netherlands) | The 9 digits following the "NL"-prefix are the RSIN. This rules check if the 9 digits following the "NL" in EU_VAT_ID_BE are equal to RSIN. Any difference result in a rule violation. | ERROR |
| Invalid checksum of EU VAT ID NL (The Netherlands) | This rule checks the checksum of the European VAT number in The Netherlands. The checksum validation is done following modulo 11:
| ERROR |
| Legal form invalid (The Netherlands) | Each record should have legal form appropriate for the country. | INFO |
| Length of domestic bank account Id invalid (Netherlands) | This rule checks whether the domestic bank account id exceeds the maximum possible length in The Netherlands | ERROR |
| Length of national bank Id invalid (Netherlands) | This rule checks whether the domestic bank id exceeds the maximum possible length in The Netherlands | ERROR |
| Locality Qualification (European value added tax identifier (Netherlands), Data source:AT.FON) | This data quality rule checks the congruency of the given city against the city maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Locality Qualification (European value added tax identifier (Netherlands), Data source:BZST) | This data quality rule checks the congruency of the given city against the city maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Locality Qualification (European value added tax identifier (Netherlands), Data source:VIES) | This data quality rule checks the congruency of the given city against the city maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Mandatory administrative area missing (The Netherlands) | The administrative area (a top-level geographical or political area division in a country) is required (i.e. mandatory) for a complete physical touchpoint in The Netherlands | INFO |
| Mandatory identifier not maintained (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 locality missing (The Netherlands) | The locality is mandatory for street addresses in The Netherlands. | ERROR |
| Mandatory post code missing (The Netherlands) | The post code is mandatory for street addresses in The Netherlands. | ERROR |
| Mandatory thoroughfare missing (The Netherlands) | The thoroughfare is mandatory for street addresses in The Netherlands. | ERROR |
| Name Qualification (European value added tax identifier (Netherlands), Data source:AT.FON) | This data quality rule checks the congruency of the given name against the name maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Name Qualification (European value added tax identifier (Netherlands), Data source:BZST) | This data quality rule checks the congruency of the given name against the name maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Name Qualification (European value added tax identifier (Netherlands), Data source:VIES) | This data quality rule checks the congruency of the given name against the name maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Post code Qualification (European value added tax identifier (Netherlands), Data source:AT.FON) | This data quality rule checks the congruency of the given post code against the post code maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Post code Qualification (European value added tax identifier (Netherlands), Data source:BZST) | This data quality rule checks the congruency of the given post code against the post code maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Post code Qualification (European value added tax identifier (Netherlands), Data source:VIES) | This data quality rule checks the congruency of the given post code against the post code maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Post code format invalid (Netherlands) | This rule checks the post code format of Netherlands. Postal codes in the Netherlands, known as Postcodes, postal codes have 4 digits and two letters, the digits starting with a number between 1 and 9. The layout is as follows: NNNN AA. The postal code is written before, and on the same line as, the town name. The digits indicate the town or district, the letters a group of some 25 habitations, offices, factories or post office boxes. There is no correlation between codes and administrative districts. The letter combinations SS, SA and SD are not used. There should be no punctuation anywhere within the postal code, and there should be nothing written underneath the postal code. | ERROR |
| Thoroughfare Qualification (European value added tax identifier (Netherlands), Data source:AT.FON) | This data quality rule checks the congruency of the given street against the street maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Thoroughfare Qualification (European value added tax identifier (Netherlands), Data source:BZST) | This data quality rule checks the congruency of the given street against the street maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Thoroughfare Qualification (European value added tax identifier (Netherlands), Data source:VIES) | This data quality rule checks the congruency of the given street against the street maintained as reference for the European value added tax identifier (The Netherlands) | INFO |
| Unallowed pattern in name detected (NL) | Regular expression/Aggregated payments Regular expression/No new orders Regular expression/Do not use duplicates note Regular expression/Reference to other record Regular expression/No use note Regular expression/Reference to new record Regular expression/Reference the former name Regular expression/Long number in name Regular expression/Duplicate record note Regular expression/Deletion note Regular expression/Dummy record note Regular expression/Sequence of digits Regular expression/Unsorted keywords Regular expression/Length of name . This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for NL (Netherlands) are the following: Regular expression/One time vendor | WARNING |
Data sources
| Data quality rule | Name | Content |
|---|---|---|
| AT.FON (data source) | FinanzOnline Austria (en) | BUSINESS_PARTNER |
| BZST (data source) | Federal Central Tax Office (Germany) (en) Bundeszentralamt für Steuern (Germany) (en) | BUSINESS_PARTNER |
| CDQ.VAT (data source) | CDQ European VAT Registration Database (en) | BUSINESS_PARTNER |
| EU.EORI (data source) | Economic Operator Identification and Registration Database (en) | BUSINESS_PARTNER |
| EU.PC (data source) | EuroStat Post Code Files (European Union) (en) | ADDRESS |
| NL.ADDR (data source) | Netherlands authority address file (Netherlands) (en) | ADDRESS |
| NL.BR (data source) | Chamber of Commerce (en) Kamer van Koophandel (de) | BUSINESS_PARTNER |
| NL.GCB (data source) | Netherland's banks data provided by the Dutch Payments Association (en) NL Bank Data (de) | BANK_ACCOUNT |
| NL.POST (data source) | Netherland post (en) | ADDRESS |
| NL.POST.API (data source) | Post code API (Netherlands) (en) | ADDRESS |
| VIES (data source) | VAT Information Exchange System (en) | BUSINESS_PARTNER |
Banking metadata
| Property | Value |
|---|---|
| Full metadata | Bank accounts in Netherlands |
| Local name of the national bank ID. Bank ID name | BIC4 |
| The provider (national authorities in most cases) of the national bank ID. Bank ID provider | Generated from SWIFT BICs |
| Currency code for accounting in the given country. Currency code | EUR
|
| Maximum length of the national bank ID. Maximum bank ID length | 4 |
| Maximum length of the national bank account ID. Maximum bank account ID length | 10 |