AD (Andorra)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/AD
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 AD
Language-specific name. Monolingual name 安道尔 (zh), Andorra (ca), Andorra (en), Andorre (fr), Andorra (de)
Language-specific short name. Monolingual short name Andorra (de), Andorra (en), Andorre (fr), 安道尔 (zh)
The offical langauge of a country. Official language ca
Language used in a country, beside the administrative languages. other language ca
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 Language-specific alternative, i.e. non-official, name. Alternative name
AD-02 (Canillo) AD-02 Canillo (ca), Canillo (de), Canillo (en), Canillo (fr), 卡尼略 (zh)
AD-03 (Encamp) AD-03 Encamp (ca), Encamp (de), Encamp (en), Encamp (fr), 恩坎普 (zh)
AD-04 (La Massana) AD-04 La Massana (de), La Massana (en), La Massana (fr), la Massana (ca), 马萨纳 (zh)
AD-05 (Ordino) AD-05 Ordino (ca), Ordino (de), Ordino (en), Ordino (fr), 奥尔迪诺 (zh)
AD-06 (Sant Julià de Lòria) AD-06 Sant Julià de Lòria (ca), Sant Julià de Lòria (de), Sant Julià de Lòria (en), Sant Julià de Lòria (fr), 圣胡利娅-德洛里亚 (zh)
AD-07 (Andorra la Vella) AD-07 Andorra la Vella (ca), Andorra la Vella (en)
AD-08 (Escaldes-Engordany) AD-08 Escaldes-Engordany (ca), Escaldes-Engordany (de), Escaldes-Engordany (en), Escaldes-Engordany (fr), 萊塞斯卡爾德-恩戈爾達 (zh)

Legal forms

No legal forms maintained for Andorra.

Identifiers

IdentifierNameRegistration authority
AD_FI_CODE (AD - Andorra Fiscal Code)Número de Registre Tributari (ca)
Andorra Fiscal Code (en)

Data quality rules

Data quality ruleDescriptionCriticality
Data Quality Rule/1X85D78XEYQ6F1KAThis rule checks whether the domestic bank account id exceeds the maximum possible length in AndorraERROR
Data Quality Rule/3ETTP6B7WJD2PEKKThe thoroughfare is mandatory for street addresses in Andorra.ERROR
Data Quality Rule/A8T3W53DA1G8BS3TThis rule checks whether the domestic bank id exceeds the maximum possible length in AndorraERROR
Data Quality Rule/NMP5D5ADV6X5SSRSThe post code is mandatory for street addresses in Andorra.ERROR
Data Quality Rule/Q1C15ZCFKB41FGAZThe administrative area (a top-level geographical or political area division in a country) is required (i.e. mandatory) for a complete physical touchpoint in AndorraINFO
Data Quality Rule/Q8DERZ17WHQAPPQPThe locality is mandatory for street addresses in Andorra.ERROR
Data Quality Rule/SS1DCEWNX7QQEWVAThis data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/AD are the following: Regular expression/One time vendor
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 .
WARNING
Data Quality Rule/WW1AM86C1KYGZXAYAndorra introduced a postal code in July 2004 with the format: [AD]999 The first number can be in the range 1-7.ERROR
Data Quality Rule/Y9HNMTFBRT8C4NQAThis data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/AD are the following: Regular expression/Mononumerical post code with delimeter
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.
ERROR

Data sources

No data sources maintained for Andorra.

Banking metadata

Property Value
Full metadata Bank accounts in Andorra
Local name of the national bank ID. Bank ID name Codificació de les oficines bancàries
The provider (national authorities in most cases) of the national bank ID. Bank ID provider Associacio de Bancs Andorrans
Currency code for accounting in the given country. Currency code EUR
Maximum length of the national bank ID. Maximum bank ID length 8
Maximum length of the national bank account ID. Maximum bank account ID length 12