BILLINGCALENDAR
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.
Package
BILLING_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
AEMO Contract Year number starting in week containing 1st January |
| WEEKNO |
numeric(3, 0) |
smallint |
Week no within the contract year. Week no 1 is the week containing 1st January |
| STARTDATE |
datetime(3) |
datetime2(0) |
Start Date of week |
| ENDDATE |
datetime(3) |
datetime2(0) |
End Date of week |
| PRELIMINARYSTATEMENTDATE |
datetime(3) |
datetime2(0) |
Preliminary Statement Date |
| FINALSTATEMENTDATE |
datetime(3) |
datetime2(0) |
Final Statement Date |
| PAYMENTDATE |
datetime(3) |
datetime2(0) |
Payment Date |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| REVISION1_STATEMENTDATE |
datetime(3) |
datetime2(0) |
Revision 1 Statement Date for the billing week. |
| REVISION2_STATEMENTDATE |
datetime(3) |
datetime2(0) |
Revision 2 Statement Date for the billing week. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGCALENDAR_LCX |
nonclustered |
LASTCHANGED |
| BILLINGCALENDAR_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLINGCALENDAR_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_BILLINGCALENDAR |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGCALENDAR_LCX |
nonclustered |
LASTCHANGED |
| BILLINGCALENDAR_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO |