SET_NMAS_MANUAL_PAYMENT
This report contains the NMAS Manual TI Payments that are uploaded by the Settlement Business Team. Amounts in this table are not calculated by the Settlement System.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
The Settlement Date of the Billing Week. |
| VERSIONNO |
numeric(3, 0) |
smallint |
The Settlement Run No. |
| PARTICIPANTID |
varchar(20) |
varchar(10) |
The Contract Participant Id. |
| CONTRACTID |
varchar(20) |
varchar(20) |
The NMAS System Security Contract ID. |
| DUID |
varchar(20) |
varchar(10) |
The DUID associated with the Contract Payment. |
| SERVICETYPE |
varchar(40) |
varchar(40) |
The NMAS System Security Service Types (INERTIA, SYSTEM STRENGTH, TYPE1, TYPE2 and so on). |
| PAYMENTTYPE |
varchar(20) |
varchar(20) |
The Payment Type associated with the Service like Availability, Usage, Enablement, Energy Revenue, Test, ADHOC and so on. |
| PERIODID |
numeric(3, 0) |
smallint |
The Settlement Period Id (1-288). |
| REGIONID |
varchar(10) |
varchar(10) |
The Contract Region Id. |
| PAYMENTAMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The NMAS Contract Manual Payment for the Payment Type. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The last changed date time of the record. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_NMAS_MANUAL_PAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, DUID, SERVICETYPE, PAYMENTTYPE, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_NMAS_MANUAL_PAYMENT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, DUID, SERVICETYPE, PAYMENTTYPE, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_NMAS_MANUAL_PAYMENT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, DUID, SERVICETYPE, PAYMENTTYPE, PERIODID |