EG (Egypt)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/EG
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 EG
Language-specific name. Monolingual name 埃及 (zh), Ägypten (de), Égypte (fr), Egypt (en), Mişr (ar)
Language-specific short name. Monolingual short name Egypt (en), 埃及 (zh), مصر (ar), Ägypten (de), Egypte (fr)
The offical langauge of a country. Official language ar
Language used in a country, beside the administrative languages. other language ar
Continent a country belongs to. Part of Africa

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
EG-ALX (Alexandria Governorate) EG-ALX Alexandria Governorate (en), Alexandrie (fr), al-Iskandariyya (de), محافظة الإسكندرية (ar), 亞歷山大省 (zh)
EG-ASN (Aswan Governorate) EG-ASN Assouan (fr), Aswan (de), Aswan Governorate (en), محافظة أسوان (ar), 阿斯旺省 (zh)
EG-AST (Asyut Governorate) EG-AST Assiout (fr), Asyut (de), Asyut Governorate (en), محافظة أسيوط (ar), 艾斯尤特省 (zh)
EG-BA (Red Sea Governorate) EG-BA Mer-Rouge (fr), Red Sea Governorate (en), al-Bahr al-ahmar (de), محافظة البحر الأحمر (ar), 红海省 (zh)
EG-BH (Beheira Governorate) EG-BH Beheira (fr), Beheira Governorate (en), al-Buhaira (de), محافظة البحيرة (ar), 布海拉省 (zh)
EG-BNS (Beni Suef Governorate) EG-BNS Bani Suwaif (de), Beni Souef (fr), Beni Suef Governorate (en), محافظة بني سويف (ar), 贝尼苏韦夫省 (zh)
EG-C (Cairo Governorate) EG-C Cairo Governorate (en), Gouvernorat du Caire (fr), al-Qahira (de), محافظة القاهرة (ar), 开罗省 (zh)
EG-DK (Dakahlia Governorate) EG-DK Dakahleya (fr), Dakahlia Governorate (en), ad-Daqahliyya (de), محافظة الدقهلية (ar), 代蓋赫利耶省 (zh)
EG-DT (Damietta Governorate) EG-DT Damietta Governorate (en), Damiette (fr), Dumyat (de), محافظة دمياط (ar), 杜姆亞特省 (zh)
EG-FYM (Faiyum Governorate) EG-FYM Faiyum Governorate (en), Fayoum (fr), al-Fayyum (de), محافظة الفيوم (ar), 法尤姆省 (zh)
EG-GH (Gharbia Governorate) EG-GH Gharbeya (fr), Gharbia Governorate (en), al-Gharbiyya (de), محافظة الغربية (ar), 西部省 (zh)
EG-GZ (Giza Governorate) EG-GZ Giza Governorate (en), Gizeh (fr), al-Dschiza (de), محافظة الجيزة (ar), 吉薩省 (zh)
EG-IS (Ismailia Governorate) EG-IS Ismailia Governorate (en), Ismaïlia (fr), al-Ismaʿiliyya (de), محافظة الإسماعيلية (ar), 伊斯梅利亚省 (zh)
EG-JS (South Sinai Governorate) EG-JS Dschanub Sina (de), Sinaï Sud (fr), South Sinai Governorate (en), محافظة جنوب سيناء (ar), 南西奈省 (zh)
EG-KB (Qalyubia Governorate) EG-KB Qalyubia Governorate (en), Qalyubiya (fr), al-Qalyubiyya (de), محافظة القليوبية (ar), 蓋盧比尤省 (zh)
EG-KFS (Kafr el-Sheikh Governorate) EG-KFS Gouvernorat de Kafr el-Cheik (fr), Kafr asch-Schaich (de), Kafr el-Sheikh Governorate (en), محافظة كفر الشيخ (ar), 謝赫村省 (zh)
EG-KN (Qena Governorate) EG-KN Qena (fr), Qena Governorate (en), Qina (de), محافظة قنا (ar), 基納省 (zh)
EG-LX (Luxor Governorate) EG-LX Louxor (fr), Luxor Governorate (en), al-Uqsur (de), محافظة الأقصر (ar), 盧克索省 (zh)
EG-MN (Minya Governorate) EG-MN Minya (fr), Minya Governorate (en), al-Minya (de), محافظة المنيا (ar), 明亞省 (zh)
EG-MNF (Monufia Governorate) EG-MNF Menufeya (fr), Monufia Governorate (en), al-Minufiyya (de), محافظة المنوفية (ar), 米努夫省 (zh)
EG-MT (Matrouh Governorate) EG-MT Marsa-Matruh (fr), Matrouh Governorate (en), Matruh (de), محافظة مطروح (ar), 馬特魯省 (zh)
EG-PTS (Port Said Governorate) EG-PTS Bur Saʿid (de), Port Said Governorate (en), Port-Saïd (fr), محافظة بورسعيد (ar), 塞得港省 (zh)
EG-SHG (Sohag Governorate) EG-SHG Sauhadsch (de), Sohag (fr), Sohag Governorate (en), محافظة سوهاج (ar), 索哈傑省 (zh)
EG-SHR (Al Sharqia Governorate) EG-SHR Ach-Charqiya (fr), Al Sharqia Governorate (en), asch-Scharqiyya (de), محافظة الشرقية (ar), 東部省 (zh)
EG-SIN (North Sinai Governorate) EG-SIN North Sinai Governorate (en), Schimal Sina (de), Sinaï Nord (fr), محافظة شمال سيناء (ar), 北西奈省 (zh)
EG-SUZ (Suez Governorate) EG-SUZ Suez (fr), Suez Governorate (en), as-Suwais (de), محافظة السويس (ar), 蘇伊士省 (zh)
EG-WAD (New Valley Governorate) EG-WAD New Valley Governorate (en), al-Wadi al-dschadid (de), la Nouvelle-Vallée (fr), محافظة الوادي الجديد (ar), 新河谷省 (zh)

