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 | Nederland (nl), Königreich der Niederlande (de), 荷蘭 (zh), Pays-Bas (fr), Netherlands (en) |
| Language-specific short name. Monolingual short name | Nederland (nl), Netherlands (en), 荷兰 (zh), 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 | fr, en
|
| 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 | Language-specific alternative, i.e. non-official, name. Alternative 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) | DRENTHE (en) |
| NL-FL (Flevoland) | NL-FL
|
Flevoland (de), Flevoland (en), Flevoland (fr), Flevoland (nl), 弗莱福兰省 (zh) | FLEVOLAND (en) |
| NL-FR (Friesland) | NL-FR
|
Friesland (en), Friesland (nl), Frise (fr), Provinz Friesland (de), 弗里斯兰省 (zh) | FRIESLAND (en) |
| NL-GE (Gelderland) | NL-GE
|
Gelderland (de), Gelderland (en), Gelderland (nl), Gueldre (fr), 海尔德兰省 (zh) | GELDERLAND (en) |
| NL-GR (Groningen) | NL-GR
|
Groningen (de), Groningen (en), Groningen (nl), Groningue (fr), 格罗宁根省 (zh) | GRONINGEN (en) |
| NL-LI (Limburg) | NL-LI
|
Limbourg (fr), Limburg (de), Limburg (en), Limburg (nl), 林堡省 (zh) | LIMBURG (en) |
| NL-NB (North Brabant) | NL-NB
|
Brabant-Septentrional (fr), Noord-Brabant (de), Noord-Brabant (nl), North Brabant (en), 北布拉班特省 (zh) | NOORD-BRABANT (en) |
| NL-NH (North Holland) | NL-NH
|
Hollande-Septentrionale (fr), Noord-Holland (de), Noord-Holland (nl), North Holland (en), 北荷兰省 (zh) | NOORD-HOLLAND (en) |
| NL-OV (Overijssel) | NL-OV
|
Overijssel (de), Overijssel (en), Overijssel (fr), Overijssel (nl), 上艾瑟尔省 (zh) | OVERIJSSEL (en) |
| 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) | UTRECHT (en) |
| NL-ZE (Zeeland) | NL-ZE
|
Zeeland (de), Zeeland (en), Zeeland (nl), Zélande (fr), 泽兰省 (zh) | ZEELAND (en) |
| NL-ZH (South Holland) | NL-ZH
|
Hollande-Méridionale (fr), South Holland (en), Zuid-Holland (de), Zuid-Holland (nl), 南荷蘭省 (zh) | ZUID-HOLLAND (en) |
Legal forms
| Legal form | Name | Main abbreviation | description | Category |
|---|---|---|---|---|
| NL_0281 (CDQ) | Vereniging van eigenaars (nl) | VVE (nl) | Association Global Data Packet | |
| NL_0492 (CDQ) | Maatschap (nl) | Mts (nl) | Civil Society | |
| NL_0594 (CDQ) | Vennootschap onder firma (nl) | VOF (nl) | Collective Name Company | |
| NL_1026 (CDQ) | European Economic Interest Grouping (nl) | EEIG (nl) | Economic Interest Group | |
| NL_1410 (CDQ) | rederij (nl) | |||
| NL_2775 (CDQ) | kerkgenootschap (nl) | |||
| NL_2830 (CDQ) | Naamloze vennootschap (nl) | NV (nl) | Private Limited Company | |
| NL_3024 (CDQ) | vereniging met volledige rechtsbevoegdheid (nl) | |||
| NL_4424 (CDQ) | Stichting (nl) | Stichting (nl) | Foundation Global Data Packet | |
| NL_4830 (CDQ) | Overige Privaatrechtelijke Rechtspersoon (nl) | |||
| NL_4833 (CDQ) | Besloten vennootschap (nl) | BV (nl) | Private Limited Company | |
| NL_5026 (CDQ) | Commanditaire vennootschap (nl) | C.V. (nl) | Public Institute | |
| NL_5295 (CDQ) | publiekrechtelijke rechtspersoon (nl) | |||
| NL_5416 (CDQ) | Eenmanszaak (nl) | Eenmanszaak (nl) | Sole Proprietorship | |
| NL_7038 (CDQ) | vereniging met beperkte rechtsbevoegdheid (nl) | |||
| NL_7086 (CDQ) | fonds voor gemene rekening (nl) | |||
| NL_7242 (CDQ) | rechtspersoon in oprichting (nl) | rp io (nl) RP io (nl) R.P. io (nl) | ||
| NL_7323 (CDQ) | Wettelijke Aansprakelijkheid (nl) | W.A (nl) | Estate | |
| NL_7576 (CDQ) | Uitsluiting van Aansprakelijkheid (nl) | U.A. (nl) | Foundation Global Data Packet | |
| NL_7756 (CDQ) | Onderlinge waarborgmaatschappij (nl) | OWM (nl) | Registered Partnership | |
| NL_8451 (CDQ) | Europees Economisch Samenwerkingsverband (nl) | EESV (nl) E.E.S.V. (nl) | ||
| NL_8724 (CDQ) | coöperatie (nl) | coöperatie (nl) coöp (nl) | ||
| NL_9327 (CDQ) | Beperkte Aansprakelijkheid (nl) | B.A. (nl) | Civil Law Partnership | |
| NL_9396 (CDQ) | Societas Cooperativa Europaea (nl) | SCE (nl) | Societas Europaea | |
| NL_9687 (CDQ) | Societas Europaea (nl) | SE (nl) | Societas Europaea |
Identifiers
| Identifier | Name | Registration authority |
|---|---|---|
| EU_VAT_ID_NL (NL - VAT identification number) | Omzetbelastingnummer (nl) Value added tax identification number (en) | |
| ID_NL_OB (NL - VAT identification number) | Omzetbelastingnummer (nl) Value added tax identification number (en) | |
| KVK_NL (NL - Business register ID) | Kamer van Koophandel (nl) Business register ID (en) | |
| NL_BSN (NL - Citizen service number) | Burgerservicenummer (nl) Citizen service number (en) | |
| NL_OIN (NL - Organization identification number) | Organisatie-identificatienummer (nl) Organization identification number (en) | |
| NL_SI_ID (NL - SI registration number) | SI registration number (nl) SI registration number (en) | |
| NL_TAX_ID (NL - Tax registration number) | Tax registration number (nl) Tax registration number (en) | |
| RSIN_NL (NL - Legal Ent. & PS ID Num.) | Rechtspersonen Samenwerkingsverbanden Informatie Nummer (nl) Legal Entities and Partnerships Identification Number (en) | |
| VEN_NL (NL - Branch number) | Vestigingsnummer (nl) Branch number (en) |
Data quality rules
| Data quality rule | Description | Criticality |
|---|---|---|
| Dummy post code detected (NL) | This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/NL are the following:
Regular expression/Mononumerical post code with delimeter 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. | 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) | This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/NL are the following:
Regular expression/One time vendor 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 . | WARNING |
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 |
|---|---|---|
| [[AT.FON (data source)]] FinanzOnline [[ BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
|
Allows to verify the validity of a VAT number issued by any European Member State. | LIVE
|
| [[BZST (data source)]] Bundeszentralamt für Steuern (Germany) [[ BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
|
Verifies the validity of the VAT number. | LIVE
|
| [[EU.EORI (data source)]] EORI [[ BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
|
EORI number is used as an identification number in all customs procedures when exchanging information with Customs administrations. | LIVE1,064 records |
| [[VIES (data source)]] VIES [[ BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
|
Official interface to the European MIAS database. | LIVE50,000,000 records |
| [[NL.GCB (data source)]] NL Bank Data [[ BANK_ACCOUNT]]A fatal error occurred in the #info parser function
|
NL Bank Data | BETA0 records |
| [[CDQ.VAT (data source)]] CDQ VAT Numbers [[ BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
|
European VAT numbers with registrant names and addresses, collected by CDQ from public websites. | IDEA
|
| [[EU.PC (data source)]] EuroStat Post Code Files (European Union) [[ ADDRESS]]A fatal error occurred in the #info parser function
|
n/a | IDEA
|
| [[NL.ADDR (data source)]] Netherlands authority address file (Netherlands) [[ ADDRESS]]A fatal error occurred in the #info parser function
|
n/a | IDEA
|
| [[NL.POST (data source)]] Netherland post [[ ADDRESS]]A fatal error occurred in the #info parser function
|
n/a | IDEA
|
| [[NL.POST.API (data source)]] Post code API (Netherlands) [[ ADDRESS]]A fatal error occurred in the #info parser function
|
n/a | IDEA
|
| [[NL.BR (data source)]] KVK [[ BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
|
Business register of The Netherlands. | BROKEN
|
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 |