BILLING_NMAS_MANUAL_PAYMENT

This report contains the NMAS Manual Weekly Payments that are uploaded by the Settlement Business Team. Amounts in this table are not calculated by the Settlement System.

Package

BILLING_RUN

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(4, 0)	smallint	The Billing Contract Year.
WEEKNO	numeric(3, 0)	smallint	The Billing WeekNo
BILLRUNNO	numeric(4, 0)	smallint	The Billing RunNo
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.
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)
BILLING_NMAS_MANUAL_PAYMENT_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONTRACTID, DUID, SERVICETYPE, PAYMENTTYPE

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
PK_BILLING_NMAS_MANUAL_PAYMENT	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONTRACTID, DUID, SERVICETYPE, PAYMENTTYPE

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
PK_BILLING_NMAS_MANUAL_PAYMENT	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONTRACTID, DUID, SERVICETYPE, PAYMENTTYPE