• Agency file

    Field description

    Field name

    Data type

    ABR bulk data file information

    SBR definition

    Primary Identifier

    PID

    integer

    Unique identifer for linking the ABR bulk data files (primary key)

    A string of alphanumeric characters generated by the Government Agency, used to uniquely identify the Business Document contained in the exchanged message. It should be a business identifier that would be understood by the Government Agency involved in the message exchange, not a message envelope level GUID.

    GovernmentGeneratedIdentifierExternal Link

    ABN

    ABN

    varchar(20)

    A unique 11-digit identifier issued to entities registered in the ABR

    A unique public identifier issued to all entities registered in the Australian Business Register (ABR), to be used in their dealings with government. Companies registered under the Corporations Law and business entities carrying on an enterprise in Australia are entitled to an ABN.

    AustralianBusinessNumber.IdentifierExternal Link

    Entity Type

    Ent_Typ_Cd

    varchar(3)

    Child entity types

    Refer to Appendix A for further information

    The legal or business structure of an organisation. It determines the nature of the organisation's business as described by the Australian Standard 4590.

    Organisation Details Organisation TypeExternal Link

    Entity Organisation Name

    Org_Nm

    varchar(200)

    The name of the entity that appears on official documents or legal papers

    The full name by which an organisation is known.

    OrganisationalName.TextExternal Link

    Entity Name Title

    (Individuals only)

    Nm_Titl_Cd

    varchar(12)

    Refer to Appendix B for further information

    A term indicating a person's status or used as a form of address or reference.

    PersonNameDetails.Title.TextExternal Link

    Entity Name Given Name

    (Individuals only)

    Prsn_Gvn_Nm

    varchar(40)

     

    The name given to a person that is the person's identifying name within the family group or the name by which the person is uniquely socially identified; the name borne by an individual, often assigned by his or her parents shortly after birth, as opposed to the inherited surname.

    PersonNameDetails.GivenName.TextExternal Link

     

    Entity Name Other Given Names

    (Individuals only)

    Prsn_Othr_Gvn_Nm

    varchar(100)

     

    The middle name given to a person that complements that person's identifying name within the family group or the name by which the person is uniquely socially identified.

    PersonNameDetails.OtherGivenName.TextExternal Link

    Entity Name Family Name

    (Individuals only)

    Prsn_Fmly_Nm

    varchar(40)

     

    The last name or surname given to a person. The name by which a family group is identified.

    PersonNameDetails.FamilyName.TextExternal Link

    Entity Name Suffix

    (Individuals only)

    Nm_Sufx_Cd

    varchar(5)

    Refer to Appendix C for further information

    Awards, Honours or any other kind of denominations that may follow the name of the person.

    PersonNameDetails.NameSuffix.TextExternal Link

    ABN Registration Date of Effect

    ABN_Regn_Dt

    varchar(8)1

    The date the registration comes into effect

    Date when the organisation registration becomes effective.

    OrganisationRegistrationStart.DateExternal Link

    ABN Cancellation Date of Effect

    ABN_Cancn_Dt

    varchar(8)1

    The date the registration ceases to be effective

    Date when the organisation registration becomes non effective.

    OrganisationRegistrationEnd.DateExternal Link

    Main Trading Name2

    Mn_Trdg_Nm

    varchar(200)

     

    The full name by which an organisation is known.

    OrganisationalName.TextExternal Link

    Service of Notice Address Line 1

    SON_Addr_Ln_1

    varchar(38)

     

    First line utilising free format that is used to create a semi structured address.

    AddressDetails.Line1.TextExternal Link

    Service of Notice Address Line 2

    SON_Addr_Ln_2

    varchar(38)

     

    Second line utilising free format that is used to create a semi structured address.

    AddressDetails.Line2.TextExternal Link

    Service of Notice Address Suburb

    SON_Sbrb

    varchar(46)

     

    A word or combination of words, by which a geographic locality/suburb is designated or known.

    AddressDetails.LocalityName.TextExternal Link

    Service of Notice Address State Code

    SON_Stt

    varchar(3)

     

    The code that is assigned to each Australian State or Territory

    AddressDetails.StateOrTerritory.CodeExternal Link

    Service of Notice Address Postcode

    SON_Pc

    varchar(12)

     

    The Australian descriptor for a postal delivery area, aligned with locality, suburb or place

    AddressDetails.Postcode.TextExternal Link

    Service of Notice Address Country Code

    SON_Cntry_Cd

    varchar(3)

     

    This represents the Country Name as prescribed by AS4590 and inherited from ISO 3166

    AddressDetails.Country.CodeExternal Link

    Service of Notice Address DPID

    SON_DPID

    integer

     

    Implements a unique identification number that is assigned by Australia Post for that address. This number is printed onto correspondence as a barcode and results in a discount from Australia Post.

    AddressDetails.DeliveryPoint.IdentifierExternal Link

    Business Address Line 1

    Mn_Bus_Addr_Ln_1

    varchar(38)

    The entity’s main business (street) address within Australia

    First line utilising free format that is used to create a semi structured address.

    AddressDetails.Line1.TextExternal Link

    Business Address Line 2

    Mn_Bus_Addr_Ln_2

    varchar(38)

     

    Second line utilising free format that is used to create a semi structured address.

    AddressDetails.Line2.TextExternal Link

    Business Address Suburb

    Mn_Bus_Sbrb

    varchar(46)

     

    A word or combination of words, by which a geographic locality/suburb is designated or known.

    AddressDetails.LocalityName.TextExternal Link

    Business Address State Code

    Mn_Bus_Stt

    varchar(3)

     

    The code that is assigned to each Australian State or Territory

    AddressDetails.StateOrTerritory.CodeExternal Link

    Business Address Postcode

    Mn_Bus_Pc

    varchar(12)

     

    The Australian descriptor for a postal delivery area, aligned with locality, suburb or place

    AddressDetails.Postcode.TextExternal Link

    Business Address Country Code

    Mn_Bus_Cntry_Cd

    varchar(3)

     

    This represents the Country Code as prescribed by AS4590 and inherited from ISO 3166

    AddressDetails.Country.CodeExternal Link

    Business Address DPID

    Mn_Bus_DPID

    integer

     

    Implements a unique identification number that is assigned by Australia Post for that address. This number is printed onto correspondence as a barcode and results in a discount from Australia Post.

    AddressDetails.DeliveryPoint.IdentifierExternal Link

    Email

    Ent_Eml

    varchar(200)

    The entity’s email address

    Denotes the address of an electronic mail service.

    ElectronicContact.ElectronicMail.Address.TextExternal Link

    PartyID

    Prty_Id_Blnk

    varchar(1)

     

     

    GST Registration Date of Effect

    GST_Regn_Dt

    varchar(8)1

    The date the GST registration comes into effect

    Date when the organisation registration becomes effective.

    OrganisationDetails.OrganisationRegistrationStart.DateExternal Link

    GST Cancellation Date of Effect

    GST_Cancn_Dt

    varchar(8)1

    The date the GST registration ceases to be effective

    Date when the organisation registration becomes non effective.

    OrganisationDetails.OrganisationRegistrationEnd.DateExternal Link

    Business Industry Code

    Mn_Indy_Clsn

    varchar(5)

    ANZSIC codes are four-digit numbers. The Australian Taxation OfficeExternal Link (ATO) uses a five-digit code referred to as Business Industry Code

    This is a code that identifies the classification of the industry in which the organisation operated during the relevant period. The Australian and New Zealand Standard Industrial Classification 2006 (ANZSIC) coding system has a 4 level hierarchical structure, where subdivision, group, class and subclass levels are denoted by numeric codes.

    OrganisationDetails.OrganisationIndustry2006.CodeExternal Link

    Business Industry Description

    Mn_Indy_Clsn_Descn

    varchar(100)

     

    This is the description of the 2006 Australian and New Zealand Standard Industrial Classification (ANZSIC) code.

    OrganisationIndustry2006.DescriptionExternal Link

    ASIC Number

    ACN

    varchar(20)

    The ASIC number is represented as a single field i.e. ACN or ARBN or ARSN

    ACN: An Australian Company Number (ACN) is a unique nine-digit number issued by the Australian Securities and Investments Commission (ASIC) as an identifier to every Australian company registered under the Corporations Act 2001

    Identifiers.AustralianCompanyNumber.IdentifierExternal Link

     

     

     

     

    ARBN: The Australian Registered Body Number (ARBN) is a nine digit number allocated by the Australian Securities and Investments Commission (ASIC) when a foreign company or registrable Australian body is registered under the Corporations Act 2001.

    Identifiers.AustralianRegisteredBodyNumber.IdentifierExternal Link

     

     

     

     

    ARSN: The Australian Registered Scheme Number (ARSN) is a nine digit number allocated by Australian Securities and Investments Commission (ASIC) to managed investment schemes registered in Australia.

    Identifiers.AustralianRegisteredSchemeNumber.IdentifierExternal Link

    Suppression Indicator

    Sprsn_Ind

    varchar(1)

    ABR data value for this field is either Y or N

    This indicates whether detailed information relating to an entity has been suppressed.

    Report.EntityInformationSuppression.IndicatorExternal Link

    # - Please Note: Field names are not contained in the ABR bulk data files downloaded from the Data Transfer Facility. The field names are provided in SQL (structured query language) code available to assist you in generating the data tables with the correct data structure and field headings.

    1 Date fields are supplied in character format (YYYYMMDD). You may need to change the date format to one that suits your applications.

    2 The ABR ceased collecting and updating trading names from 28 May 2012. Trading names collected before that date will be displayed in the ABN Lookup and the ABR until 31 October 2018.

    • Last modified: 17 Aug 2016QC 573