Name |
|
Comment |
The SAP Billing Transaction Details for the Participants |
Name |
BILLRUNNO |
CONTRACTYEAR |
PARTICIPANTID |
TNI |
WEEKNO |
Name |
Data Type |
Mandatory |
Comment |
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
PARTICIPANTID |
VARCHAR2(20) |
X |
The SAP Participant ID |
TNI |
VARCHAR2(20) |
X |
The SAPS Connection Point ID |
REGIONID |
VARCHAR2(20) |
|
The Region ID associated with the TNI |
CONSUMED_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Consumed for that TNI for the Participant Id in that Billing Week |
SENTOUT_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Sent Out for the TNI for the Participant Id in that Billing Week |
CONSUMED_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Consumed Energy |
SENTOUT_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Sent Out Energy |
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
|
|