IN_PAN (IN - Permanent Account Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/IN PAN
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key IN_PAN
The country a linked concept is active or generally relevant for. Country scope IN (India)
Language-specific name. Monolingual name Permanent Account Number (hi), Permanent Account Number (en)
Language-specific short name. Monolingual short name IN - Permanent Account Number (en)
Informal and comprehensive human-readable definition of a concept. Description Every individual or entity who has a taxable income has a Permanent Account Number
Category of business identifiers. Identifier category Identification Number
Legacy property. A technical SAP code. SAP mapping STCD2

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
0000000000DCRZ8Y1PB8PCXV09 10 characters: 5 letters + 4 digits + 1 letter, 4th character informs about the holder of the card: "P" - stands for Individuals ("Proprietor") NATURAL_PERSON_IDENTIFICATION
^(\w\s*\.*-*){3}(P)(\w\s*\.*-*){1}(\d\s*\.*-*){4}(\w\s*\.*-*){1}$
0000000000T1Q6J43BZWW8DT30 Specifies the allowed formats for the PAN code (India) IDENTIFIER_FORMAT
^(\w\s*\.*-*){3}(P|F|C|H|A|T|B|L|J|G)(\w\s*\.*-*){1}(\d\s*\.*-*){4}(\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
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.

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

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