IN (India)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/IN
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 IN
Language-specific name. Monolingual name Bhārat (hi), India (en), Indien (de), 印度 (zh), Inde (fr)
Language-specific short name. Monolingual short name 印度 (zh), Inde (fr), India (en), Indien (de)
The offical langauge of a country. Official language en, hi
Language used in a country, beside the administrative languages. other language fr
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 Language-specific alternative, i.e. non-official, name. Alternative name
IN-AN (Andaman and Nicobar Islands) IN-AN Andaman and Nicobar Islands (en), Andamanen und Nikobaren (de), Îles Andaman-et-Nicobar (fr), अण्डमान और निकोबार द्वीपसमूह (hi), 安达曼-尼科巴群岛 (zh) Andaman & Nicobar (en)
IN-AP (Andhra Pradesh) IN-AP Andhra Pradesh (de), Andhra Pradesh (en), Andhra Pradesh (fr), आन्ध्र प्रदेश (hi), 安得拉邦 (zh) Andhra Pradesh (en)
IN-AR (Arunachal Pradesh) IN-AR Arunachal Pradesh (de), Arunachal Pradesh (en), Arunachal Pradesh (fr), अरुणाचल प्रदेश (hi), 阿鲁纳恰尔邦 (zh) Arunachal Pradesh (en)
IN-AS (Assam) IN-AS Assam (de), Assam (en), Assam (fr), असम (hi), 阿萨姆邦 (zh) Assam (en)
IN-BR (Bihar) IN-BR Bihar (de), Bihar (en), Bihar (fr), बिहार (hi), 比哈尔邦 (zh) Bihar (en)
IN-CH (Chandigarh) IN-CH Chandigarh (de), Chandigarh (en), Chandigarh (fr), चण्डीगढ़ (hi), 昌迪加尔 (zh) Chandigarh (en)
IN-CT (Chhattisgarh) IN-CT Chhattisgarh (de), Chhattisgarh (en), Chhattisgarh (fr), छत्तीसगढ़ (hi), 恰蒂斯加尔邦 (zh) Chhattisgarh (en)
IN-DD (Daman and Diu) IN-DD Daman and Diu (en), Daman et Diu (fr), Daman und Diu (de), दमन और दीव (hi), 达曼-第乌 (zh) Daman & Diu (en)
IN-DH (Dadra and Nagar Haveli and Daman and Diu) IN-DH Dadra and Nagar Haveli and Daman and Diu (en)
IN-DL (Delhi) IN-DL Delhi (de), Delhi (en), Delhi (fr), दिल्ली (hi), 德里 (zh) Delhi (en)
IN-DN (Dadra and Nagar Haveli) IN-DN Dadra and Nagar Haveli (en), Dadra et Nagar Haveli (fr), Dadra und Nagar Haveli (de), दादर और नागर हवेली (hi), 达德拉-纳加尔哈维利 (zh) Dadra & Nagar Haveli (en)
IN-GA (Goa) IN-GA Goa (de), Goa (en), Goa (fr), गोआ (hi), 果阿邦 (zh) Goa (en)
IN-GJ (Gujarat) IN-GJ Gujarat (de), Gujarat (en), Gujarat (fr), गुजरात (hi), 古吉拉特邦 (zh) Gujarat (en)
IN-HP (Himachal Pradesh) IN-HP Himachal Pradesh (de), Himachal Pradesh (en), Himachal Pradesh (fr), हिमाचल प्रदेश (hi), 喜马偕尔邦 (zh) Himachal Pradesh (en)
IN-HR (Haryana) IN-HR Haryana (de), Haryana (en), Haryana (fr), हरियाणा (hi), 哈里亚纳邦 (zh) Haryana (en)
IN-JH (Jharkhand) IN-JH Jharkhand (de), Jharkhand (en), Jharkhand (fr), झारखण्ड (hi), 贾坎德邦 (zh) Jharkhand (en)
IN-JK (Jammu and Kashmir) IN-JK Jammu and Kashmir (en) Jammu und Kashmir (de)
IN-KA (Karnataka) IN-KA Karnataka (de), Karnataka (en), Karnataka (fr), कर्नाटक (hi), 卡纳塔克邦 (zh) Karnataka (en)
IN-KL (Kerala) IN-KL Kerala (de), Kerala (en), Kerala (fr), केरल (hi), 喀拉拉邦 (zh) Kerala (en)
IN-LA (Ladakh) IN-LA Ladakh (en)
IN-LD (Lakshadweep) IN-LD Lakshadweep (de), Lakshadweep (en), Lakshadweep (fr), लक्षद्वीप (hi), 拉克沙群島 (zh)
IN-MH (Maharashtra) IN-MH Maharashtra (de), Maharashtra (en), Maharashtra (fr), महाराष्ट्र (hi), 马哈拉施特拉邦 (zh) Maharashtra (en)
IN-ML (Meghalaya) IN-ML Meghalaya (de), Meghalaya (en), Meghalaya (fr), मेघालय (hi), 梅加拉亚邦 (zh) Meghalaya (en)
IN-MN (Manipur) IN-MN Manipur (de), Manipur (en), Manipur (fr), मणिपुर (hi), 曼尼普尔邦 (zh) Manipur (en)
IN-MP (Madhya Pradesh) IN-MP Madhya Pradesh (de), Madhya Pradesh (en), Madhya Pradesh (fr), मध्य प्रदेश (hi), 中央邦 (zh) Madhya Pradesh (en)
IN-MZ (Mizoram) IN-MZ Mizoram (de), Mizoram (en), Mizoram (fr), मिज़ोरम (hi), 米佐拉姆邦 (zh) Mizoram (en)
IN-NL (Nagaland) IN-NL Nagaland (de), Nagaland (en), Nagaland (fr), नागालैण्ड (hi), 那加兰邦 (zh) Nagaland (en)
IN-OR (Odisha) IN-OR Odisha (de), Odisha (en), Odisha (fr), ओडिशा (hi), 奥里萨邦 (zh) Odisha (en)
IN-PB (Punjab) IN-PB Pendjab (fr), Punjab (de), Punjab (en), पंजाब (hi), 旁遮普邦 (zh) Punjab (en)
IN-PY (Puducherry) IN-PY Puducherry (de), Puducherry (en), Territoire de Pondichéry (fr), पुदुच्चेरी (hi), 本地治里 (zh) Puducherry (en)
IN-RJ (Rajasthan) IN-RJ Rajasthan (de), Rajasthan (en), Rajasthan (fr), राजस्थान (hi), 拉贾斯坦邦 (zh) Rajasthan (en)
IN-SK (Sikkim) IN-SK Sikkim (de), Sikkim (en), Sikkim (fr), सिक्किम (hi), 锡金邦 (zh) Sikkim (en)
IN-TG (Telangana) IN-TG Telangana (de), Telangana (en), Telangana (fr), तेलंगाना (hi), 特伦甘纳邦 (zh) Telangana (en)
IN-TN (Tamil Nadu) IN-TN Tamil Nadu (de), Tamil Nadu (en), Tamil Nadu (fr), तमिल नाडु (hi), 泰米尔纳德邦 (zh) Tamil Nadu (en)
IN-TR (Tripura) IN-TR Tripura (de), Tripura (en), Tripura (fr), त्रिपुरा (hi), 特里普拉邦 (zh) Tripura (en)
IN-UP (Uttar Pradesh) IN-UP Uttar Pradesh (de), Uttar Pradesh (en), Uttar Pradesh (fr), उत्तर प्रदेश (hi), 北方邦 (zh) Uttar Pradesh (en)
IN-UT (Uttarakhand) IN-UT Uttarakhand (de), Uttarakhand (en), Uttarakhand (fr), उत्तराखण्ड (hi), 北阿坎德邦 (zh) Uttarakhand (en)
IN-WB (West Bengal) IN-WB Bengale-Occidental (fr), West Bengal (en), Westbengalen (de), पश्चिम बंगाल (hi), 西孟加拉邦 (zh) West Bengal (en)

Legal forms

Legal formNameMain abbreviationdescriptionCategory
Limited Liability Partnership (en)LLP (en)Limited Partnership
Unlimited Company (en)Private Limited Company
Mutual Fund (en)
Banking Company - Others (en)
Alternative Investment Fund (en)
Special Purpose Vehicle - Company (en)
Private Limited Company (en)Pvt. Ltd. (en)Private Limited Company
LIMITED (en)
Limited (en)
Public Limited (en)
Public Limited Company (en)
Ltd. (en)Limited Liability Company
Pension Fund Sub Scheme (en)
Government Company (en)
Insurance Company (en)
Public Sector Unit (en)PSU (en)Government Owned Company
Pension Fund (en)
Public Financial Institutions (en)
Housing Finance Company (en)
Partnership (en)Partnership (en)Partnership
Trust (en)
Non profit company (en)Sole Proprietorship
Non-Banking Finance Company (en)
Banking Company - Scheduled Urban Cooperative Bank (en)
Provident fund / Superannuation fund / Gratuity fund / Insurance Fund (en)
Multistate Cooperative Society (en)
Government Organization (en)
Mutual Fund-Sub Scheme (en)
Cooperative Society (en)
Special Purpose Vehicle-Coop / Multistate Coop Society (en)
Company Limited by Guarantee (en)
Banking Company - Nationalised Bank (en)
Stand Alone Primary Dealer (en)
Incorporated (en)Inc (en)Society
Special Purpose Vehicle - Partnership Firm (en)
Hindu undivided family (en)HUF (en)State Owned Company
One Person Company (en)OPC (en)Sole Proprietorship
Special Purpose Vehicle - Trust (en)
Sole Proprietorship (en)
Alternate Investment Fund - Sub scheme (en)

