IN (India)

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

Legal forms

Legal formELF codeNameMain abbreviation
IN_0768 (CDQ)IN_0768Limited Liability Partnership (en)LLP (en)
IN_2084 (CDQ)IN_2084Private Limited Company (en)Pvt. Ltd. (en)
IN_2085 (CDQ)IN_2085Public Limited Company (en)
Public Limited (en)
Limited (en)
LIMITED (en)		Ltd. (en)
IN_3146 (CDQ)IN_3146Public Sector Unit (en)PSU (en)
IN_4526 (CDQ)IN_4526Partnership (en)Partnership (en)
IN_8813 (CDQ)IN_8813Incorporated (en)Inc (en)
IN_9155 (CDQ)IN_9155Hindu undivided family (en)HUF (en)
IN_9156 (CDQ)IN_9156One Person Company (en)OPC (en)

Identifiers

IdentifierNameRegistration authority
IN_CIN (Company CIN)Company CIN (en)
Company CIN (hi)
IN_GST (Indirect Tax, Consumption Tax)Consumption Tax (hi)
Indirect Tax (en)
Consumption Tax (en)
IN_IEC (Importer Exporter Code)Importer Exporter Code (en)
Importer Exporter Code (hi)
IN_LBT (LBT number)LBT number (hi)
LBT number (en)
IN_LLPIN (LLPIN)LLPIN (hi)
LLPIN (en)
IN_PAN (Permanent Account Number)Permanent Account Number (en)
Permanent Account Number (hi)		Income Tax Department
IN_SERVICE_TAX_ID (Service tax registration number)Service tax registration number (hi)
Service tax registration number (en)		Income Tax Department
IN_SRN (Society Registration Number)Society Registration Number (en)
Society Registration Number (hi)
IN_UDYAM (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)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 IN (India) are the following: Regular expression/Mononumerical post code with delimeter		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 (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 (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)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 IN (India) are the following: Regular expression/One time vendor    		WARNING

    Data sources

    Data quality ruleNameContent
    IN.ADDR (data source)Authority address file (India) (en)ADDRESS
    IN.CA (data source)Ministry of Corporate Affairs - Government of India (en)
    Ministry of Corporate Affairs (India) (en)
    Ministry of Corporate Affairs (de)    		BUSINESS_PARTNER
    IN.CR (data source)Open Government Data Platform India (en)ADDRESS
    IN.POST (data source)India post (India) (en)ADDRESS

    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
    Retrieved from "https://meta.cdq.com/w/index.php?title=DataModel:CDQ/Business_Partner/Address/Country/IN&oldid=73985"