RO (Romania)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/RO
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 RO
Language-specific name. Monolingual name România (ro), Roumanie (fr), 羅馬尼亞 (zh), Romania (en), Rumänien (de)
Language-specific short name. Monolingual short name Rumänien (de), Romania (en), România (ro), 罗马尼亚 (zh), Roumanie (fr)
The offical langauge of a country. Official language ro
Language used in a country, beside the administrative languages. other language ro
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
RO-AB (Alba) RO-AB Alba (en), Alba (fr), Alba (ro), Kreis Alba (de), 阿爾巴縣 (zh)
RO-AG (Arges) RO-AG Arges (en), Argeș (fr), Argeș (ro), Kreis Argeș (de), 阿爾傑什縣 (zh)
RO-AR (Arad County) RO-AR Arad (fr), Arad (ro), Arad County (en), Kreis Arad (de), 阿拉德縣 (zh)
RO-B (Bucharest) RO-B Bucarest (fr), Bucharest (en), București (ro), Bukarest (de), 布加勒斯特 (zh)
RO-BC (Bacău County) RO-BC Bacău (fr), Bacău (ro), Bacău County (en), Kreis Bacău (de), 巴克烏縣 (zh)
RO-BH (Bihor County) RO-BH Bihor (fr), Bihor (ro), Bihor County (en), Kreis Bihor (de), 比霍爾縣 (zh)
RO-BN (Bistrița-Năsăud County) RO-BN Bistrița-Năsăud (fr), Bistrița-Năsăud (ro), Bistrița-Năsăud County (en), Kreis Bistrița-Năsăud (de), 比斯特里察-訥瑟烏德縣 (zh)
RO-BR (Brăila) RO-BR Brăila (en), Brăila (fr), Brăila (ro), Kreis Brăila (de), 布勒伊拉縣 (zh)
RO-BT (Botoșani County) RO-BT Botoșani (fr), Botoșani (ro), Botoșani County (en), Kreis Botoșani (de), 博托沙尼縣 (zh)
RO-BV (Brașov County) RO-BV Brașov (fr), Brașov (ro), Brașov County (en), Kreis Brașov (de), 布拉索夫縣 (zh)
RO-BZ (Buzău County) RO-BZ Buzău (fr), Buzău (ro), Buzău County (en), Kreis Buzău (de), 布澤烏縣 (zh)
RO-CJ (Cluj County) RO-CJ Cluj (fr), Cluj (ro), Cluj County (en), Kreis Cluj (de), 克魯日縣 (zh)
RO-CL (Călărași County) RO-CL Călărași (fr), Călărași (ro), Călărași County (en), Kreis Călărași (de), 克勒拉希縣 (zh)
RO-CS (Caraș-Severin County) RO-CS Caraș-Severin (fr), Caraș-Severin (ro), Caraș-Severin County (en), Kreis Caraș-Severin (de), 卡拉什-塞維林縣 (zh)
RO-CT (Constanța County) RO-CT Constanța (fr), Constanța (ro), Constanța County (en), Kreis Constanța (de), 康斯坦察縣 (zh)
RO-CV (Covasna County) RO-CV Covasna (fr), Covasna (ro), Covasna County (en), Kreis Covasna (de), 科瓦斯納縣 (zh)
RO-DB (Dâmbovița County) RO-DB Dâmbovița (fr), Dâmbovița (ro), Dâmbovița County (en), Kreis Dâmbovița (de), 登博維察縣 (zh)
RO-DJ (Dolj County) RO-DJ Dolj (fr), Dolj (ro), Dolj County (en), Kreis Dolj (de), 多爾日縣 (zh)
RO-GJ (Gorj County) RO-GJ Gorj (fr), Gorj (ro), Gorj County (en), Kreis Gorj (de), 戈爾日縣 (zh)
RO-GL (Galați County) RO-GL Galați (fr), Galați (ro), Galați County (en), Kreis Galați (de), 加拉茨縣 (zh)
RO-GR (Giurgiu County) RO-GR Giurgiu (fr), Giurgiu (ro), Giurgiu County (en), Kreis Giurgiu (de), 久爾久縣 (zh)
RO-HD (Hunedoara County) RO-HD Hunedoara (de), Hunedoara (fr), Hunedoara (ro), Hunedoara County (en), 胡內多阿拉縣 (zh)
RO-HR (Harghita County) RO-HR Harghita (fr), Harghita (ro), Harghita County (en), Kreis Harghita (de), 哈爾吉塔縣 (zh)
RO-IF (Ilfov County) RO-IF Ilfov (fr), Ilfov (ro), Ilfov County (en), Kreis Ilfov (de), 伊爾福夫縣 (zh)
RO-IL (Ialomița County) RO-IL Ialomița (fr), Ialomița (ro), Ialomița County (en), Kreis Ialomița (de), 雅洛米察縣 (zh)
RO-IS (Iași County) RO-IS Iași (fr), Iași (ro), Iași County (en), Kreis Iași (de), 雅西縣 (zh)
RO-MH (Mehedinți County) RO-MH Kreis Mehedinți (de), Mehedinți (fr), Mehedinți (ro), Mehedinți County (en), 梅赫丁茨縣 (zh)
RO-MM (Maramureș County) RO-MM Kreis Maramureș (de), Maramureș (fr), Maramureș (ro), Maramureș County (en), 馬拉穆列什縣 (zh)
RO-MS (Mureș County) RO-MS Kreis Mureș (de), Mureș (fr), Mureș (ro), Mureș County (en), 穆列什縣 (zh)
RO-NT (Neamț County) RO-NT Kreis Neamț (de), Neamț (fr), Neamț (ro), Neamț County (en), 尼亞姆茨縣 (zh)
RO-OT (Olt County) RO-OT Kreis Olt (de), Olt (fr), Olt (ro), Olt County (en), 奧爾特縣 (zh)
RO-PH (Prahova County) RO-PH Kreis Prahova (de), Prahova (fr), Prahova (ro), Prahova County (en), 普拉霍瓦縣 (zh)
RO-SB (Sibiu County) RO-SB Kreis Sibiu (de), Sibiu (fr), Sibiu (ro), Sibiu County (en), 錫比烏縣 (zh)
RO-SJ (Sălaj County) RO-SJ Kreis Sălaj (de), Sălaj (fr), Sălaj (ro), Sălaj County (en), 瑟拉日縣 (zh)
RO-SM (Satu Mare County) RO-SM Kreis Satu Mare (de), Satu Mare (fr), Satu Mare (ro), Satu Mare County (en), 薩圖馬雷縣 (zh)
RO-SV (Suceava County) RO-SV Kreis Suceava (de), Suceava (fr), Suceava (ro), Suceava County (en), 蘇恰瓦縣 (zh)
RO-TL (Tulcea County) RO-TL Kreis Tulcea (de), Tulcea (fr), Tulcea (ro), Tulcea County (en), 圖爾恰縣 (zh)
RO-TM (Timiș County) RO-TM Kreis Timiș (de), Timiș (fr), Timiș (ro), Timiș County (en), 蒂米什縣 (zh)
RO-TR (Teleorman County) RO-TR Kreis Teleorman (de), Teleorman (fr), Teleorman (ro), Teleorman County (en), 特列奧爾曼縣 (zh)
RO-VL (Vâlcea County) RO-VL Kreis Vâlcea (de), Vâlcea (fr), Vâlcea (ro), Vâlcea County (en), 沃爾恰縣 (zh)
RO-VN (Vrancea County) RO-VN Kreis Vrancea (de), Vrancea (fr), Vrancea (ro), Vrancea County (en), 弗朗恰縣 (zh)
RO-VS (Vaslui County) RO-VS Kreis Vaslui (de), Vaslui (fr), Vaslui (ro), Vaslui County (en), 瓦斯盧伊縣 (zh)

