BILLINGCPDATA
BILLINGCPDATA shows energy quantity and $ value purchased per participant connection point. 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 BILLINGCPDATA.
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) |
Unique connection point identifier |
| MDA |
varchar(10) |
varchar(10) |
relevant MDA for this connection point. |
| AGGREGATEENERGY |
numeric(16, 6) |
numeric(16, 6) |
Aggregate energy purchased/sold by customer, in MWh, plus UFEA. When GS commences, this includes the UFEA amount in the settlement runs. |
| PURCHASES |
numeric(16, 6) |
numeric(16, 6) |
The Purchase column has the dollar value of the Energy Purchased rather than Aggregate Energy Dollar |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| AFE |
numeric(18, 8) |
numeric(18, 8) |
Adjusted Gross Energy for this Market Customer FRMP and TNI in the Billing run, excluding any UFEA component. |
| DME |
numeric(18, 8) |
numeric(18, 8) |
Sum of ME- for all NMIs at this Market Customer FRMP and TNI in the Billing run. |
| UFEA |
numeric(18, 8) |
numeric(18, 8) |
Share of UFE allocated to this FRMP and TNI in the Billing run. |
| AGE |
numeric(18, 8) |
numeric(18, 8) |
Adjusted Gross Energy for this Market Customer FRMP and TNI in the trading interval. This will include the UFEA value once financial settlement of UFE commences with GS. |
| PURCHASEDENERGY |
numeric(18, 8) |
numeric(18, 8) |
The energy consumed at the connection point by the participant in this billing run |
| SALES |
numeric(18, 8) |
numeric(18, 8) |
The total cost of energy sold at the connection point by the participant in this billing run |
| SOLDENERGY |
numeric(18, 8) |
numeric(18, 8) |
Energy sold at the connection point by the participant in this billing run |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGCPDATA_LCX |
nonclustered |
LASTCHANGED |
| BILLINGCPDATA_NDX2 |
nonclustered |
PARTICIPANTID |
| BILLINGCPDATA_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID, MDA |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLINGCPDATA_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_BILLINGCPDATA_PARTICIPANTID |
nonclustered |
PARTICIPANTID |
| PK_BILLINGCPDATA |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID, MDA |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGCPDATA_LCX |
nonclustered |
LASTCHANGED |
| BILLINGCPDATA_NDX2 |
nonclustered |
PARTICIPANTID |
| BILLINGCPDATA_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID, MDA |