LU (Luxembourg)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/LU
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 LU
Language-specific name. Monolingual name Luxembourg (fr), Luxembourg (en), Luxemburg (de), 卢森堡 (zh), Lëtzebuerg (lb)
Language-specific short name. Monolingual short name 卢森堡 (zh), Luxemburg (de), Luxembourg (en), Luxembourg (fr)
The offical langauge of a country. Official language de, lb, fr
Language used in a country, beside the administrative languages. other language 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
LU-CA (Canton of Capellen) LU-CA Canton of Capellen (en), Kanton Capellen (de), Kanton Capellen (lb), canton de Capellen (fr), 卡佩伦县 (zh) Capellen (de)
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) Diekirch (de)
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) Esch-sur-Alzette (en)
LU-G (Grevenmacher District) LU-G Distrikt Grevenmacher (de), Distrikt Gréiwemaacher (lb), Grevenmacher District (en), district de Grevenmacher (fr), 格雷文馬赫區 (zh) Grevenmacher (en)
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) Luxembourg (en)
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) Mersch (de)
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 formNameMain abbreviationdescriptionCategory
Association d'épargne pension (fr)ASSEP (fr)Association Global Data Packet
Société civile (fr)SCI (fr)De-facto Partnership
Association d'assurances mutuelles (fr)AAM (fr)Association Global Data Packet
European Economic Interest Grouping (en)EEIG (en)Economic Interest Group
Groupement d'intérêt économique (fr)GIE (fr)Economic Interest Group
Société en commandite speciale (fr)SECSP (fr)Commandite Partnership
Societas Cooperativa Europaea (fr)SCE (fr)Societas Europaea
Entreprise individuelle (fr)EI (fr)De-facto Partnership
Association sans but lucratif (fr)ASBL (fr)Association Global Data Packet
Société en nom collectif (fr)SENC (fr)General Partnership
Société en commandite par actions (fr)SECA (fr)Commandite Partnership
Societas Europaea (fr)SE (fr)Societas Europaea
Association agricole (fr)AA (fr)Association Global Data Packet
Société d'investissement à capital fixe (fr)SICAF (fr)Consulate
Anonymous Society (en)SA (en)Society
Société coopérative (fr)SC (fr)Association Global Data Packet
Société d'investissement à capital variable (fr)SICAV (fr)Securities Fund
Etablissement public (fr)EP (fr)Public Company
Association momentanée (fr)AM (fr)Association Global Data Packet
Fondation (fr)FON (fr)Trust
Société en commandite simple (fr)SECS (fr)Civil Law Partnership
Société à responsabilité limitée (fr)SARL (fr)Limited Liability Company
Société d’épargne-pension à capital variable (fr)SEPCAV (fr)Investment Company

Identifiers

IdentifierNameRegistration authority
EU_VAT_ID_LU (LU - VAT 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 (LU - VAT 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 (LU - RCS identification number)Registre de commerce et des sociétés (fr)
Trade and Companies Register (en)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (LU)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/LU 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 (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 LuxembourgERROR
Length of national bank Id invalid (Luxembourg)This rule checks whether the domestic bank id exceeds the maximum possible length in LuxembourgERROR
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 LuxembourgINFO
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)This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/LU 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. LIVE
1,064 records
[[VIES (data source)]]
VIES
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
Official interface to the European MIAS database. LIVE
50,000,000 records
[[CREFO.SSU (data source)]]
Creditreform SSU
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
Creditreform Smart Sign-Up provides verified company information for onboarding and compliance processes. BETA
972 records
[[LU.GCB (data source)]]
LU Bank Data
[[BANK_ACCOUNT]]A fatal error occurred in the #info parser function
LU Bank Data BETA
0 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

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