DE (Germany)

From CDQ Wiki
< Business Partner (CDQ) | Address (CDQ) | Country (CDQ)
DataModel:CDQ/Business Partner/Address/Country/DE
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 DE
Language-specific name. Monolingual name Germany (en), Allemagne (fr), Deutschland (de), 德国 (zh)
Language-specific short name. Monolingual short name Deutschland (de), Allemagne (fr), Germany (en), 德国 (zh)
The offical langauge of a country. Official language de
Language used in a country, beside the administrative languages. other language en, fr
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
DE-BB (Brandenburg) DE-BB Brandebourg (fr), Brandenburg (de), Brandenburg (en), 勃兰登堡 (zh) Brandenburg (en)
DE-BE (Berlin) DE-BE Berlin (de), Berlin (en), Berlin (fr), 柏林 (zh) Berlin (en)
DE-BW (Baden-Württemberg) DE-BW Bade-Wurtemberg (fr), Baden-Württemberg (de), Baden-Württemberg (en), 巴登－符腾堡 (zh) Baden-Wurttemberg (en)
DE-BY (Bavaria) DE-BY Bavaria (en), Bavière (fr), Bayern (de), 巴伐利亚 (zh) Bayern (en)
DE-HB (Free Hanseatic City of Bremen) DE-HB Brême (fr), Free Hanseatic City of Bremen (en), Freie Hansestadt Bremen (de), 不來梅州 (zh) Bremen (en)
DE-HE (Hesse) DE-HE Hesse (en), Hesse (fr), Hessen (de), 黑森 (zh) Hessen (en)
DE-HH (Hamburg) DE-HH Hambourg (fr), Hamburg (de), Hamburg (en), 汉堡 (zh) Hamburg (en)
DE-MV (Mecklenburg-Vorpommern) DE-MV Mecklembourg-Poméranie-Occidentale (fr), Mecklenburg-Vorpommern (de), Mecklenburg-Vorpommern (en), 梅克伦堡－前波美拉尼亚 (zh) Mecklenburg-Vorpommern (en), Mecklenburg-Vorpomm. (en)
DE-NI (Lower Saxony) DE-NI Basse-Saxe (fr), Lower Saxony (en), Niedersachsen (de), 下萨克森 (zh) Lower-Saxony (en), Niedersachsen (en)
DE-NW (North Rhine-Westphalia) DE-NW Nordrhein-Westfalen (de), North Rhine-Westphalia (en), Rhénanie-du-Nord-Westphalie (fr), 北萊茵－威斯特法倫 (zh) Nrth Rhine Westfalia (en), North-Rhine-Westphalia (en)
DE-RP (Rhineland-Palatinate) DE-RP Rheinland-Pfalz (de), Rhineland-Palatinate (en), Rhénanie-Palatinat (fr), 莱茵兰－普法尔茨 (zh) Rheinland-Pfalz (de), Rhineland Palatinate (en)
DE-SH (Schleswig-Holstein) DE-SH Schleswig-Holstein (de), Schleswig-Holstein (en), Schleswig-Holstein (fr), 石勒苏益格-荷尔斯泰因 (zh) Schleswig-Holstein (en)
DE-SL (Saarland) DE-SL Saarland (de), Saarland (en), Sarre (fr), 萨尔 (zh) Saarland (en)
DE-SN (Saxony) DE-SN Sachsen (de), Saxe (fr), Saxony (en), 萨克森自由州 (zh) Sachsen (en)
DE-ST (Saxony-Anhalt) DE-ST Sachsen-Anhalt (de), Saxe-Anhalt (fr), Saxony-Anhalt (en), 萨克森－安哈尔特 (zh) Sachsen-Anhalt (en)
DE-TH (Thuringia) DE-TH Thuringe (fr), Thuringia (en), Thüringen (de), 圖林根 (zh) Thüringen (en)

Legal forms

