ZA (South Africa)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/ZA
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 ZA
Language-specific name. Monolingual name Afrika-Dzonga (ts), Afrika-Borwa (tn), Südafrika (de), Afrika Tshipembe (ve), Suid-Afrika (af), Ningizimu Afrika (zu), 南非 (zh), Ningizimu Afrika (ss), Mzantsi Afrika (xh), South Africa (en), Afrique du Sud (fr), Afrika-Borwa (st)
Language-specific short name. Monolingual short name Südafrika (de), South Africa (en), 南非 (zh), Afrique du Sud (fr)
The offical langauge of a country. Official language st, zu, af, tn, ve, nr, en, ts, xh, ss
Language used in a country, beside the administrative languages. other language st, zu, af, tn, ve, nr, en, ts, xh, ss
Continent a country belongs to. Part of Africa

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
ZA-EC () ZA-EC Eastern Cape (af)
ZA-FS () ZA-FS Free State (af)
ZA-GP () ZA-GP Gauteng (af)
ZA-KZN () ZA-KZN Kwazulu Natal (af), Kwazulu-Natal (af)
ZA-LP () ZA-LP Limpopo (af)
ZA-MP () ZA-MP Mpumalanga (af)
ZA-NC () ZA-NC Northern Cape (af)
ZA-NW () ZA-NW North-West (af)
ZA-WC () ZA-WC Western Cape (af)

Legal forms

Legal formELF codeNameMain abbreviation
ZA_0291Close Corporation (en)CC (en)
ZA_0473Non-Profit Company (en)NPC (en)
ZA_0644Personal Liability Company (en)Inc (en)
ZA_1200Companies (en)Companies (en)
ZA_3031Private company limited by shares (en)Ltd. (en)
ZA_3563State Owned Company (en)SOC (en)
ZA_4007Sole proprietorship (en)SP (en)
ZA_4351Partnership (en)Partnership (en)
ZA_5080Public Company (en)PC (en)
ZA_6970Business trust (en)Business trust (en)
ZA_7841Close Corporation (en)CC (en)
ZA_8329Proprietary Limited Company (en)Pty. Ltd. (en)

Identifiers

IdentifierNameRegistration authority
ZA_CRN (South African Company Registration number)South African Company Registration number (en)
ZA_TIN (South African Tax Identification number)South African Tax Identification number (en)
ZA_VAT (VAT registration number)VAT registration number (en)South African Revenue Service (SARS)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (ZA)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 ZA (South Africa) are the following: Regular expression/Mononumerical post code with delimeter
ERROR
Identifier checkdigit invalid (Tax identification number (South Africa))This rule describes the algorithm for checksum digit (the last digit) for Tax identification number (South Africa). Logic for 10-digits identifier:
  • 1) The odd positioned digits of the tax reference number (1, 3, 5, 7 and 9) are multiplied by 2.
  • If the answer is greater than 9 the digits are added together to get the calculated value.
  • 2) Add these calculated values and the even positioned digits of the Tax reference number (2, 4, 6 and 8) together.
  • 3) Subtract the last character of this calculation from 10 to get the check digit.
  • If this is not equal to the last digit of the Tax reference number as entered, then this does not pass the modulus 10 test.

The last character is a check digit, calculated by applying the following algorithm:

  • When the result of the line item calculation exceeds 9, add the individual digits together to obtain a single digit result (e.g. 18=1+8=9)

Digit 10: Check digit

  • if the last digit of Total >0 Then
    • The Checksum digit should be equal to the result of 0 (Total mod 10)
  • if the last digit of Total = 0 Then
    • the Checksum digit shuld be equal to zero
ERROR
Identifier format invalid (Company registration number (South Africa))The DQ rule checks the validity of the format of Company registration number (South Africa). The correct format is YYYY/NNNNNN/NN, where:
  1. YYYY - the year of establishment
  2. NNNNNN (1st sequence) - the sequence # of a business entity in the registry
  3. NN (2nd sequence) - the type of the business entity, e.g.:
  • 06 PUBLIC COMPANY
  • 07 PRIVATE COMPANY
  • 08 ARTICLE 21
  • 09 LIMITED BY GUARANTEE
  • 10 EXTERNAL COMPANY
  • 12 EXTERNAL COMPANY UNDER SECTION 21A
  • 21 INC
  • 22 UNLIMITED
  • 23 CLOSE CORPORATION
  • 24 PRIMARY COOPERATIVE
  • 25 SECONDARY COOPERATIVE
  • 26 TERTIARY COOPERATIVE
  • 30 STATE OWNED COMPANY (SOC LTD)
  • 31 STATUTORY BODY
ERROR
Identifier format invalid (Tax identification number (South Africa))A South African Income Tax reference number is 10 numeric digits long, with a slash after the fourth and seventh digit. The tax reference number can only start with 0, 1, 2, 3 or 9. This rule accepts number also without slash or dot.INFO
Identifier format invalid (VAT registration number (South Africa))This rule checks the format of the VAT registration number (South Africa). The VAT Number is a unique number, which consists of 10 digits and always starts with the number 4.INFO
Legal form invalid (South Africa)Each record should have legal form appropriate for the country.INFO
Mandatory administrative area missing (South Africa)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 South AfricaINFO
Mandatory identifier not maintained (South Africa)A business partner in South Africa should have at least a VAT registration number (South Africa) or a Company registration number (South Africa). If none of these two is available the record is invalid.ERROR
Mandatory locality missing (South Africa)The locality is mandatory for street addresses in South Africa.ERROR
Mandatory post code missing (South Africa)The post code is mandatory for street addresses in South Africa.ERROR
Mandatory thoroughfare missing (South Africa)The thoroughfare is mandatory for street addresses in South Africa.ERROR
Post code format invalid (South Africa)This rule checks the post code format of South_Africa. Postal codes consist of a block of 4 digits. The first two digits refer to a postal area, the final two to a post office. The postal code format is NNNN.ERROR
Unallowed company name (ZA)A Company name, irrespective of its form or language, must end with one of the following expressions, as appropriate for the category of the particular Company:
  • (a) in the case of a personal liability Company, the name must end with the word ‘‘Incorporated’’ or its abbreviation ‘‘Inc.’’,
  • (b) in the case of a private Company, the name must end with the expression ‘‘Proprietary Limited’’ or its abbreviation, ‘‘(Pty) Ltd.’’,
  • (c) in the case of a public Company, the name must end with the word ‘‘Limited’’ or its abbreviation, ‘‘Ltd.’’.
  • (d) in the case of a state-owned Company, the name must end with he expression ‘‘SOC Ltd.’’, and
  • (e) in the case of a non-profit Company, the name must end with the expression ‘‘NPC’’.
INFO
Unallowed pattern in name detected (ZA)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 ZA (South Africa) are the following: Regular expression/One time vendor
WARNING

Data sources

Data quality ruleNameContent
ZA.ADDR (data source)Street address ZIP Code Lookup Service API (South Korea) (en)
Authority address file (South Korea) (en)
ADDRESS
ZA.POST (data source)Post (South Africa) (en)

Banking metadata

Property Value
Full metadata Bank accounts in South Africa
Local name of the national bank ID. Bank ID name Brach number
The provider (national authorities in most cases) of the national bank ID. Bank ID provider BANKSERV
Currency code for accounting in the given country. Currency code ZAR