IN_GST (IN - Goods and Service Tax)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/IN GST
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key IN_GST
The country a linked concept is active or generally relevant for. Country scope IN (India)
Language-specific name. Monolingual name Indirect Tax (en), Consumption Tax (en), Consumption Tax (hi)
Language-specific short name. Monolingual short name IN - Goods and Service Tax (en)
Informal and comprehensive human-readable definition of a concept. Description Goods and Services Tax (GST) is an indirect tax (or consumption tax) imposed in India on the supply of goods and services. It is a comprehensive multistage, destination-based tax. Comprehensive because it has subsumed almost all the indirect taxes except few. Multi-Staged as it is imposed at every step in the production process, but is meant to be refunded to all parties in the various stages of production other than the final consumer. And destination-based tax, as it is collected from point of consumption and not point of origin like previous taxes. The single GST subsumed several taxes and levies which included: central excise duty, services tax, additional customs duty, surcharges, state-level value added tax and Octroi. Other levies which were applicable to interstate transportation of goods have also been done away with in GST regime. GST is levied on all transactions such as sale, transfer, purchase, barter, lease, or import of goods and/or services.
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1

Formal definition

Details Informal and comprehensive human-readable definition of a concept. Description The type in terms of a categorization of regular expressions. Regular expression type TThe formal expression of a regular expression. Regular expression
00000000005FEGATW5E332XH67 Specifies the allowed formats for the GST number (India) IDENTIFIER_FORMAT
^(([0-1][0-9])|([2][0,1,2,3,4,5,6,7,8,9])|(3[0-8])|97|99)(\w\s*\.*-*){3}(P|F|C|H|A|T|B|L|J|G)(\w\s*\.*-*){1}(\d\s*\.*-*){4}(\w\s*\.*-*){1}\d{1}Z(\w\s*\.*-*){1}$
0000000000MXNGK87VFVV8Y5D2 Specifies the deprecated format for the GST number (India) DEPRECATED_IDENTIFIER_FORMAT
^([2][5,8])(\w\s*\.*-*){3}(P|F|C|H|A|T|B|L|J|G)(\w\s*\.*-*){1}(\d\s*\.*-*){4}(\w\s*\.*-*){1}\d{1}Z(\w\s*\.*-*){1}$

Data quality rules

Rule Informal and comprehensive human-readable definition of a concept. 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 Criticality<br/>Specifies how critical of the violation of a data quality rule.<br/>ERROR: Indicates a critical data quality rule violation that requires correction.<br/>WARNING: Indicates a potential data quality issue that should be reviewed.<br/>INFO: Indicates an informational finding with no immediate impact on data quality. Criticality
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!

RELEASED INFO
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
RELEASED 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.

IDEA 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.
RELEASED ERROR
Identifier missing (GST number (India)) Each business partner in India requires a GST number (India) RELEASED INFO