Legal formNameMain abbreviationdescriptionCategory
DE_0251 (CDQ)Einzelunternehmen (de)e.Kfm. (de)
e.Kfr. (de)		"Eingetragener Kaufmann" for men entrepreneurs or "Eingetragene Kauffrau" for women entrepreneurs or "Einzelunternehmen" for a neutral concept.Proprietorship
DE_0263 (CDQ)Eingetragener Verein (de)e.V (de)Friendly Society
DE_0361 (CDQ)Gesellschaft mit beschränkter Haftung & Co. Offene Handelsgesellschaft (de)GmbH & Co. OHG (de)Private Limited Company
DE_0409 (CDQ)Sonstige juristische Person des öffentlichen Rechts (de)SPöR (de)Government Body
DE_0639 (CDQ)Öffentlich-private Partnerschaft (de)ÖPP (de)Partnership
DE_0708 (CDQ)Anstalt des öffentlichen Rechts (de)AdöR (de)Institution
DE_0944 (CDQ)Sonstige Organisation ohne Erwerbszweck (de)SoOE (de)Institution
DE_1156 (CDQ)Unternehmergesellschaft (haftungsbeschränkt) & Co. KG (de)UG & Co. KG (de)Society
DE_1256 (CDQ)Kommanditgesellschaft auf Aktienit mit haftungsbeschränktem Komplementär (de)Ltd. & Co. KGaA (de)Limited Partnership
DE_1290 (CDQ)Kommanditgesellschaft auf Aktien mit haftungsbeschränktem Komplementär (de)PartG & Co. KGaA (de)Limited Partnership
DE_1575 (CDQ)Unternehmergesellschaft & Co. OHG (de)UG & Co. OHG (de)Limited Company
DE_1609 (CDQ)Versicherungsverein auf Gegenseitigkeit (de)VVaG (de)Insurance Company
DE_1740 (CDQ)Partnerschaftsgesellschaft (de)PartG (de)Partnership
DE_1915 (CDQ)Gemeinnützige Aktiengesellschaft (de)gAG (de)Public Limited Company
DE_2053 (CDQ)Stiftung des öffentlichen Rechts (de)SöR (de)Foundation Global Data Packet
DE_2132 (CDQ)Aktiengesellschaften & Co. Offene Handelsgesellschaft (de)AG & Co. OHG (de)Public Limited Company
DE_2178 (CDQ)Gesellschaft mit beschränkter Haftung & Compagnie Kommanditgesellschaft (de)GmbH & Co. KG (de)Limited Partnership
DE_2184 (CDQ)EU Association (en)SE (de)Societas Europaea
DE_2449 (CDQ)Societas Europaea & Co. Offene Handelsgesellschaft (de)SE & Co. OHG (de)Commercial Corporation
DE_2889 (CDQ)Unternehmergesellschaft & Co. KGaA (de)UG & Co. KGaA (de)Limited Company
DE_3055 (CDQ)Kommanditgesellschaft mit haftungsbeschränktem Komplementär (de)PartG & Co. KG (de)Limited Partnership
DE_3135 (CDQ)Privatperson (de)Sole Proprietorship
DE_3597 (CDQ)Körperschaft des öffentlichen Rechts (de)K. d. ö. R. (de)Government Body
DE_3689 (CDQ)Eingetragene Genossenschaft (de)e.G. (de)Co-operative Partnership
DE_4129 (CDQ)Kommanditgesellschaft auf Aktien (de)KGaA (de)Limited Partnership with Shares
DE_4206 (CDQ)Zweckverband (de)ZweckV (de)Association Global Data Packet
DE_4312 (CDQ)Gebietskörperschaft (de)G (de)Government Body
DE_4333 (CDQ)Stiftung des privaten Rechts (de)SpR (de)Foundation Global Data Packet
DE_4404 (CDQ)Juristische Person alten Hamburgischen Rechts (de)JPahR (de)Government Body
DE_4530 (CDQ)Partnerschaft (de)Part (de)Partnership
DE_4956 (CDQ)Unternehmensgesellschaft (de)U.G. (de)Limited Company
DE_5247 (CDQ)Ltd. & Co. Offene Handelsgesellschaft (de)Ltd. & Co. OHG (de)Commercial Corporation
DE_5809 (CDQ)Kommanditgesellschaft mit haftungsbeschränktem Komplementär (de)Ltd. & Co. KG (de)Limited Partnership
DE_6036 (CDQ)Investmentaktiengesellschaft (de)InvAG (de)Public Limited Company
DE_7059 (CDQ)Aktiengesellschaften & Co. Kommanditgesellschaft (de)AG & Co. KG (de)Limited Partnership
DE_7555 (CDQ)Wirtschaftlicher Verein (de)wV (de)Association Global Data Packet
DE_7653 (CDQ)Kommanditgesellschaft (de)KG (de)Limited Partnership
DE_8044 (CDQ)Gesellschaft mit beschränkter Haftung & Co. Kommanditgesellschaft auf Aktien (de)GmbH & Co. KGaA (de)Limited Partnership
DE_8135 (CDQ)Societas Europaea & Co. Kommanditgesellschaft (de)SE & Co. KG (de)Limited Partnership
DE_8192 (CDQ)Gemeinnützige Gesellschaft mit beschränkter Haftung (de)gGmbH (de)Private Limited Company
DE_8247 (CDQ)Aktiengesellschaften & Co. Kommanditgesellschaft auf Aktien (de)AG & Co. KGaA (de)Limited Partnership
DE_8291 (CDQ)Societas Europaea & Co. Kommanditgesellschaft auf Aktien (de)SE & Co. KGaA (de)Limited Partnership
DE_8553 (CDQ)Offene Handelsgesellschaft mit haftungsbeschränktem Gesellschafter (de)PartG & Co. OHG (de)Commercial Corporation
DE_8808 (CDQ)Sonstige (de)Sonstige (de)Unknown
DE_8993 (CDQ)Betriebe der Gebietskörperschaften (de)BeG (de)Commercial Corporation
DE_9283 (CDQ)Gesellschaft mit beschränkter Haftung (de)GmbH (de)Private Limited Company
DE_9335 (CDQ)Weltanschauungs- und Religionsgemeinschaft (de)Government Body
DE_9398 (CDQ)Offene Handelsgesellschaft (de)OHG (de)Commercial Corporation
DE_9801 (CDQ)Gesellschaft bürgerlichen Rechts (de)GbR (de)Civil Law Partnership
DE_9802 (CDQ)eingetragene Gesellschaft bürgerlichen Rechts (de)Civil Law Partnership
DE_9866 (CDQ)Aktiengesellschaft (de)AG (de)Public Limited Company

