BILLINGGENDATA
BILLINGGENDATA shows the total energy sold and purchased per participant transmission connection point for a billing period. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, BILLING_ENERGY_TRANSACTIONS AND BILLING_ENERGY_GENSET_DETAIL replace BILLINGGENDATA.
Package
BILLING_RUN
Visibility
Private
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 |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Unique run no within a given contract year and week no |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| CONNECTIONPOINTID |
varchar(10) |
varchar(10) |
Connection point identifier |
| STATIONID |
varchar(10) |
varchar(10) |
not populated |
| DUID |
varchar(10) |
varchar(10) |
not populated |
| AGGREGATEENERGY |
numeric(16, 6) |
numeric(16, 6) |
Aggregate energy sold, in MWh |
| SALES |
numeric(16, 6) |
numeric(16, 6) |
$ income |
| PURCHASES |
numeric(16, 6) |
numeric(16, 6) |
$ outgoing |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| PURCHASEDENERGY |
numeric(16, 6) |
numeric(16, 6) |
Amount of energy purchased in MWh |
| MDA |
varchar(10) |
varchar(10) |
Metering Data Agent supplying data |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGGENDATA_LCX |
nonclustered |
LASTCHANGED |
| BILLINGGENDATA_NDX2 |
nonclustered |
PARTICIPANTID |
| BILLINGGENDATA_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLINGGENDATA_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_BILLINGGENDATA_PARTICIPANTID |
nonclustered |
PARTICIPANTID |
| PK_BILLINGGENDATA |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGGENDATA_LCX |
nonclustered |
LASTCHANGED |
| BILLINGGENDATA_NDX2 |
nonclustered |
PARTICIPANTID |
| BILLINGGENDATA_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID |