|
Name |
|
|
Comment |
The details of all registered organisations i.e the BB Participants of the Bulletin Board over time |
|
Name |
|
COMPANYID |
|
EFFECTIVEDATE |
|
VERSIONDATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
COMPANYID |
Number(10,0) |
X |
Unique company identifier |
|
EFFECTIVEDATE |
Date |
X |
Effective date for this operating state |
|
VERSIONDATETIME |
Date |
X |
Version timestamp of the record |
|
COMPANYNAME |
Varchar2 (50) |
|
Name of company |
|
ABN |
Varchar2 (30) |
|
Australian Business Number of company |
|
ADDRESSTYPE |
Varchar2 (40) |
|
Type of address eg. Head Office, Postal Address etc. |
|
ADDRESS |
Varchar2 (120) |
|
Address of company based on AddressType |
|
LOCALE |
Varchar2 (40) |
|
City location of company |
|
JURISDICTION |
Varchar2 (5) |
|
State location of company |
|
POSTCODE |
VARCHAR2(4) |
|
Postcode of company |
|
COMPANYPHONE |
Varchar2 (30) |
|
Main (reception) phone of company |
|
COMPANYFAX |
Varchar2 (30) |
|
Main (reception) facsimile of company |
|
AUTHORISEDDATE |
Date |
|
Date and time this operating state was authorised |
|
AUTHORISEDBY |
Varchar2 (30) |
|
AEMO internal |
|
ORGANISATIONTYPENAME |
VARCHAR2(40) |
|
The type of organisation |
|
|
|