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 |
|
|
|