Legal forms

Legal formELF codeNameMain abbreviation
RO_0145Societate în nume colectiv (ro)S.N.C. (ro)
RO_0349Persoana fizica autorizata (ro)PFA (ro)
RO_1182Societas Cooperativa Europaea (ro)SCE (ro)
RO_2716Persoana fizica independentă (ro)PFI (ro)
RO_3219European Economic Interest Grouping (ro)EEIG (ro)
RO_3641Intreprindere individuala (ro)II (ro)
RO_5022Anonymous Society (ro)SA (ro)
RO_5610Societate cu răspundere limitată (ro)S.R.L (ro)
RO_6383Societate în comandită pe acţiuni (ro)S.C.A. (ro)
RO_6574Societas Europaea (ro)SE (ro)
RO_7001Societate pe acţiuni (ro)SA  (ro)
RO_7320Organizație Non-Guvernamentală (ro)O.N.G (ro)
RO_7541Grupul european de interes economic (ro)GEIE (ro)
RO_8260Persoana fizica autorizata (ro)PFA (ro)
RO_8441Societate pe Acţiun (ro)S.A. (ro)
RO_8540Grupul de interes economic (ro)GIE (ro)
RO_8897Societate în comandită simplă (ro)S.C.S. (ro)
RO_9387Regie autonomă (ro)RA (ro)

