|
Name |
|
|
Comment |
The SAPS Meter data for MSRP and Retailer used in the Settlement Calculation |
|
Name |
|
CASE_ID |
|
CONNECTIONPOINT_ID |
|
FRMP |
|
LR |
|
METER_TYPE |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASE_ID |
NUMBER(15,0) |
X |
The Metering Case ID used for Settlements |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date for that Week |
|
CONNECTIONPOINT_ID |
VARCHAR2(20) |
X |
The SAPS Connection Point Id |
|
METER_TYPE |
VARCHAR2(20) |
X |
The Meter Type Identifier , CUSTOMER or MSRP |
|
FRMP |
VARCHAR2(20) |
X |
The Financial Responsible Market Participant |
|
LR |
VARCHAR2(20) |
X |
The Local Retailer |
|
PERIODID |
NUMBER(4,0) |
X |
The Period ID Identifier |
|
IMPORTVALUE |
NUMBER(18,8) |
|
The Sent Out Energy in MWh |
|
EXPORTVALUE |
NUMBER(18,8) |
|
The Consumed Energy in MWh |
|
LASTCHANGED |
DATE |
|
The Date time of the record last updated or inserted. |
|
|
|