LU (Luxembourg)
DataModel:CDQ/Business Partner/Address/Country/LU
| Property | Value |
|---|---|
| A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code | LU
|
| Language-specific name. Monolingual name | Luxembourg (en), 卢森堡 (zh), Luxemburg (de), Lëtzebuerg (lb), Luxembourg (fr) |
| Language-specific short name. Monolingual short name | Luxembourg (en), Luxembourg (fr), 卢森堡 (zh), Luxemburg (de) |
| The offical langauge of a country. Official language | fr, lb, de
|
| Language used in a country, beside the administrative languages. other language | fr, lb, de
|
| 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 |
|---|---|---|
| LU-CA (Canton of Capellen) | LU-CA
|
Canton of Capellen (en), Kanton Capellen (de), Kanton Capellen (lb), canton de Capellen (fr), 卡佩伦县 (zh) |
| LU-CL (Canton of Clervaux) | LU-CL
|
Canton of Clervaux (en), Kanton Clerf (de), Kanton Klierf (lb), canton de Clervaux (fr), 克莱沃县 (zh) |
| LU-D (Diekirch District) | LU-D
|
Diekirch District (en), Distrikt Diekirch (de), Distrikt Dikrech (lb), district de Diekirch (fr), 迪基希區 (zh) |
| LU-DI (Canton of Diekirch) | LU-DI
|
Canton of Diekirch (en), Kanton Diekirch (de), Kanton Dikrech (lb), canton de Diekirch (fr), 迪基希县 (zh) |
| LU-EC (Canton of Echternach) | LU-EC
|
Canton of Echternach (en), Kanton Echternach (de), Kanton Iechternach (lb), canton d'Echternach (fr), 埃希特纳赫县 (zh) |
| LU-ES (Canton of Esch-sur-Alzette) | LU-ES
|
Canton of Esch-sur-Alzette (en), Kanton Esch an der Alzette (de), Kanton Esch-Uelzecht (lb), canton d'Esch-sur-Alzette (fr), 阿尔泽特河畔埃施县 (zh) |
| LU-G (Grevenmacher District) | LU-G
|
Distrikt Grevenmacher (de), Distrikt Gréiwemaacher (lb), Grevenmacher District (en), district de Grevenmacher (fr), 格雷文馬赫區 (zh) |
| LU-GR (Canton of Grevenmacher) | LU-GR
|
Canton of Grevenmacher (en), Kanton Grevenmacher (de), Kanton Gréiwemaacher (lb), canton de Grevenmacher (fr), 格雷文马赫县 (zh) |
| LU-L (Luxembourg District) | LU-L
|
Distrikt Luxemburg (de), Distrikt Lëtzebuerg (lb), Luxembourg District (en), district de Luxembourg (fr), 盧森堡區 (zh) |
| LU-LU (Canton of Luxembourg) | LU-LU
|
Canton of Luxembourg (en), Kanton Luxemburg (de), Kanton Lëtzebuerg (lb), canton de Luxembourg (fr), 卢森堡县 (zh) |
| LU-ME (Canton of Mersch) | LU-ME
|
Canton of Mersch (en), Kanton Mersch (de), Kanton Miersch (lb), canton de Mersch (fr), 梅尔施县 (zh) |
| LU-RD (Canton of Redange) | LU-RD
|
Canton of Redange (en), Kanton Redingen (de), Kanton Réiden (lb), canton de Redange (fr), 雷当日县 (zh) |
| LU-RM (Canton of Remich) | LU-RM
|
Canton of Remich (en), Kanton Remich (de), Kanton Réimech (lb), canton de Remich (fr), 雷米希县 (zh) |
| LU-VD (Canton of Vianden) | LU-VD
|
Canton of Vianden (en), Kanton Veianen (lb), Kanton Vianden (de), canton de Vianden (fr), 菲安登县 (zh) |
| LU-WI (Canton of Wiltz) | LU-WI
|
Canton of Wiltz (en), Kanton Wiltz (de), Kanton Wolz (lb), canton de Wiltz (fr), 维尔茨县 (zh) |
Legal forms
| Legal form | ELF code | Name | Main abbreviation |
|---|---|---|---|
| LU_0032 (CDQ) | LU_0032 | Association d'épargne pension (fr) | ASSEP (fr) |
| LU_0203 (CDQ) | LU_0203 | Société civile (fr) | SCI (fr) |
| LU_0754 (CDQ) | LU_0754 | Association d'assurances mutuelles (fr) | AAM (fr) |
| LU_2433 (CDQ) | LU_2433 | European Economic Interest Grouping (en) | EEIG (en) |
| LU_2450 (CDQ) | LU_2450 | Groupement d'intérêt économique (fr) | GIE (fr) |
| LU_2723 (CDQ) | LU_2723 | Société en commandite speciale (fr) | SECSP (fr) |
| LU_3252 (CDQ) | LU_3252 | Societas Cooperativa Europaea (fr) | SCE (fr) |
| LU_3653 (CDQ) | LU_3653 | Entreprise individuelle (fr) | EI (fr) |
| LU_3707 (CDQ) | LU_3707 | Association sans but lucratif (fr) | ASBL (fr) |
| LU_3890 (CDQ) | LU_3890 | Société en nom collectif (fr) | SENC (fr) |
| LU_4219 (CDQ) | LU_4219 | Société en commandite par actions (fr) | SECA (fr) |
| LU_4254 (CDQ) | LU_4254 | Societas Europaea (fr) | SE (fr) |
| LU_4360 (CDQ) | LU_4360 | Association agricole (fr) | AA (fr) |
| LU_4716 (CDQ) | LU_4716 | Société d'investissement à capital fixe (fr) | SICAF (fr) |
| LU_6206 (CDQ) | LU_6206 | Anonymous Society (en) | SA (en) |
| LU_7773 (CDQ) | LU_7773 | Société coopérative (fr) | SC (fr) |
| LU_8099 (CDQ) | LU_8099 | Société d'investissement à capital variable (fr) | SICAV (fr) |
| LU_8134 (CDQ) | LU_8134 | Etablissement public (fr) | EP (fr) |
| LU_8200 (CDQ) | LU_8200 | Association momentanée (fr) | AM (fr) |
| LU_8921 (CDQ) | LU_8921 | Fondation (fr) | FON (fr) |
| LU_9098 (CDQ) | LU_9098 | Société en commandite simple (fr) | SECS (fr) |
| LU_9166 (CDQ) | LU_9166 | Société à responsabilité limitée (fr) | SARL (fr) |
| LU_9901 (CDQ) | LU_9901 | Société d’épargne-pension à capital variable (fr) | SEPCAV (fr) |
Identifiers
| Identifier | Name | Registration authority |
|---|---|---|
| EU_VAT_ID_LU (Value added tax identification number) | Nummer vun der TVA (lb) Mehrwertsteuer-Identifikationsnummer (de) Numéro d'Identification à la TVA (fr) Value added tax identification number (en) | |
| ID_TVA_LU (Value added tax identification number) | Numéro de taxe sur la valeur ajoutée (lb) Numéro de taxe sur la valeur ajoutée (de) Numéro de taxe sur la valeur ajoutée (fr) Value added tax identification number (en) | |
| LU_RCS (Trade and Companies Register) | Registre de commerce et des sociétés (fr) Trade and Companies Register (en) |
Data quality rules
| Data quality rule | Description | Criticality |
|---|---|---|
| Dummy post code detected (LU) | 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 LU (Luxembourg) are the following: Regular expression/Mononumerical post code with delimeter | ERROR |
| Identifier Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Identifier Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Identifier Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Identifier format invalid (European value added tax identifier (Luxembourg)) | The European value added tax identifier in Luxembourg consists of exact 8 numerical digits prefixed by "LU". This rule checks the presence of exact 8 digits without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more or non-numeric digits the rule is violated. | ERROR |
| Identifier unknown (European value added tax identifier (Luxembourg)) | European value added tax identifier (Luxembourg) | ERROR |
| Invalid checksum of EU VAT ID LU (Luxembourg) | This rule checks the checksum of the European VAT number in Luxembourg using the following formula:
[C7 C8] = ([C1 C2 C3 C4 C5 C6]) Modulo 89 | ERROR |
| Legal form invalid (Luxembourg) | Each record should have legal form appropriate for the country. | INFO |
| Length of domestic bank account Id invalid (Luxembourg) | This rule checks whether the domestic bank account id exceeds the maximum possible length in Luxembourg | ERROR |
| Length of national bank Id invalid (Luxembourg) | This rule checks whether the domestic bank id exceeds the maximum possible length in Luxembourg | ERROR |
| Locality Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Locality Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Locality Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Mandatory administrative area missing (Luxembourg) | 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 Luxembourg | INFO |
| Mandatory locality missing (Luxembourg) | The locality is mandatory for street addresses in Luxembourg. | ERROR |
| Mandatory post code missing (Luxembourg) | The post code is mandatory for street addresses in Luxembourg. | ERROR |
| Mandatory thoroughfare missing (Luxembourg) | The thoroughfare is mandatory for street addresses in Luxembourg. | ERROR |
| Name Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Name Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Name Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Post code Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Post code Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Post code Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Post code format invalid (Luxembourg) | This rule checks the post code format of Luxembourg. Postal codes in Luxembourg consist of a block of 4 numbers (NNNN), beginning with a number between 1 and 9, and they are written on the last line of the address preceding the town name. Postal codes beginning with the following numbers are currently not used: 30,31,50,51,60,70,71,78,79,89. The first two digits indicate the delivery office. The postal code format is C-NNNN. | ERROR |
| Thoroughfare Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Thoroughfare Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Thoroughfare Qualification (European value added tax identifier (Luxembourg), 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 (Luxembourg) | INFO |
| Unallowed pattern in name detected (LU) | 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 LU (Luxembourg) 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 |
| LU.GCB (data source) | Bank Data details provided by the ABBL - Luxembourg Bankers' Association (en) LU Bank Data (de) | BANK_ACCOUNT |
| VIES (data source) | VAT Information Exchange System (en) | BUSINESS_PARTNER |
Banking metadata
| Property | Value |
|---|---|
| Full metadata | Bank accounts in Luxembourg |
| Local name of the national bank ID. Bank ID name | BAN Luxembourg /Bank Code |
| The provider (national authorities in most cases) of the national bank ID. Bank ID provider | Association of Luxembourg (L'Association des banques et banquiers, Luxembourg) |
| Currency code for accounting in the given country. Currency code | EUR
|
| Maximum length of the national bank ID. Maximum bank ID length | 3 |
| Maximum length of the national bank account ID. Maximum bank account ID length | 13 |