Identifiers

IdentifierNameRegistration authority
IN_CIN (IN - Company CIN)Company CIN (en)
Company CIN (hi)
IN_GST (IN - Goods and Service Tax)Consumption Tax (hi)
Indirect Tax (en)
Consumption Tax (en)
IN_IEC (IN - Importer Exporter Code)Importer Exporter Code (en)
Importer Exporter Code (hi)
IN_LBT (IN - LBT number)LBT number (hi)
LBT number (en)
IN_LLPIN (LLPIN)LLPIN (hi)
LLPIN (en)
IN_PAN (IN - Permanent Account Number)Permanent Account Number (en)
Permanent Account Number (hi)
IN_SERVICE_TAX_ID (IN - Service tax Reg. number)Service tax registration number (hi)
Service tax registration number (en)
IN_SRN (IN - Society Reg. Number)Society Registration Number (en)
Society Registration Number (hi)
IN_UDYAM (IN - UDYAM Registration Number)UDYAM registration number (en)
Udyog Aadhaar Memorandum (hi)

Data quality rules

Data quality ruleDescriptionCriticality
Deprecated identifier found (GST number (India))This rule checks whether there is still an old format of the Tax Identification Number (Indonesia) maintained that does not reflect the latest state code changes.

The first two digits of the GST represent the state code. Every state has a unique code. The region Daman and Diu (25) was merged with Dadra & Naga Haveli. The state code 25 becomes invalid and only 26 is to be used. SAP corrected their content for T005S in their S4 table content release accordingly. Andhra Pradesh had the state code 28, newly 37 is to be used. 28 becomes invalid.

If the state codes: 25 and 28 are identified in a given GST number, this rule will be triggered!
INFO
Dummy post code detected (IN)This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/IN 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
Identifier checkdigit invalid (GST number (India))This rule checks the check digit of the Goods and Services Tax number (GST) in India. The first fourteen digits of the GST are the GST number (India).

calculate a hash of each digit of GST number. Steps for calculation of hash are mentioned below:

a) Obtain corresponding code [C] for each alphanumeric digit of GST number. The codes for each alphanumeric characters are as following:

  • 0 -> 0
  • 1 -> 1
  • 2 -> 2
  • 3 -> 3
  • 4 -> 4
  • 5 -> 5
  • 6 -> 6
  • 7 -> 7
  • 8 -> 8
  • 9 -> 9
  • A -> 10
  • B -> 11
  • C -> 12
  • D -> 13
  • E -> 14
  • F -> 15
  • G -> 16
  • H -> 17
  • I -> 18
  • J -> 19
  • K -> 20
  • L -> 21
  • M -> 22
  • N -> 23
  • O -> 24
  • P -> 25
  • Q -> 26
  • R -> 27
  • S -> 28
  • T -> 29
  • U -> 30
  • V -> 31
  • W -> 32
  • X -> 33
  • Y -> 34
  • Z -> 35

b) Multiply “code” with a number called Multiplier [M], which will be 1 for odd digits and 2 or even digits of GST Number.

