|
Name |
|
|
Comment |
BILLINGCALENDAR sets out the billing calendar for the year, with week number 1 starting on 1 January. BILLINGCALENDAR advises preliminary and final statement posting date and corresponding settlement for each billing week. |
|
BILLINGCALENDAR is public data, and is available to all participants. Source Infrequently, only when inserting billing weeks for a future contractyear. Volume 52-53 records inserted per contractyear |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
STARTDATE |
DATE |
|
Start Date of week |
|
ENDDATE |
DATE |
|
End Date of week |
|
PRELIMINARYSTATEMENTDATE |
DATE |
|
Preliminary Statement Date |
|
FINALSTATEMENTDATE |
DATE |
|
Final Statement Date |
|
PAYMENTDATE |
DATE |
|
Payment Date |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
REVISION1_STATEMENTDATE |
DATE |
|
Revision 1 Statement Date for the billing week. |
|
REVISION2_STATEMENTDATE |
DATE |
|
Revision 2 Statement Date for the billing week. |
|
Name |
|
|
Comment |
GST_BAS_CLASS contains a static list of BAS (Business Activity Statement) classifications supported by the MMS. |
|
GST_BAS_CLASS data is public to all participants. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BAS_CLASS |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
BAS_CLASS |
VARCHAR2(30) |
X |
The BAS classification |
|
DESCRIPTION |
VARCHAR2(100) |
|
Description of the BAS classification |
|
LASTCHANGED |
DATE |
|
Last date and time the record changed |
|
Name |
|
|
Comment |
GST_RATE maintains the GST rates on a BAS (Business Activity Statement) class basis. |
|
GST_RATE data is public to all participants. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BAS_CLASS |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
The effective date of the data set |
|
VERSIONNO |
NUMBER(3,0) |
X |
The version number of the data set |
|
BAS_CLASS |
VARCHAR2(30) |
X |
The BAS classification |
|
GST_RATE |
NUMBER(8,5) |
|
The GST rate that applies to this BAS classification |
|
LASTCHANGED |
DATE |
|
Last date and time the record changed |
|
Name |
|
|
Comment |
GST_TRANSACTION_CLASS maps NEM settlement transaction types with BAS (Business Activity Statement) classifications. |
|
GST_TRANSACTION_CLASS data is public to all participants. Source GST_TRANSACTION_CLASS updates infrequently, when new transactions are introduced to the NEM. Volume Generally volume is fewer than one hundred records. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BAS_CLASS |
|
EFFECTIVEDATE |
|
TRANSACTION_TYPE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
The effective date of the data set |
|
VERSIONNO |
NUMBER(3,0) |
X |
The version number of the data set |
|
TRANSACTION_TYPE |
VARCHAR2(30) |
X |
NEM settlement transaction type |
|
BAS_CLASS |
VARCHAR2(30) |
X |
The BAS classification that the transaction type corresponds to |
|
LASTCHANGED |
DATE |
|
Last date and time the record changed |
|
Name |
|
|
Comment |
GST_TRANSACTION_TYPE shows a static list of transaction types supported by the MMS. |
|
GST_TRANSACTION_TYPE data is public to all participants. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
TRANSACTION_TYPE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRANSACTION_TYPE |
VARCHAR2(30) |
X |
The transaction type |
|
DESCRIPTION |
VARCHAR2(100) |
|
Description of the transaction type |
|
GL_FINANCIALCODE |
VARCHAR2(10) |
|
|
|
GL_TCODE |
VARCHAR2(15) |
|
|
|
LASTCHANGED |
DATE |
|
Last date and time the record changed |
|
Name |
|
|
Comment |
The security deposit interest rate on a daily basis. This is the public table published when the business enter and authorise a new daily interest rate |
|
SECDEPOSIT_INTEREST_RATE data is public to all participants. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
INTEREST_ACCT_ID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
X |
The interest account ID for calculating the interest payment |
|
EFFECTIVEDATE |
DATE |
X |
The effective date of the interest rate change |
|
VERSION_DATETIME |
DATE |
X |
Date Time this record was added |
|
INTEREST_RATE |
NUMBER(18,8) |
|
The interest rate for the interest account ID as on the effective date. |
|
Name |
|
|
Comment |
The security deposit provision entry details |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
SECURITY_DEPOSIT_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SECURITY_DEPOSIT_ID |
VARCHAR2(20) |
X |
The security deposit ID |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant ID linked to the security deposit ID |
|
TRANSACTION_DATE |
DATE |
|
The date the security deposit ID is entered and authorised by settlements |
|
MATURITY_CONTRACTYEAR |
NUMBER(4,0) |
|
The contract year of the billing week when the security deposit is maturing |
|
MATURITY_WEEKNO |
NUMBER(3,0) |
|
The week no of the billing week when the security deposit is maturing |
|
AMOUNT |
NUMBER(18,8) |
|
The security deposit amount |
|
INTEREST_RATE |
NUMBER(18,8) |
|
The interest rate assigned to the security deposit ID. Null if INTEREST_CALC_TYPE <> FIXED |
|
INTEREST_CALC_TYPE |
VARCHAR2(20) |
|
FIXED OR DAILY |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
|
The Interest Account ID for calculating the Interest Payment. This is NULL if the INTEREST_CALC_TYPE = FIXED |
|
|
|