SG (Singapore)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/SG
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 SG
Language-specific name. Monolingual name Singapur (de), Xinjiapo (zh), Singapura (ms), Singapour (fr), Singapore (en), Chiṅkappūr (ta)
Language-specific short name. Monolingual short name Singapur (de), Singapore (en), Singapura (ms), 新加坡 (zh), Singapour (fr)
The offical langauge of a country. Official language ms, ta, zh, en
Language used in a country, beside the administrative languages. other language ms, ta, zh, 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
SG-01 (Central Singapore) SG-01 Central Singapore (en)
SG-02 (North East) SG-02 North East (en)
SG-03 (North West) SG-03 North West (en)
SG-04 (South East) SG-04 South East (en)
SG-05 (South West) SG-05 South West (en)

Legal forms

Legal formELF codeNameMain abbreviation
SG_0512Limited (en)Limited (en)
SG_0968Public Limited company (en)PLC (en)
SG_7432Sole proprietorship (en)SP (en)
SG_9487Limited Liability Partnership (en)LLP (en)

Identifiers

IdentifierNameRegistration authority
SG_GST (Goods and Service Tax Number)Goods and Service Tax Number (en)
SG_UEN (Unique Entity Number)Unique Entity Number (ms)
Unique Entity Number (ta)
Unique Entity Number (zh)
Unique Entity Number (en)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (SG)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 SG (Singapore) are the following: Regular expression/Mononumerical post code with delimeter
ERROR
Identifier Qualification (UEN number (Singapore), Data source:SG.BR)This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the UEN number (Singapore)INFO
Identifier format inaccurate (UEN number (Singapore))Unique Entity Number (UEN) is a 9- or 10-digit alphanumeric code which can have one of the following formats:

1) 8 numbers + 1 checksum letter 2) 9 numbers + 1 checksum letter 3) "LnnLLnnnnL", where n - digit, L - letter

This rule checks possible whitespaces, hyphens where they are not specified in a reference UEN number (Singapore)
INFO
Identifier format invalid (GST number (Singapore))This rule checks presence of exactly 10 alphanumerical chaarcters corresponding to the format of the GST number (Singapore) without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. It has 10 alphanumeric characters and can start with two letters or numbers and may end with a letter or number. It might look like this, for example, M2-1234567-8, M212345678, MR-1234567-8, or 19-9012345-X. If you are a nonresident with a GST ID, it may look like this, for example, F2-1234567-D.ERROR
Identifier format invalid (UEN number (Singapore))Unique Entity Number (UEN) is a 9- or 10-digit alphanumeric code issued by the Singaporean government to all entities that operate within Singapore. The UEN can have one of the following formats:

1) 8 numbers + 1 checksum letter 2) 9 numbers + 1 checksum letter 3) "LnnLLnnnnL", where n - digit, L - letter

This rule checks presence of exactly 9 or 10 alphanumerical chaarcters corresponding to the format of the UEN number (Singapore) without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits, unexpected non-digits characters then the rule is violated.
ERROR
Identifier missing (UEN number (Singapore))Each legal entity in Singapore should have a UEN number (Singapore).ERROR
Identifier unknown (UEN number (Singapore))This business rule checks the validity of the UEN number (Singapore) against the Data source/SG.BRERROR
Legal form invalid (Singapore)Each record should have legal form appropriate for the country.INFO
Mandatory administrative area missing (Singapore)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 SingaporeINFO
Mandatory locality missing (Singapore)The locality is mandatory for street addresses in Singapore.ERROR
Mandatory post code missing (Singapore)The post code is mandatory for street addresses in Singapore.ERROR
Mandatory thoroughfare missing (Singapore)The thoroughfare is mandatory for street addresses in Singapore.ERROR
Name Qualification (UEN number (Singapore), Data source:SG.BR)This data quality rule checks the congruency of the given name against the company name maintained as reference for the UEN number (Singapore)INFO
Post code Qualification (UEN number (Singapore), Data source:SG.BR)This data quality rule checks the congruency of the given post code against the post code maintained as reference for the UEN number (Singapore)INFO
Post code format invalid (Singapore)This rule checks the post code format of Singapore. Postal codes of the new system, introduced on 1st September 1995, consist of a block of 6 digits. This allows Singapore Post to assign a single code to every building in Singapore and to allow mail sorting on the basis of sequence of delivery. The first two digits are the sector code, the last four the delivery point (i.e. building). Postal codes are assigned on the basis of the alphabetical order of the street name per sector. Thus streets with names beginning with ‘A’ are coded first, then ‘B’ and so on. For Housing and Development Board (HDB) residential blocks, the block number is included in the postal code.ERROR
Thoroughfare Qualification (UEN number (Singapore), Data source:SG.BR)This data quality rule checks the congruency of the given street against the street maintained as reference for the UEN number (Singapore)INFO
Unallowed pattern in name detected (SG)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 SG (Singapore) are the following: Regular expression/One time vendor
WARNING

Data sources

Data quality ruleNameContent
SG.ADDR (data source)GST Search (en)ADDRESS
SG.BR (data source)Unique Entity Number Register (en)BUSINESS_PARTNER
SG.OM (data source)One Map (Singapore) (en)ADDRESS
SG.POST (data source)Singpost (en)

Banking metadata

Property Value
Full metadata Bank accounts in Singapore
Local name of the national bank ID. Bank ID name ACH Bank Code
The provider (national authorities in most cases) of the national bank ID. Bank ID provider Monetary Authority of Singapore/ UOB
Currency code for accounting in the given country. Currency code SGD