MT (Malta)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/MT
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 MT
Language-specific name. Monolingual name Malta (de), 马耳他 (zh), Malte (fr), Malta (en), Malta (mt)
Language-specific short name. Monolingual short name Malte (fr), Malta (de), Malta (en), 马耳他 (zh)
The offical langauge of a country. Official language mt, en
Language used in a country, beside the administrative languages. other language mt, en
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
MT-01 (Attard) MT-01 Attard (en)
MT-02 (Balzan) MT-02 Balzan (en)
MT-03 (Birgu) MT-03 Birgu (en)
MT-04 (Birkirkara) MT-04 Birkirkara (en)
MT-05 (Birzebbuga) MT-05 Birzebbuga (en)
MT-06 (Bormla) MT-06 Bormla (en)
MT-07 (Dingli) MT-07 Dingli (en)
MT-08 (Fgura) MT-08 Fgura (en)
MT-09 (Floriana) MT-09 Floriana (en)
MT-10 (Fontana) MT-10 Fontana (en)
MT-11 (Gudja) MT-11 Gudja (en)
MT-12 (Gzira) MT-12 Gzira (en)
MT-13 (Ghajnsielem) MT-13 Ghajnsielem (en)
MT-14 (Gharb) MT-14 Gharb (en)
MT-15 (Gharghur) MT-15 Gharghur (en)
MT-16 (Ghasri) MT-16 Ghasri (en)
MT-17 (Ghaxaq) MT-17 Ghaxaq (en)
MT-18 (Hamrun) MT-18 Hamrun (en)
MT-19 (Iklin) MT-19 Iklin (en)
MT-20 (Isla) MT-20 Isla (en)
MT-21 (Kalkara) MT-21 Kalkara (en)
MT-22 (Kercem) MT-22 Kercem (en)
MT-23 (Kirkop) MT-23 Kirkop (en)
MT-24 (Lija) MT-24 Lija (en)
MT-25 (Luqa) MT-25 Luqa (en)
MT-26 (Marsa) MT-26 Marsa (en)
MT-27 (Marsaskala) MT-27 Marsaskala (en)
MT-28 (Marsaxlokk) MT-28 Marsaxlokk (en)
MT-29 (Mdina) MT-29 Mdina (en)
MT-30 (Mellieha) MT-30 Mellieha (en)
MT-31 (Mgarr) MT-31 Mgarr (en)
MT-32 (Mosta) MT-32 Mosta (en)
MT-33 (Mqabba) MT-33 Mqabba (en)
MT-34 (Msida) MT-34 Msida (en)
MT-35 (Mtarfa) MT-35 Mtarfa (en)
MT-36 (Munxar) MT-36 Munxar (en)
MT-37 (Nadur) MT-37 Nadur (en)
MT-38 (Naxxar) MT-38 Naxxar (en)
MT-39 (Paola) MT-39 Paola (en)
MT-40 (Pembroke) MT-40 Pembroke (en)
MT-41 (Pietà) MT-41 Pietà (en)
MT-42 (Qala) MT-42 Qala (en)
MT-43 (Qormi) MT-43 Qormi (en)
MT-44 (Qrendi) MT-44 Qrendi (en)
MT-45 (Rabat Gozo) MT-45 Rabat Gozo (en)
MT-46 (Rabat Malta) MT-46 Rabat Malta (en)
MT-47 (Safi) MT-47 Safi (en)
MT-48 (Saint Julian's) MT-48 Saint Julian's (en)
MT-49 (Saint John) MT-49 Saint John (en)
MT-50 (Saint Lawrence) MT-50 Saint Lawrence (en)
MT-51 (Saint Paul's Bay) MT-51 Saint Paul's Bay (en)
MT-52 (Sannat) MT-52 Sannat (en)
MT-53 (Saint Lucia's) MT-53 Saint Lucia's (en)
MT-54 (Santa Venera) MT-54 Santa Venera (en)
MT-55 (Siggiewi) MT-55 Siggiewi (en)
MT-56 (Sliema) MT-56 Sliema (en)
MT-57 (Swieqi) MT-57 Swieqi (en)
MT-58 (Ta' Xbiex) MT-58 Ta' Xbiex (en)
MT-59 (Tarxien) MT-59 Tarxien (en)
MT-60 (Valletta) MT-60 Valletta (en)
MT-61 (Xaghra) MT-61 Xaghra (en)
MT-62 (Xewkija) MT-62 Xewkija (en)
MT-63 (Xghajra) MT-63 Xghajra (en)
MT-64 (Zabbar) MT-64 Zabbar (en)
MT-65 (Zebbug Gozo) MT-65 Zebbug Gozo (en)
MT-66 (Zebbug Malta) MT-66 Zebbug Malta (en)
MT-67 (Zejtun) MT-67 Zejtun (en)
MT-68 (Zurrieq) MT-68 Zurrieq (en)

Legal forms

Legal formELF codeNameMain abbreviation
MT_0125Limited (en)LTD (en)
MT_1956Investment Company (en)INVCO (en)
MT_3492EU Association (en)
Societas Europaea (la)
SE (en)
MT_3997Societas Cooperativa Europaea (en)SCE (en)
MT_6368En nom collectif (en)
In the collective name (en)
P (en)
MT_7325Public limited company (en)PLC (en)
MT_7978European Economic Interest Grouping (en)EEIG (en)
MT_8215Sponsorship (en)
En commandite (fr)
PCOMM (en)
MT_8599Mutual Fund (en)
SICAV (Société d’Investissement à Capital Variable) (fr)
SV (en)
MT_8730Overseas Company (en)OC (en)
MT_8766Protected cell company (en)PCC (en)

Identifiers

IdentifierNameRegistration authority
EU_VAT_ID_MT (VAT Identification Number)Numru ta' Indentifikazzjoni għat-Taxxa fuq il-Valur Miżjud (mt)
VAT Identification Number (en)
Commissioner for Revenue (Malta)
MT_BRN (Business Registration Number)Business Registration Number (mt)
Business Registration Number (en)
MT_COC (Chamber of Commerce)Chamber of Commerce (en)
Chamber of Commerce (mt)
Malta Chamber of Commerce
MT_GGN (Gazzetta tal-Gvern ta’ Malta)Gazzetta tal-Gvern ta’ Malta (en)
Gazzetta tal-Gvern ta’ Malta (mt)
MT_TRN (Tax Registration Number)Tax Registration Number (en)
Tax Registration Number (mt)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (MT)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 MT (Malta) are the following: Regular expression/Mononumerical post code with delimeter
ERROR
Identifier Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Identifier Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Identifier Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Identifier format inaccurate (European value added tax identifier (Malta))This rule checks the syntax, i.e. format of the European value added tax identifier in Malta 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 Malta consists of exact 8 numerical digits prefixed by "MT". 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 invalid (European value added tax identifier (Malta))The European value added tax identifier in Malta consists of exact 8 numerical digits prefixed by "MT". This rule checks the presence of exact 8 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 missing (European value added tax identifier (Malta))Each legal entity in Malta should have a European value added tax identifier.WARNING
Identifier unknown (European value added tax identifier (Malta))European value added tax identifier (Malta)ERROR
Invalid checksum of EU VAT ID MT (Malta)This rule checks the checksum of the European VAT number in Malta, where the last 2 digits are validated using the following logic:
  • A1 = 3*C1 + 4*C2 + 6*C3 + 7*C4 + 8*C5 + 9*C6
  • R = 37 - (A1 modulo 37)
  • If R = 00, then C7 C8 = 37
  • C7 C8 = R
ERROR
Legal form invalid (Malta)Each record should have legal form appropriate for the country.INFO
Length of domestic bank account Id invalid (Malta)This rule checks whether the domestic bank account id exceeds the maximum possible length in MaltaERROR
Locality Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Locality Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Locality Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Mandatory administrative area missing (Malta)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 MaltaINFO
Mandatory locality missing (Malta)The locality is mandatory for street addresses in Malta.ERROR
Mandatory post code missing (Malta)The post code is mandatory for street addresses in Malta.ERROR
Mandatory thoroughfare missing (Malta)The thoroughfare is mandatory for street addresses in Malta.ERROR
Name Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Name Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Name Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Post code Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Post code Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Post code Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Post code format invalid (Malta)This rule checks the post code format of Malta. The postal code system was altered between April and October 2007. The new code consists of three capital letters, indicating the locality, followed by a space and four numbers. The first three digits refer to the thoroughfare, the final digit to the street segment. The postal code format is AAA NNNN.ERROR
Thoroughfare Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Thoroughfare Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Thoroughfare Qualification (European value added tax identifier (Malta), 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 (Malta)INFO
Unallowed pattern in name detected (MT)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 MT (Malta) 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
MT.CR (data source)MFSA registry of companies (en)
MT.GCB (data source)Bank Data details provided by the Central Bank of Malta (en)
MT Bank Data (de)
BANK_ACCOUNT
VIES (data source)VAT Information Exchange System (en)BUSINESS_PARTNER

Banking metadata

Property Value
Full metadata Bank accounts in Malta
Local name of the national bank ID. Bank ID name National Id
The provider (national authorities in most cases) of the national bank ID. Bank ID provider Malta Bankers' Association
Currency code for accounting in the given country. Currency code EUR
Maximum length of the national bank account ID. Maximum bank account ID length 18