|
Name |
|
|
Comment |
The billing shortfall run amounts |
|
BILLING_EFTSHORTFALL_AMOUNT data is confidential, and is available only to the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The shortfall affected billing contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
The shortfall affected billing week no |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The shortfall affected billing week run no |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The participant affected by the shortfall calculation |
|
SHORTFALL_AMOUNT |
NUMBER(18,8) |
|
The Participant shortfall amount |
|
SHORTFALL |
NUMBER(18,8) |
|
The market shortfall amount |
|
SHORTFALL_COMPANY_ID |
VARCHAR2(20) |
|
The Company ID associated with the Participant ID used in the shortfall calculation |
|
COMPANY_SHORTFALL_AMOUNT |
NUMBER(18,8) |
|
The shortfall amount for the Company ID associated with the Participant ID used in the shortfall calculation |
|
PARTICIPANT_NET_ENERGY |
NUMBER(18,8) |
|
The participant NET energy used in shortfall calculation |
|
COMPANY_NET_ENERGY |
NUMBER(18,8) |
|
The NET energy for the Company ID associated with the Participant ID used in the shortfall calculation |
|
|
|