|
Name |
|
|
Comment |
PARTICIPANTACCOUNT shows financial details on participants. |
|
PARTICIPANTACCOUNT data is confidential to the relevant participant. Source PARTICIPANTACCOUNT updates as new participants register or existing participants change details. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
ACCOUNTNAME |
VARCHAR2(80) |
|
Name of the account |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
ACCOUNTNUMBER |
VARCHAR2(16) |
|
Account number |
|
BANKNAME |
VARCHAR2(16) |
|
Bank name |
|
BANKNUMBER |
NUMBER(10,0) |
|
Bank number |
|
BRANCHNAME |
VARCHAR2(16) |
|
Branch name |
|
BRANCHNUMBER |
NUMBER(10,0) |
|
Branch number |
|
BSBNUMBER |
VARCHAR2(20) |
|
BSB number |
|
NEMMCOCREDITACCOUNTNUMBER |
NUMBER(10,0) |
|
AEMO credit account number |
|
NEMMCODEBITACCOUNTNUMBER |
NUMBER(10,0) |
|
AEMO debit account number |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
EFFECTIVEDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ABN |
VARCHAR2(20) |
|
Australian Business Number |
|
|
|