|
Name |
|
|
Comment |
Billing result table containing daily summary data for customer and generator energy amounts |
|
BILLING_DAILY_ENERGY_SUMMARY data is confidential to the relevant participant. Source Populated by the posting of a billing run. Volume Approximately 20 records per billrunno. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
SETTLEMENTDATE |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run number |
|
SETTLEMENTDATE |
DATE |
X |
settlement date |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
participant identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Unique Region Identifier |
|
CUSTOMER_ENERGY_PURCHASED |
NUMBER(18,8) |
|
customer energy amount purchased on this settlement day by the participant in the region |
|
GENERATOR_ENERGY_SOLD |
NUMBER(18,8) |
|
generator energy amount sold on this settlement day by the participant in the region |
|
GENERATOR_ENERGY_PURCHASED |
NUMBER(18,8) |
|
generator energy amount purchased on this settlement day by the participant in the region |
|
|
|