Identifiers

IdentifierNameRegistration authority
DE_BNUM (DE - Business Reg. Number)Handelsregisternummer (de)
Business Registration Number (en)
DE_TAX_AUTHORITY_ID (DE - Tax auth. ID)Finanzbehörde-ID (de)
Tax authority ID (en)
DE_TAX_ID (DE - Tax identification number)Steuernummer (de)
Tax identification number (en)
DE_TAX_OFFICE_NUMBER (DE - Fed. Tax Office Nr)Bundesfinanzamtsnummer (de)
Federal Tax Office Number (en)
EU_VAT_ID_DE (DE - VAT identification number)Umsatzsteuer-Identifikationsnummer (de)
Value added tax identification number (en)
HRK_CDQ_ID ()Hochschulrektorenkonferenz number (de)
Identifier for German Rectors' Conference (en)
ZER_CDQ_ID ()Zuwendungsempfängerregister number (de)
Identifier for Register of Grant Recipients (en)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (DE)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/DE are the following: Regular expression/Mononumerical post code with delimeter
Regular expression/Not available 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 (Germany), 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 (Germany)INFO
Identifier Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Identifier Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Identifier format inaccurate (European value added tax identifier (Germany))This rule checks the syntax, i.e. format of the European value added tax identifier in Germany 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 Germany consists of exact 9 numerical digits prefixed by "DE". 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 (Business Registration Number (Germany))The format of the business registration number that this rule checks consists of the following components:
  • It starts with either "HRA" or "HRB," which represents the type of registration in the German Handelsregister.
  • An optional space may follow after the "HRA" or "HRB."
  • Next, there should be a sequence of 4, 5, or 6 numeric digits.
  • After the numeric digits, there may be an optional space followed by a single alphabetic character.
  • Following the Handelsregisternummer, there can be additional words, each composed of alphabetic characters, separated by whitespace. This is to allow components such as "Amtsgericht München"
INFO
Identifier format invalid (European value added tax identifier (Germany))The European value added tax identifier in Germany consists of exact 9 numerical digits prefixed by "DE". This rule checks the existence of exact 9 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 format invalid (Tax identification number (Germany))The format of the German Steuernummer can vary depending on the tax office and the individual's circumstances. However, a general format for the Steuernummer in Germany is as follows: XX/XXX/XXXXX

Explanation of the format: The Steuernummer consists of three parts separated by slashes. The first part (XX) represents the two-digit identifier for the federal state tax office. The second part (XXX) represents the three-digit identifier for the district tax office. The third part (XXXXX) represents the individual's unique five-digit identification number within the tax office.

