Article 3.6.1P : How to create PPS_CoilOpr table in ELNet DB ?

Article 3.6.1P : How to create PPS_CoilOpr table in ELNet DB ?

If recharge is not happening.

Go to ELNet S/W root folder & Check ELNet Log Event here if you are finding any error like PPS_CoilOpr invalid.
Open SQL Server & Check ELNet DB. If PPS_CoilOpr table is missing.
Just copy below mention Query.

USE [ELNetDB]
GO

/****** Object:  Table [dbo].[PPS_CoilOpr]    Script Date: 3/21/2019 4:20:07 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PPS_CoilOpr](
[Token_No] [varchar](25) NULL,
[Meter_ID] [int] NULL,
[Operation] [tinyint] NULL,
[Request_DateTime] [datetime] NULL,
[Opr_DateTime] [datetime] NULL,
[Opr_Status] [smallint] NULL,
[Opr_Retry] [tinyint] NULL,
[LoginID] [nvarchar](100) NULL,
[Meter_SN] [varchar](10) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

5. Now in customer PC(SQL) Open New Query window & paste above mentioned query.
6. Execute the query & refresh database. Now table has been created in Customer SQL ELNet DB.
7. Perform recharge & check LOG event.