CDQ Data Quality as Service
Idea Portal
Idea Portal
Idea Portal
TH - TH_TAX_ID Identifier missing / ERROR
HR - Inconsistency between HR_OIB and EU_VAT_ID_HR / WARNING
EU_VAT_ID_HR consists of HR_OIB with HR-Prefix!
OIB number corresponding to VAT number without HR letters. Has to be mandatory, so the rule category would be identifier missing and then rule name Identifier missing (OIB number Croatia) HR1 tax number field is related to the OIB and OIB is VAT without HR
The Personal identification number (Croatian: Osobni identifikacijski broj or OIB) is a permanent national identification number of every Croatian citizen and legal persons domiciled in the Republic of Croatia.
SV - New Identifier SV_NIT
the "Número de Identificación Tributaria," which is the Tax Identification Number in the country. This number is also known as the Número de Identificación Fiscal (NIF) or Número de Registro Tributario (NRT).The format of the NIT in El Salvador is 14 characters long and usually includes a combination of letters and numbers. It is used for tax purposes and identification in various official and financial transactions in El Salvador.
SV- Identifier SV_NIT missing / ERROR
SV- Identifier SV_NIT format check: / WARNING
the standard format for a NIT in El Salvador is
xxxx-xxxxxx-xxx-x. This format includes 14 digits in total, divided into four groups separated by hyphens.
SA - Identifier missing SA_VAT / ERROR
KE - New Identifier KE_VAT
KE- Identifier KE_VAT missing / WARNING
KE - KE_VAT (STCD1) - Format Check / WARNING
11 alphanumeric characters example: P999999999A
US - Activate the Rules for "US_SEC_ID" https://meta.cdq.com/Social_security_number_(United_States)
IN - IN_GST - Format Check has to been updated:
https://meta.cdq.com/Identifier_format_invalid_(GST_number_(India))
Region 25 is not existing anymore and has been merged to "26"
-> Daman and Diu : 25 and ** Dadra & Nagar Haveli: 26 now merged into single Union Territory called **Dadra & Nagar Haveli and Daman and Diu (Newly Merged UT):26
+ there are now 3 new Regions available:
We added 3 new items, as below highlighted in yellow (38, 97 and 99)
38: Ladakh
97: other Territory
99: Centre Juristiction
Onur Dinc
We are closing this idea ticket, US and HR ideas were separated:
For Croatia please see this idea: https://cdqag.aha.io/ideas/ideas/IPOC-I-469
For checks of the Social Security Number in US, please refer to this idea: https://cdqag.aha.io/ideas/ideas/IPOC-I-470
For India the adjustments were delivered here
For Thailand the following was introduced:
The Thai Personal ID is a 13-digit number. Personal IDs are always 13 digits long, while company Tax IDs are 10 digits long. For individuals, the Tax ID usually matches their Personal ID, meaning it is also a 13-digit number. However, for companies, it is a 10-digit number. The Personal-ID format is structed as:
We now support checks for both identifier types explicitly.
For the Personal ID and Tax ID the following checks were introduced
Mandatory identifier missing
For the Personal ID
Identifier format invalid
For the Tax ID
The identifier format check was adjusted to just allow the 10 digits for companies
The identifier missing rule was adjusted to the criticality INFO by default as it is superseded by the Mandatory identifier missing rule
Attachments Open full size
Thailand:
https://meta.cdq.com/Identifier_missing_(Tax_ID_(Thailand))
Attachments Open full size
Kenya:
https://meta.cdq.com/VAT_Registration_Number_(Kenya)
https://meta.cdq.com/Identifier_missing_(VAT_Registration_Number_(Kenya))
Attachments Open full size
Saudi Arabia:
https://meta.cdq.com/Identifier_missing_(VAT_Registration_Number_(Saudi_Arabia))
Attachments Open full size
El Salvador now supported
https://meta.cdq.com/Identifier_missing_(Tax_Identification_Number_(El_Salvador))
https://meta.cdq.com/Regular_expression/SV_NIT/format
https://meta.cdq.com/Identifier_format_invalid_(Tax_Identification_Number_(El_Salvador))
Attachments Open full size
For Croatia please see this idea: https://cdqag.aha.io/ideas/ideas/IPOC-I-469
For checks of the Social Security Number in US, please refer to this idea: https://cdqag.aha.io/ideas/ideas/IPOC-I-470
Attachments Open full size