AU (Australia)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/AU
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 AU
Language-specific name. Monolingual name Australien (de), 澳大利亚 (zh), Australia (en), Australie (fr)
Language-specific short name. Monolingual short name Australie (fr), 澳大利亚 (zh), Australia (en), Australien (de)
The offical langauge of a country. Official language en
Language used in a country, beside the administrative languages. other language en
Continent a country belongs to. Part of Australia

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
AU-ACT (Australian Capital Territory) AU-ACT Australian Capital Territory (de), Australian Capital Territory (en), Territoire de la capitale australienne (fr), 澳大利亞首都特區 (zh)
AU-NSW (New South Wales) AU-NSW New South Wales (de), New South Wales (en), Nouvelle-Galles du Sud (fr), 新南威爾士州 (zh)
AU-NT (Northern Territory) AU-NT Nordterritorium (de), Northern Territory (en), Territoire du Nord (fr), 北領地 (zh)
AU-QLD (Queensland) AU-QLD Queensland (de), Queensland (en), Queensland (fr), 昆士蘭州 (zh)
AU-SA (South Australia) AU-SA Australie-Méridionale (fr), South Australia (de), South Australia (en), 南澳大利亚州 (zh)
AU-TAS (Tasmania) AU-TAS Tasmania (en), Tasmanie (fr), Tasmanien (de), 塔斯馬尼亞州 (zh)
AU-VIC (Victoria) AU-VIC Victoria (de), Victoria (en), Victoria (fr), 維多利亞州 (zh)
AU-WA (Western Australia) AU-WA Australie-Occidentale (fr), Western Australia (de), Western Australia (en), 西澳大利亚州 (zh)

Legal forms

Legal formELF codeNameMain abbreviation
AU_0004Limited Partnership (en)LPT (en)
AU_0105Family Partnership (en)FPT (en)
AU_0165Individual/Sole Trader (en)IND (en)
AU_0171Other trust (en)
AU_0816Co-operative (en)Coop Ltd (en)
AU_1947Incorporated (en)Inc (en)
AU_4163No liability company (en)NL (en)
AU_5307Public company limited by shares (en)Ltd. (en)
AU_8056Private Proprietary Limited Company (en)Pty. Ltd. (en)
AU_9136Indigenous Corporation (en)RNTBC (en)

Identifiers

IdentifierNameRegistration authority
ABN_AU (Australian Business Number)Australian Business Number (en)
ACN_AU (Australian Company Number)Australian Company Number (en)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (AU)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 AU (Australia) are the following: Regular expression/Mononumerical post code with delimeter
ERROR
Identifier Qualification (Business Number (Australia), Data source:AU.BR)This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the Business Number (Australia)INFO
Identifier format inaccurate (Australian Company Number (Australia))The Australian Company Number (Australia) consists of 9 digits. There is a convention to display the SCN in the format XXX XXX XXX
three blocks of three characters, each block separated by a blank. This is to assist readability and the inserted blanks do not form part of the ACN. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value in the places where they are not supposed to be. If there are any whitespaces, dots or hyphens then the rule is violated. This rule checks the syntax, i.e. format of the Australian Company Number (Australia) with respect to the format. Any deviation (i.e. white spaces where they are not specified) result in a violation.
INFO
Identifier format inaccurate (Business Number (Australia))This rule checks the syntax, i.e. format of Australian Business Number (ABN) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation. Australian Business Number (ABN) consists of 11 digits in the format: "99 999 999 999". This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces in a places where no whitespace is expected to be, hyphens or dots then the rule is violated.INFO
Identifier format invalid (Business Number (Australia))The Australian Business Number (ABN) is a unique issued to all entities registered in the Australian Business Register (ABR). The 11 digit ABN is structured as a 9 digit identifier with two leading check digits. The leading check digits are derived using a modulus 89 (remainder after dividing by 89) calculation. This rule checks presence of exactly 9 digits and prefix 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.INFO
Identifier missing (Business Number (Australia))Each legal entity in Australia should have a Business Number.WARNING
Identifier unknown (Australian Business Number (Australia))For a valid Business Number (Australia)ERROR
Invalid checksum of ABN AU (Australia)The 11 digit ABN is structured as a 9 digit identifier with two leading check digits. This rule checks whether the ABN is valid with respect to the checkdigits. The leading check digits are derived using a modulus 89 (remainder after dividing by 89) calculation.

Format of the BNA looks like this:

[ C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11 ]

M11 ( C1 - 1 ) + M10 x C2 + M9 x C3 + M8 x C4 + M7 x C5 + M6 x C6 + M5 x C7 + M4 x C8 + M3 x C9 + M2 x C10 + M1 x C11 MOD89=0

The set of weightings are:

M11...M1 = (10,1,3,5,7,9,1113,15,17,19)
ERROR
Invalid checksum of ACN AU (Australia)This rule checks the checksum of the Australian Company Number. The ACN is a nine digit number with the last digit being a check digit calculated using a modified modulus 10 calculation.ERROR
Legal form invalid (Australia)Each record should have legal form appropriate for the country.INFO
Length of national bank Id invalid (Australia)This rule checks whether the domestic bank id exceeds the maximum possible length in AustraliaERROR
Mandatory administrative area missing (Australia)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 AustraliaERROR
Mandatory locality missing (Australia)The locality is mandatory for street addresses in Australia.ERROR
Mandatory post code missing (Australia)The post code is mandatory for street addresses in Australia.ERROR
Mandatory thoroughfare missing (Australia)The thoroughfare is mandatory for street addresses in Australia.ERROR
Name Qualification (Business Number (Australia), Data source:AU.BR)This data quality rule checks the congruency of the given name against the name maintained as reference for the Business Number (Australia)INFO
Post code Qualification (Business Number (Australia), Data source:AU.BR)This data quality rule checks the congruency of the given post code against the post code maintained as reference for the Business Number (Australia)INFO
Post code format invalid (Australia)This rule checks the post code format of Australia. Postal codes consist of a block of 4 digits. The first digit indicates the state or territory
the second a zone and the final two the delivery office. Most municipalities, settlements or suburbs have a single own code. Post office boxes have different postal codes to street addresses, and large users may also have a unique code. A company can therefore possibly have two codes. The mailing address (post office box/large user) should in these cases be used in preference to the street address.
ERROR
Unallowed pattern in name detected (AU)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 AU (Australia) are the following: Regular expression/One time vendor
WARNING

Data sources

Data quality ruleNameContent
AU.ASIC (data source)ASIC Business Names (en)
AU.BR (data source)Australian Business Register (en)BUSINESS_PARTNER
AU.CR (data source)Australia post (en)ADDRESS
AU.GNAF (data source)Geocoded National Address File (G-NAF) (en)ADDRESS

Banking metadata

Property Value
Full metadata Bank accounts in Australia
Local name of the national bank ID. Bank ID name BSB Number (Bank State Branch)
The provider (national authorities in most cases) of the national bank ID. Bank ID provider Australian Payments Clearing Association
Currency code for accounting in the given country. Currency code AUD
Maximum length of the national bank ID. Maximum bank ID length 16