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. |
|
|
|