|
Name |
|
|
Comment |
BILLINGCPDATA shows energy quantity and $ value purchased per participant connection point. |
|
BILLINGCPDATA data is confidential to relevant participant. Source Populated by the posting of a billing run, being several times each week. Volume The number of records depends on the number of Transmission ConnectionPointIDs a participant may use to purchase energy. An indicative maximum is approximately 150 records per billrunno, or about 1,500 records inserted per week. |
|
Name |
|
BILLRUNNO |
|
CONNECTIONPOINTID |
|
CONTRACTYEAR |
|
MDA |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
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 |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Unique connection point identifier |
|
AGGREGATEENERGY |
NUMBER(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 |
NUMBER(16,6) |
|
The Purchase column has the dollar value of the Energy Purchased rather than Aggregate Energy Dollar |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MDA |
VARCHAR2(10) |
X |
relevant MDA for this connection point. |
|
AFE |
NUMBER(18,8) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the Billing run, excluding any UFEA component. |
|
DME |
NUMBER(18,8) |
|
Sum of ME- for all NMIs at this Market Customer FRMP and TNI in the Billing run. |
|
UFEA |
NUMBER(18,8) |
|
Share of UFE allocated to this FRMP and TNI in the Billing run. |
|
AGE |
NUMBER(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. |
|
SOLDENERGY |
NUMBER(18,8) |
|
Energy sold at the connection point by the participant in this billing run |
|
SALES |
NUMBER(18,8) |
|
The total cost of energy sold at the connection point by the participant in this billing run |
|
PURCHASEDENERGY |
NUMBER(18,8) |
|
The energy consumed at the connection point by the participant in this billing run |
|
|
|