Identifiers

IdentifierNameRegistration authority
EU_VAT_ID_RO (Value added tax identification number)axa pe Valoarea Adăugată (ro)
Value added tax identification number (en)
Romanian Ministry of Finance
FRC_RO (Fiscal Registration Code)Fiscal Registration Code (ro)
Fiscal Registration Code (en)
Romanian Tax Administration
RO_BRN (Business Registration Number)Business Registration Number (ro)
Business Registration Number (en)
RO_CCN (Chamber of Commerce Number)Camera de Comert si Industrie a Romaniei (ro)
Chamber of Commerce Number (en)
RO_GGN (Government Gazette Number)Monitorul Oficial al României (ro)
Government Gazette Number (en)
The Official Government Gazette of Romania
RO_TAX_ID (Personal Numerical Code)Cod Numeric Personal (ro)
Personal Numerical Code (en)
Romanian Authority
TRN_RO (Trade register number)Trade register number (ro)
Trade register number (en)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (RO)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.
This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for RO (Romania) are the following: Regular expression/Mononumerical post code with delimeter
ERROR
Identifier Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Identifier Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Identifier Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Identifier checkdigit invalid (Tax number (Romania))This rule checks the checksum of the Tax number in Romania.

To calculate the checksum digit, every digit from CNP is multiplied with the corresponding digit in number 279146358279
the sum of all these multiplications is then divided by 11.

If the remainder is 10 then the checksum digit is 1, otherwise it's the remainder itself.

Any difference result in a rule violation.
ERROR
Identifier format inaccurate (European value added tax identifier (Romania))This rule checks the syntax, i.e. format of the European value added tax identifier in Romania 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 Romania consists of 2-10 numerical digits prefixed by "RO". 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 inaccurate (Tax number (Romania))Tax number in Romania consists of 13 digits. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, dots or hyphens then the rule is violated. This rule checks the syntax, i.e. format of the Tax number (Romania) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.INFO
Identifier format invalid (European value added tax identifier (Romania))The European value added tax identifier in Romania consists of 2-10 numerical digits prefixed by "RO". This rule checks the presence of 2-10 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 (Fiscal Registration Code (Romania))Fiscal Registration Code (Romania) is a VAT registration certificate and is granted by the Ministry of Public Finances. Fiscal Registration Code is the VAT number without the check digit. Note that if the length is less than 9 digits, leading zeros must be assumed This rule checks presence of exactly 9 characters corresponding to the format of the Fiscal Registration Code (Romania) 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.ERROR
Identifier format invalid (Tax number (Romania))Tax number (Romania) is a unique identification code for each citizen. This rule checks the identifier's format wiht respect to the following restrictions:

1) lenth of the identifier should be exactly 13 digits
2) first digit cannot be zero
3) 4th and 5th digits should be in a range [01:12]
4) 6th i 7th digits shouldbe in arange [01:31]
5) 8th and 9th digits should be in a range [01:52] or 99.

