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 Language-specific alternative, i.e. non-official, name. Alternative name
ZA-EC (Eastern Cape) ZA-EC Eastern Cape (af), Eastern Cape (en)
ZA-FS (Free State) ZA-FS Free State (af), Free State (en)
ZA-GP (Gauteng) ZA-GP Gauteng (af), Gauteng (en)
ZA-KZN (Kwazulu-Natal) ZA-KZN Kwazulu Natal (af), Kwazulu-Natal (af), Kwazulu-Natal (en)
ZA-LP (Limpopo) ZA-LP Limpopo (af), Limpopo (en)
ZA-MP (Mpumalanga) ZA-MP Mpumalanga (af), Mpumalanga (en)
ZA-NC (Northern Cape) ZA-NC Northern Cape (af), Northern Cape (en)
ZA-NW (North-West) ZA-NW North-West (af), North-West (en)
ZA-WC (Western Cape) ZA-WC Western Cape (af), Western Cape (en)
ZA-ZN (Zululand) ZA-ZN Zululand (en)

Legal forms

Legal formNameMain abbreviationdescriptionCategory
Close Corporation (en)CC (en)A closely held corporation with limited number of members and simplified governance. In South Africa it historically served small private businesses before being phased out.Registered Partnership
Non-Profit Company (en)NPC (en)A nonprofit company operating for public benefit without distributing profits. In South Africa it serves charitable and nonprofit purposes.Unknown
Personal Liability Company (en)Inc (en)A company where directors and members may have personal liability beyond capital contributions. In South Africa it provides structure with enhanced personal accountability.Limited Liability Company
Companies (en)Companies (en)A general company structure providing legal personality for business operations. In South Africa it serves various business purposes under company law.Society
Private company limited by shares (en)Ltd. (en)A privately held company where shareholder liability is limited to share capital contributions. In South Africa it provides standard structure for private businesses.Private Company Limited by Shares
State Owned Company (en)SOC (en)A company owned and controlled by the state. In South Africa it enables government ownership and operation of strategic enterprises.State Owned Company
Sole proprietorship (en)SP (en)A business owned and operated by one individual bearing full personal liability. In South Africa it provides simple structure for self-employed persons.Sole Proprietorship
Partnership (en)Partnership (en)A business relationship where partners jointly own and operate sharing profits and liabilities. In South Africa it provides traditional collaborative structure.Partnership
Public Company (en)PC (en)A company that can offer shares to the public for investment. In South Africa it enables businesses to raise capital from public markets.Public Company
Business trust (en)Business trust (en)A trust structure operated for business and trading purposes. In South Africa it enables commercial operations through trust arrangement.Trust
Close Corporation (en)CC (en)A closely held corporation with limited members and simplified structure. In South Africa it historically served small businesses with streamlined governance.Registered Partnership
Proprietary Limited Company (en)Pty. Ltd. (en)A proprietary limited company with private shareholding and limited liability. In South Africa it provides standard structure for private businesses.Proprietorship

Identifiers

IdentifierNameRegistration authority
ZA_CRN (ZA - Company Reg. Num.)South African Company Registration number (en)
ZA_TIN (ZA - South African Tax ID Num.)South African Tax Identification number (en)
ZA_VAT (ZA - VAT registration number)VAT registration number (en)South African Revenue Service (SARS)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (ZA)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
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 (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
Length of domestic bank account Id invalid (South Africa)This rule checks whether the domestic bank account id exceeds the maximum possible length in South AfricaERROR
Length of national bank Id invalid (South Africa)This rule checks whether the domestic bank id exceeds the maximum possible length in South AfricaERROR
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)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
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
ZA.ADDR (data source)
Authority address file (South Korea)
Data source category<br/>Specifies the category of a data source in terms of the content.<br/><code>ADDRESS</code>: The data source provides address reference data.<br/><code>BANK_ACCOUNT</code>: The data source provides bank and bank account reference data.<br/><code>BENEFICIAL_OWNER</code>: The data source provides information about beneficial owners of companies.<br/><code>BUSINESS_PARTNER</code>: The data source provides master data about companies.<br/><code>CERTIFICATE</code>: The data source provides information about business partner certifications.<br/><code>HEALTHCARE_ORGANIZATION</code>: The data source provides information about HCOs.<br/><code>HEALTHCARE_PROFESSIONAL</code>: The data source provides information about HCPs.<br/><code>INSOLVENCY</code>: The data source provides information about insolvencies.<br/><code>SANCTION_AND_WATCHLIST</code>: A data source that provides sanctioned or watched companies or persons. ADDRESS (Data source category)
Street address ZIP Code Lookup Service API (South Korea) is a data source that helps CDQ customers validate and enrich business partner master data for compliance and data quality. IDEA
ZA.POST (data source)
Post (South Africa)
Post (South Africa) is a data source that helps CDQ customers validate and enrich business partner master data for compliance and data quality. IDEA

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