table nischal

 USE [PPIVThailiCOA]

GO

/****** Object:  Table [dbo].[MNPumoriReconciliation]    Script Date: 2021-07-30 05:10:17 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MNPumoriReconciliation](

[ID] [int] IDENTITY(1,1) NOT NULL,

[ServiceCode] [varchar](10) NULL,

[SourceMobileNo] [varchar](15) NULL,

[DestinationMobileNo] [varchar](15) NULL,

[Amount] [money] NULL,

[TranType] [varchar](50) NULL,

[Desc1] [varchar](255) NULL,

[Desc2] [varchar](255) NULL,

[Desc3] [varchar](255) NULL,

[BranchCode] [varchar](15) NULL,

[Status] [varchar](20) NULL,

[CreatedBy] [varchar](255) NULL,

[CreatedDate] [datetime] NULL,

[ApprovedBy] [varchar](255) NULL,

[ApprovedDate] [datetime] NULL,

[RejectedBy] [varchar](255) NULL,

[RejectedDate] [datetime] NULL,

[UpdatedBy] [varchar](255) NULL,

[UpdatedDate] [datetime] NULL,

[Type] [varchar](30) NULL,

[BulkID] [int] NULL,

[Remarks] [varchar](255) NULL,

PRIMARY KEY CLUSTERED 

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[MNPumoriReconciliation] ON 

GO

INSERT [dbo].[MNPumoriReconciliation] ([ID], [ServiceCode], [SourceMobileNo], [DestinationMobileNo], [Amount], [TranType], [Desc1], [Desc2], [Desc3], [BranchCode], [Status], [CreatedBy], [CreatedDate], [ApprovedBy], [ApprovedDate], [RejectedBy], [RejectedDate], [UpdatedBy], [UpdatedDate], [Type], [BulkID], [Remarks]) VALUES (1, N'00', NULL, N'9843087693', 1.0000, N'Debit', N'Debit from financial acc', N'', N'', N'001', N'Created', N'MNepal', CAST(N'2021-07-30T17:08:17.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, N'bulk', 1, NULL)

GO

INSERT [dbo].[MNPumoriReconciliation] ([ID], [ServiceCode], [SourceMobileNo], [DestinationMobileNo], [Amount], [TranType], [Desc1], [Desc2], [Desc3], [BranchCode], [Status], [CreatedBy], [CreatedDate], [ApprovedBy], [ApprovedDate], [RejectedBy], [RejectedDate], [UpdatedBy], [UpdatedDate], [Type], [BulkID], [Remarks]) VALUES (2, N'00', N'9843087693', NULL, 99.0000, N'Credit', N'credit from financial acc', N'', N'', N'001', N'Created', N'MNepal', CAST(N'2021-07-30T17:08:17.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, N'bulk', 1, NULL)

GO

INSERT [dbo].[MNPumoriReconciliation] ([ID], [ServiceCode], [SourceMobileNo], [DestinationMobileNo], [Amount], [TranType], [Desc1], [Desc2], [Desc3], [BranchCode], [Status], [CreatedBy], [CreatedDate], [ApprovedBy], [ApprovedDate], [RejectedBy], [RejectedDate], [UpdatedBy], [UpdatedDate], [Type], [BulkID], [Remarks]) VALUES (3, N'00', N'9843087693', N'9840095816', 1.0000, N'DebitAndCredit', N'debit and credit from users'' acc', N'', N'', N'001', N'Created', N'MNepal', CAST(N'2021-07-30T17:08:17.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, N'bulk', 1, NULL)

GO

SET IDENTITY_INSERT [dbo].[MNPumoriReconciliation] OFF

GO