Violation of the above mentioned restrictions without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value result in arue violation.
ERROR
Identifier missing (European value added tax identifier (Romania))Each legal entity in Romania should have a European value added tax identifier.WARNING
Identifier unknown (European value added tax identifier (Romania))European value added tax identifier (Romania)ERROR
Identifier unknown (Fiscal Registration Code (Romania))This rule checks whether the Fiscal Registration Code (Romania) is really existing by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated.ERROR
Inconsistency between Fiscal Registration Code and EU VAT ID RO (Romania)European value added tax identifier (Romania) consists of prefix "RO" and 9 digits which are equal to the Fiscal Registration Code (Romania) and a checksum digit. This rules check if the Fiscal Registration Code (Romania) is equal to the 9 digits in EU VAT RO identifier.

Note that if the length of theFiscal Registration Codes is less than 9 digits or European value added tax identifier (Romania) has less the 10 digits, leading zeros must be assumed.

Any difference result in a rule violation.
ERROR
Invalid checksum of EU VAT ID RO (Romania)This rule checks the checksum of the European VAT number in Romania. Note that if the length is less than 10 digits, leading zeros must be assumed to perform the computation.

Checksum validation logic:

  • A1 = C1*7 + C2*5 + C3*3 + C4*2 + C5*1 + C6*7 + C7*5 + C8*3 + C9*2
  • A2 = A1 * 10
  • R1 = A2 modulo 11
  • If R1 = 10, then R = 0
    • Else R = R1
  • C10 = R
ERROR
Legal form invalid (Romania)Each record should have legal form appropriate for the country.INFO
Length of domestic bank account Id invalid (Romania)This rule checks whether the domestic bank account id exceeds the maximum possible length in RomaniaERROR
Locality Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Locality Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Locality Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Mandatory administrative area missing (Romania)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 RomaniaINFO
Mandatory locality missing (Romania)The locality is mandatory for street addresses in Romania.ERROR
Mandatory post code missing (Romania)The post code is mandatory for street addresses in Romania.ERROR
Mandatory thoroughfare missing (Romania)The thoroughfare is mandatory for street addresses in Romania.ERROR
Name Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Name Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Name Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Post code Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Post code Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Post code Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Post code format invalid (Romania)This rule checks the post code format of Romania. This is cod poştal in Romanian. Romania introduced a new postal code system on 1st May 2003. All new postal codes have 6 digits, commencing with any number between 0 and 9. The first digit indicates one of 10 postal regions, the second number indicates a smaller district. Most postal regions have no more than five districts, with the exception of Bucharest which has 8. The second digit can have a value between 0 and 8. The final 4 digits indicates a district, town, rural locality, street, part of a street or building. If the third digit is a 0 it indicates a residence within a district. The third digits 1-4 indicate a locality with more than 50000 inhabitants. Third digits 5-6 are for other urban localities. Third digit 7 is for rural areas.The postal code format is NNNNNN.ERROR
Thoroughfare Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Thoroughfare Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Thoroughfare Qualification (European value added tax identifier (Romania), 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 (Romania)INFO
Unallowed pattern in name detected (RO)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 .
This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for RO (Romania) are the following: Regular expression/One time vendor
WARNING

Data sources

Data quality ruleNameContent
AT.FON (data source)FinanzOnline Austria (en)BUSINESS_PARTNER
BZST (data source)Federal Central Tax Office (Germany) (en)
Bundeszentralamt für Steuern (Germany) (en)
BUSINESS_PARTNER
CDQ.VAT (data source)CDQ European VAT Registration Database (en)BUSINESS_PARTNER
EU.EORI (data source)Economic Operator Identification and Registration Database (en)BUSINESS_PARTNER
EU.PC (data source)EuroStat Post Code Files (European Union) (en)ADDRESS
RO.TR (data source)Registrul Comertului (en)BUSINESS_PARTNER
VIES (data source)VAT Information Exchange System (en)BUSINESS_PARTNER

Banking metadata

Property Value
Full metadata Bank accounts in Romania
Local name of the national bank ID. Bank ID name BIC4
The provider (national authorities in most cases) of the national bank ID. Bank ID provider SWIFT
Currency code for accounting in the given country. Currency code RON
Maximum length of the national bank account ID. Maximum bank account ID length 16