BE_ENT_NO (BE - Enterprise number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/BE ENT NO
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key BE_ENT_NO
The country a linked concept is active or generally relevant for. Country scope BE (Belgium)
Language-specific name. Monolingual name Enterprise number (nl), Enterprise number (de), Enterprise number (fr), Enterprise number (en)
Language-specific short name. Monolingual short name BE - Enterprise number (en)
Informal and comprehensive human-readable definition of a concept. Description The National Number (or Association Number, Company Number or Unique Establishment Number) is a unique code given by the Belgian government, according to the law of 24.6.2003. The National Number has 10 digits without any space. If is has only 9 digits, zero should be added before the number.
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1

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
0000000000E8AW6E7QNGA04977 Specifies the allowed formats for the Enterprise number (Belgium) IDENTIFIER_FORMAT
^(\s*?\.*?-*?)(\d\s*\.*-*){10}$

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
Business partner is inactive (Belgium) The rule checks whether a given company is known to be inactive by means of the business register in Belgium. The rule searches the register by a given Enterprise number (Belgium) and evaluates whether the status of the company is different from active. IDEA INFO
Identifier format inaccurate (Enterprise number (Belgium)) This rule checks the syntax, i.e. format of the Enterprise number in Belgium with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

The Enterprise number (Belgium) consists of 10 digits without any whitespaces. 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.

IDEA INFO
Identifier format invalid (Enterprise number (Belgium)) The Enterprise Number (or Association Number, National Number, Company Number or Unique Establishment Number) is a unique code given by the Belgian government.

This rule checks presence of exactly 10 digits and prefix without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits, unexpected non-digits characters then the rule is violated.

RELEASED INFO
Identifier unknown (Enterprise number (Belgium)) This business rule checks the existence of the Enterprise number (Belgium) in the KBO Central Belgium Company Database. RELEASED ERROR
Inconsistency between Enterprise number and European value added tax identifier (Belgium) The EU VAT equals the Enterprise number prefixed by BE. But it is to be checked whether the resulting VAT is really existing via VIES. Not all companies require a VAT. This rules check if the belgian Enterprise number is equal to the 10 digits of EU_VAT_ID_BE.

Any difference result in a rule violation.

RELEASED ERROR