﻿DELETE FROM [Transaction] where ID in (200000001, 200000002, 200000003, 200000004, 200000005)

SET IDENTITY_INSERT [dbo].[Transaction] ON 

INSERT [dbo].[Transaction] 
([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
VALUES (200000001, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)

INSERT [dbo].[Transaction] 
([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
VALUES (200000002, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction 2', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)

INSERT [dbo].[Transaction] 
([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
VALUES (200000003, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction 3', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)

INSERT [dbo].[Transaction] 
([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
VALUES (200000004, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction 4', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)

INSERT [dbo].[Transaction] 
([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
VALUES (200000005, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction 5', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)


SET IDENTITY_INSERT [dbo].[Transaction] OFF
