IL (Israel)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/IL
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 IL
Language-specific name. Monolingual name Isrā'īl (ar), Israel (en), Yisra'el (he), 以色列 (zh), Israël (fr), Israel (de)
Language-specific short name. Monolingual short name 以色列 (zh), ישראל (he), Israel (en), Israel (de), Israël (fr), إسرائيل (ar)
The offical langauge of a country. Official language ar, he
Language used in a country, beside the administrative languages. other language ar, he
Continent a country belongs to. Part of Asia

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
IL-D (Southern District) IL-D Southern District (en), Südbezirk (de), district sud (fr), מחוז הדרום (he), 南部区 (zh)
IL-HA (Haifa District) IL-HA Bezirk Haifa (de), Haifa District (en), district de Haïfa (fr), מחוז חיפה (he), 海法区 (zh)
IL-JM (Jerusalem District) IL-JM Bezirk Jerusalem (de), Jerusalem District (en), district de Jérusalem (fr), מחוז ירושלים (he), 耶路撒冷区 (zh)
IL-M (Central District) IL-M Central District (en), Zentralbezirk (de), district centre (fr), מחוז המרכז (he), 中央区 (zh)
IL-TA (Tel Aviv District) IL-TA Bezirk Tel Aviv (de), Tel Aviv District (en), district de Tel Aviv (fr), מחוז תל אביב (he), 特拉维夫区 (zh)
IL-Z (Northern District) IL-Z District nord (fr), Nordbezirk (de), Northern District (en), מחוז הצפון (he), 北部区 (zh)

Legal forms

Legal formELF codeNameMain abbreviation
IL_1109Private Limited Company (en)Pvt. Ltd. (en)
IL_1532Private Company (en)Private Company (en)
IL_3655Public Company (en)Public Company (en)
IL_4867Partnership (en)Partnership (en)
IL_5753Self-Employed (en)Self-Employed (en)
IL_5824Cooperative (en)Cooperative (en)
IL_8929Corporation (en)Corp (en)
IL_8974Be'eravon Mugbal (he)B.M. (he)

Identifiers

IdentifierNameRegistration authority
IL_VAT (VAT registration number)מס' עוסק מורשה / ח"פ (he)
מס' עוסק מורשה / ח"פ (ar)
VAT registration number (en)
Israel Tax Authority

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (IL)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 IL (Israel) are the following: Regular expression/Mononumerical post code with delimeter
ERROR
Identifier checkdigit invalid (VAT registration number (Israel))The rightmost digit is a check digit (using Luhn algorithm (https://en.wikipedia.org/wiki/Luhn_algorithm) ).ERROR
Identifier format invalid (VAT registration number (Israel))9 digit number. If the number of digits is less than 9, then zeros should be padded to the left side. The leftmost digit is 5 for corporations. Other leftmost digits are used for individuals. The rightmost digit is a check digit (using Luhn algorithm).ERROR
Identifier unknown (VAT registration number (Israel))This rule checks whether the VAT registration number (Israel) 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
Legal form invalid (Israel)Each record should have legal form appropriate for the country.INFO
Length of domestic bank account Id invalid (Israel)This rule checks whether the domestic bank account id exceeds the maximum possible length in IsraelERROR
Length of national bank Id invalid (Israel)This rule checks whether the domestic bank id exceeds the maximum possible length in IsraelERROR
Mandatory administrative area missing (Israel)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 IsraelINFO
Mandatory locality missing (Israel)The locality is mandatory for street addresses in Israel.ERROR
Mandatory post code missing (Israel)The post code is mandatory for street addresses in Israel.ERROR
Mandatory thoroughfare missing (Israel)The thoroughfare is mandatory for street addresses in Israel.ERROR
Post code format invalid (Israel)This rule checks the post code format of Israel. On 1st February 2013, postal codes in Israel change from 5 digits to 7. The first 5 (or 4) digits remain the same. The postal code format is NNNNNNN.ERROR
Unallowed pattern in name detected (IL)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 IL (Israel) are the following: Regular expression/One time vendor
WARNING

Data sources

Data quality ruleNameContent
IL.CR (data source)מאגר החברות - רשם החברות (en)BUSINESS_PARTNER

Banking metadata

Property Value
Full metadata Bank accounts in Israel
Local name of the national bank ID. Bank ID name Bank Code
The provider (national authorities in most cases) of the national bank ID. Bank ID provider Bank of Israel
Currency code for accounting in the given country. Currency code ILS
Maximum length of the national bank ID. Maximum bank ID length 6
Maximum length of the national bank account ID. Maximum bank account ID length 13