The length of the tax number varies between 10 and 11 digits in the standard scheme of the countries. The federal scheme standardizes this to 13 digits. (F)FF represents the last two or three digits of the four-digit federal tax office number (BUFA number). In addition, BBB(B) stands for the district number within the area of the respective tax office. In North Rhine-Westphalia it is 4 digits, otherwise 3 digits. (U)UUU is the personal distinction number. In North Rhine-Westphalia it is 3 digits, otherwise 4 digits. P is a single-digit check digit . If a 13-digit tax number is required for electronic transmission, a 0 must be inserted between the 4th and 5th digits.		INFO
Identifier missing (Business Registration Number (Germany))Business partners in Germany should have a business registration number maintained.INFO
Identifier missing (European value added tax identifier (Germany))Each legal entity in Germany should have a European value added tax identifier.WARNING
Identifier unknown (European value added tax identifier (Germany))European value added tax identifier (Germany)ERROR
Invalid checksum of EU VAT ID DE (Germany)This rule checks the checksum of the European VAT number in Germany. An interactive procedure involving each of the digits C1…C8 in turn used to calculate C9.

P = 10

For N = 1…8 (N = character position i.e. C1)

  • S = CN + P
  • M = S modulo 10
  • If M = 0 then M = 10
  • P = (2 *M) modulo 11

R = 11 – P

If R = 10

then: C9 = 0

else: C9 =R		ERROR
Legal form invalid (Germany)Each record should have legal form appropriate for the country.INFO
Length of domestic bank account Id invalid (Germany)This rule checks whether the domestic bank account id exceeds the maximum possible length in GermanyERROR
Length of national bank Id invalid (Germany)This rule checks whether the domestic bank id exceeds the maximum possible length in GermanyERROR
Locality Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Locality Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Locality Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Mandatory administrative area missing (Germany)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 GermanyINFO
Mandatory locality missing (Germany)The locality is mandatory for street addresses in Germany.ERROR
Mandatory post code missing (Germany)The post code is mandatory for street addresses in Germany.ERROR
Mandatory thoroughfare missing (Germany)The thoroughfare is mandatory for street addresses in Germany.ERROR
Name Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Name Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Name Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Post code Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Post code Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Post code Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Post code format invalid (Germany)Postal codes in Germany, Postleitzahl (plural Postleitzahlen, abbreviated to PLZ
literally "postal routing number"), since 1 July 1993 consist of five digits. The first two digits indicate the wider area, the last three digits the postal district.		ERROR
Thoroughfare Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Thoroughfare Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Thoroughfare Qualification (European value added tax identifier (Germany), 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 (Germany)INFO
Unallowed pattern detected test caseINFO
Unallowed pattern detected test case 2INFO
Unallowed pattern in name detected (DE)This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/DE 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 .		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
[[DE.RC (data source)]]
German Commercial Register
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		Registered companies, cooperatives, and partnerships in all federal states in Germany. LIVE
3,068,838 records
[[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
[[DE.GCB (data source)]]
DE Bank Data
[[BANK_ACCOUNT]]A fatal error occurred in the #info parser function 		DE Bank Data BETA
0 records
[[DE.GEMFA (data source)]]
GemFA
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		Information about German local tax offices (Finanzämter) BETA
593 records
[[DE.HRK (data source)]]
HRK
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		All German universities as provided by the German "Hochschulrektorenkonferenz" BETA
425 records
[[DE.ZER (data source)]]
ZER
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		All tax exempted organisations such as gemeinnützige Vereine from the Bundeszentralamt für Steuern in Germany BETA
549,333 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
[[DE.PD (data source)]]
Deutsche Post - Post Direkt (Germany)
[[ADDRESS]]A fatal error occurred in the #info parser function 		n/a IDEA
[[DE.POST (data source)]]
Deutsche Post
[[ADDRESS]]A fatal error occurred in the #info parser function 		n/a 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 Germany
Local name of the national bank ID. Bank ID name Bankleitzahl (BLZ)
The provider (national authorities in most cases) of the national bank ID. Bank ID provider Deutsche Bundesbank
Currency code for accounting in the given country. Currency code EUR
Maximum length of the national bank ID. Maximum bank ID length 8
Maximum length of the national bank account ID. Maximum bank account ID length 10
Retrieved from "https://meta.cdq.com/w/index.php?title=DataModel:CDQ/Business_Partner/Address/Country/DE&oldid=180744"