DE_BNUM (DE - Business Reg. Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/DE BNUM
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key DE_BNUM
The country a linked concept is active or generally relevant for. Country scope DE (Germany)
Language-specific name. Monolingual name Handelsregisternummer (de), Business Registration Number (en)
Language-specific short name. Monolingual short name DE - Business Reg. Number (en)
Informal and comprehensive human-readable definition of a concept. Description The Handelsregisternummer or simply Registernummer is the unique number given to each company listed in the German Trade Register, the Handelsregister. Most German companies must be listed in the Handelsregister, with the exception of freelancers, small businesses with low sales revenue and companies constituted under civil law (Gesellschaft bürgerlichen Rechts).

The Handelsregisternummer usually has the HR_ 12345 format, followed by the district court (Amtsgericht) where the company is registered.

Here are a few examples of Handelsregisternummern:

  • N26 bank: HRB 151080 B, Charlottenburg
  • Coup: HRB 178881 B, Charlottenburg
  • SAP: HRA 350654, Mannheim

Overall format:

  • [HRA/HRB] 123456789 + optional letter for district court

...where whitespaces don't matter

Category of business identifiers. Identifier category Identification Number

Formal definition

Details Informal and comprehensive human-readable definition of a concept. Description The type in terms of a categorization of regular expressions. Regular expression type TThe formal expression of a regular expression. Regular expression
0000000000Y7JJCGSQQJD9M42H Specifies the allowed formats for the Business Registration Number (Germany) IDENTIFIER_FORMAT
^(?i)(?:HRA|HRB|GnR|PR|VR|GsR)\s?\d{2,6}(\s?[A-Z])?(?:\s+[A-Z]+)*$

Data quality rules

Rule Informal and comprehensive human-readable definition of a concept. 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 Criticality<br/>Specifies how critical of the violation of a data quality rule.<br/>ERROR: Indicates a critical data quality rule violation that requires correction.<br/>WARNING: Indicates a potential data quality issue that should be reviewed.<br/>INFO: Indicates an informational finding with no immediate impact on data quality. Criticality
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"
RELEASED INFO
Identifier missing (Business Registration Number (Germany)) Business partners in Germany should have a business registration number maintained. RELEASED INFO