c) So on multiplication of “code” with “multiplier” [ C x M ] we get a number called Product [P].

d) Divide “product” with 36 [ P ÷ 36]. This division yields us a Quotient [Q] & a Remainder ['R].

e) Add “quotient” and “remainder” [ Q + R ] to get Hash of that digit of GST number.

Repeat the above steps for each digit of GST number, and obtain corresponding hash. After that, derive the checksum digit with below-mentioned steps:

For these 14 digits the check digit is calculated, in the following way:

  1. Add hash of all 14 digits calculated above to get Sum [S]
  2. Now divide “Sum” with 36 and obtain its Quotient [Z]
  3. Subtract from 36 the quotient obtained above [' 36 - Z ] to yield checksum code [Y]
  4. Lookup corresponding alphanumeric digit for the checksum code [Y] obtained in the above step, which is GST Number Checksum Digit
ERROR
Identifier format inaccurate (GST number (India))GST number (India) consists of 15 characters. This rule checks possible whitespaces, hyphens where they are not specified in a reference format or dots that might be comprised in the identifier value. If there are any whitespaces, dots or hyphens then the rule is violated. This rule checks the syntax, i.e. format of the GST number (India) with respect to the format. Any deviation (i.e. white spaces where they are not specified) result in a violation.INFO
Identifier format inaccurate (PAN code (India))PAN code (India) consists of 10 characters: 5 letters, 4 digits and 1 letter. This rule checks possible whitespaces, hyphens where they are not specified in a reference format or dots that might be comprised in the identifier value. If there are any whitespaces, dots or hyphens then the rule is violated. This rule checks the syntax, i.e. format of the PAN code (India) with respect to the format. Any deviation (i.e. white spaces where they are not specified) result in a violation.INFO
Identifier format invalid (CIN number (India))This rule checks the format of the CIN number in India. A Corporate Identification Number (CIN) is a 21-digit alpha-numeric code issued to companies incorporated in India. Each CIN number is unique and issued by Registrar of Companies of various states under the Ministry of Corporate Affairs in India. Each CIN number consists of six sections:
  • listing status: [UL] - Unlisted or Lister,
  • industry code: [0-9]{5} - 5 digits,
  • state code: [A-Z]{2} - 2 uppercase letters,
  • year of incorporation: [0-9]{4} - 4 digits year representation,
  • company type: [A-Z]{3} - 3 uppercase letters (like PLC, PTC, NPL etc.),
  • registration number: [0-9]{6} - 6 digits.
ERROR
Identifier format invalid (GST number (India))This rule checks the format of the GST number in India
  • The first two digits represent the state code as per Indian Census 2011. Every state has a unique code. Possible state codes are:
    • State code of Jammu and Kashmir is: 01
    • Himachal Pradesh: 02
    • Punjab: 03
    • Chandigarh: 04
    • Uttrakhand: 05
    • Haryana: 06
    • Delhi: 07
    • Rajasthan: 08
    • Uttarpradesh: 09
    • Bihar: 10
    • Sikkim: 11
    • Arunachal Pradesh: 12
    • Nagaland: 13
    • Manipur: 14
    • Mizoram: 15
    • Tripura: 16
    • Meghalaya: 17
    • Assam: 18
    • West Bengal: 19
    • Jharkhand: 20
    • Odisha: 21
    • Chhatishgarh: 22
    • Madhya Pradesh: 23
    • Gujarat: 24
    • Daman and Diu: 25 (no longer supported, should be 26)
    • Dadra & Nagar Haveli and Daman and Diu (merged): 26
    • Maharashtra: 27
    • Andhra Pradesh (before division): 28 (no longer supported, should be 37)
    • Karnataka: 29
    • Goa: 30
    • Lakshadweep: 31
    • Kerela: 32
    • Tamil Nadu: 33
    • Puducherry: 34
    • Andaman & Nicobar Islands: 35
    • Telangana: 36
    • Andhra Pradesh (new): 37
    • Ladakh (new): 38
    • Other territory: 97
    • Centre jurisdiction: 99
    • The next ten digits have to be the PAN number of the taxpayer
    • The thirteenth digit have to be assigned based on the number of entities registered on the same PAN number.
    • The fourteenth digit is Z by default
    • The last digit is check code. It may be an alphabet or a number.
    ERROR
    Identifier format invalid (IEC number (India))This rule checks the format of the IEC number in India
  • The IEC is a 10-digit unique identification number issued by the Directorate General of Foreign Trade (DGFT) under the Ministry of Commerce and Industry, Government of India.
  • ERROR
    Identifier format invalid (PAN code (India))The Permanent Account Number (PAN) in India is composed like this: First five characters are letters, next 4 characters are numerical digits and the last character is a letter. This rule checks the conformance with this reference scheme without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. A typical PAN is of AFZPK7190K, and the combination in which alphabet and numbers are arranged is explained below.
  • Characters 1-3: Of the PAN are three letters forming a sequence of alphabets letters from AAA to ZZZ
  • Digit 4: Represents the status of the PAN holder.
    • P for Individual
    • F for Firm
    • C for Company
    • H for HUF
    • A for AOP
    • T for TRUST
    • B for Body of Individuals
    • L for Local Authority
    • J for Artificial Juridical Person
    • G for Government
  • Digit 5: Of the PAN is the first character of either:
    • of the surname or last name of the person, in the case of a "personal" PAN card, where the fourth character is "P" or
    • of the name of the entity, trust, society, or organisation in the case of a company/HUF/firm/AOP/trust/BOI/local authority/artificial judicial person/government, where the fourth character is "C", "H", "F", "A", "T", "B", "L", "J", "G".
  • Digit 6-9: Of the PAN are sequential number running from 0001 to 9999.
  • Digit 10: Of the PAN is an alphabetic digit used as a check-sum to verify the validity of PAN Number.
  • ERROR
    Identifier missing (GST number (India))Each business partner in India requires a GST number (India)INFO
    Identifier missing (PAN code (India))Each business partner in India requires a PAN code.INFO
    Inconsistency between PAN and GST number (India)The Permanent Account Number (PAN) in India is the Tax Identification number. It consists of 10 characters composed as follows: SSYYYYYYYYYYNZX whereby
    • S: is the state code
    • Y: is exactly the 10 digit PAN number
    • N: is the number of entities registered with the same PAN number.
    • Z: is the alphabet Z by default
    • X: checksum digit (either number/ alphabet)
    This rule checks whether there are a PAN number and IN_GST available and whether the 10 digits in the GST number are identical to the 10 digits of the PAN number. If this is not the case then either the PAN or GST number are considered invalid.
    ERROR
    Legal form invalid (India)Each record should have legal form appropriate for the country.INFO
    Mandatory administrative area missing (India)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 IndiaINFO
    Mandatory identifier not maintained (India)A business partner in India should have at least a PAN code (India) or a GST number (India). If none of these two is available the record is invalid.INFO
    Mandatory locality missing (India)The locality is mandatory for street addresses in India.ERROR
    Mandatory post code missing (India)The post code is mandatory for street addresses in India.ERROR
    Mandatory thoroughfare missing (India)The thoroughfare is mandatory for street addresses in India.ERROR
    Post code format invalid (India)This rule checks the post code format of India.Indian postal codes (PIN codes) consist of a block of 6 digits. The first digit cannot be 0. The first two indicate the state, the third the sorting centre and the last three a large town, a group of post offices or a delivery office. Postal codes are sometimes found written in the format NNNNNN.ERROR
    Unallowed pattern in name detected (IN)This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/IN 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 sources

    Data source An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates Release status
    [[IN.CA (data source)]]
    MCA
    [[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
    n/a LIVE
    1,874,371 records
    [[IN.ADDR (data source)]]
    Authority address file (India)
    [[ADDRESS]]A fatal error occurred in the #info parser function
    n/a IDEA
    [[IN.CR (data source)]]
    Open Government Data Platform India
    [[ADDRESS]]A fatal error occurred in the #info parser function
    n/a IDEA
    [[IN.POST (data source)]]
    India post (India)
    [[ADDRESS]]A fatal error occurred in the #info parser function
    n/a IDEA

    Banking metadata

    Property Value
    Full metadata Bank accounts in India
    Local name of the national bank ID. Bank ID name IFSC Code
    The provider (national authorities in most cases) of the national bank ID. Bank ID provider Reserve Bank of India
    Currency code for accounting in the given country. Currency code INR