Legal forms

Legal formELF codeNameMain abbreviation
EG_2582Sharikat al-Mossahamah (ar)SAE (ar)
EG_6888Limited Liability Company (ar)LLC (ar)

Identifiers

IdentifierNameRegistration authority
EG_BRN (Business Registration Number)Business Registration Number (ar)
Business Registration Number (en)
EG_CCN (Chamber of Commerce Number)Chamber of Commerce Egypt (ar)
Chamber of Commerce Number (en)
Egypt Chamber of Commerce
EG_TRN (Tax Registration Number)Tax Registration Number (ar)
Tax Registration Number (en)
Egyptian Tax Authority
TIN_EG (Tax Identification Number)Tax Identification Number (en)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (EG)Regular expression/Not available 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 EG (Egypt) are the following: Regular expression/Mononumerical post code with delimeter
ERROR
Identifier format inaccurate (Business Registration Number (Egypt))This rule checks the schema of the Business Registration Number (Egypt). The rule also checks if all applicable hyphens, dots and spaces are in place.INFO
Identifier format inaccurate (Chamber of Commerce Number (Egypt))This rule checks the schema of the Chamber of Commerce Number (Egypt): LL-DD-DDDDDDDDDDD. The rule also checks if all applicable hyphens, dots and spaces are in place.INFO
Identifier format inaccurate (Tax Registration Number (Egypt))This rule checks the schema of the Tax Registration Number (Egypt): DDD-DDD-DDD. The rule also checks if all applicable hyphens, dots and spaces are in place.INFO
Identifier format inaccurate (Tax identification number (Egypt))This rule checks the schema of the Tax identification number (Egypt): DDDDDDDDD. The rule also checks if all applicable hyphens, dots and spaces are in place.INFO
Identifier format invalid (Business Registration Number (Egypt))This rule checks the format of the Business Registration Number (Egypt) without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits, unexpected non-digit characters, or leading zeros then the rule is violated.ERROR
Identifier format invalid (Chamber of Commerce Number (Egypt))This rule checks the format of the Chamber of Commerce Number (Egypt) without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits, unexpected non-digit characters, or leading zeros then the rule is violated.ERROR
Identifier format invalid (Tax Registration Number (Egypt))This rule checks the format of the Tax Registration Number (Egypt) without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits, unexpected non-digit characters, or leading zeros then the rule is violated.ERROR
Identifier format invalid (Tax identification number (Egypt))A 9 digits number issued by the Egyptian Tax Authority uniquely identifying all companies registered in Egypt.ERROR
Identifier missing (Business Registration Number (Egypt))Each legal entity in Egypt should have a Business Registration Number.ERROR
Identifier missing (Chamber of Commerce Number (Egypt))Each legal entity in Egypt should have a Chamber of Commerce Number.ERROR
Identifier missing (Tax Registration Number (Egypt))Each legal entity in Egypt should have a Tax Registration Number.ERROR
Identifier missing (Tax identification number (Egypt))Each legal entity in Egypt should have a Tax identification number.ERROR
Identifier unknown (Business Registration Number (Egypt))This rule checks whether the Business Registration Number is known which means that it is assigned to a business partner listed in Egypt official registry.ERROR
Identifier unknown (Chamber of Commerce Number (Egypt))This rule checks whether the Chamber of Commerce Number is known which means that it is assigned to a business partner listed in Egypt official registry.ERROR
Identifier unknown (Tax Registration Number (Egypt))This rule checks whether the Tax Registration Number is known which means that it is assigned to a business partner listed in Egypt official registry.ERROR
Identifier unknown (Tax identification number (Egypt))This rule checks whether the Tax identification number is known which means that it is assigned to a business partner listed in Egypt official registry.ERROR
Legal form invalid (Egypt)Each record should have legal form appropriate for the country.INFO
Mandatory administrative area missing (Egypt)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 EgyptINFO
Mandatory locality missing (Egypt)The locality is mandatory for street addresses in Egypt.ERROR
Mandatory post code missing (Egypt)The post code is mandatory for street addresses in Egypt.ERROR
Mandatory thoroughfare missing (Egypt)The thoroughfare is mandatory for street addresses in Egypt.ERROR
Post code format invalid (Egypt)This rule checks the postcode format of Egypt. The postal code consists of a block of 5 digits. The first indicates the region, the second the governorate (before re-organisation in 2014), the third the quality of service and the last two the delivery area or post office. The postal code format is NNNNN.ERROR
Unallowed pattern in name detected (EG)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 EG (Egypt) are the following: Regular expression/One time vendor
WARNING

Data sources

No data sources maintained for Egypt.

Banking metadata

Property Value
Full metadata Bank accounts in Egypt
Currency code for accounting in the given country. Currency code EGP