DE_TAX_ID (DE - Tax identification number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/DE TAX ID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key DE_TAX_ID
The country a linked concept is active or generally relevant for. Country scope DE (Germany)
Language-specific name. Monolingual name Steuernummer (de), Tax identification number (en)
Language-specific short name. Monolingual short name DE - Tax identification number (en)
Informal and comprehensive human-readable definition of a concept. Description Unique identifier that is assigned by German fiscal authorities to each German citizen and each business which operates in Germany. See German Wikipedia for more information. The Steuernummer is different to the German Umsatzsteuer-Identifikationsnummer which is assigned for value added tax purposes and which is regulated by the German Wikipedia.
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STENR

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
00000000007Q4VF3WRPW8DYF09 Specifies the allowed formats for the Tax identification number (Germany) IDENTIFIER_FORMAT
^(((11|21|22|23|24|26|27|28)?\d{2}[\s\.\/\\-]?0?\d{3}[\s\.\/\\-]?\d{5})|([1349]?\d{3}[\s\.\/\\-]?0?\d{3}[\s\.\/\\-]?\d{5})|(5?\d{3}[\s\.\/\\-]?0?\d{4}[\s\.\/\\-]?\d{4}))$

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 (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.

RELEASED INFO