Ana Sayfa Keşfet Yardım
Giriş Yap
paul
/
gps.docker
1
0
Çatalla 0
Dosyalar Sorunlar 0 Değişiklik İstekleri 0 Wiki
Ağaç: 171bbf76d0
Dallar Biçim İmleri
gps.docker
/
daldb
/
SeedData
/
Tier2
/
Transaction.sql

Transaction.sql 66 KB
Geçmiş Ham

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465 
  1. DELETE FROM [Transaction] where ID in (1000000026,1000000027,1000000028,900000001,900000002,900000003,900000004,900000005,900000006,900000007,900000008,900000009,900000010,900000011,900000012,900000013,900000014,900000015,900000016,900000017,900000018,900000019,900000020,900000021,900000022,900000023,900000024,900000025,900000026,900000027,900000028,900000029,900000030,900000031, 900000032)
    2. 

  2. DELETE FROM [Transaction] where ID in (300000001, 300000002)
    3. 

  3. DELETE FROM [Transaction] where ID in (800000001,800000002,800000003,800000004,800000005,800000006,800000007,800000008,800000009,800000010, 800000011, 900000029,900000030,900000031)
    4. 

  4. DELETE FROM [Transaction] where ID in (8000000001,8000000002,8000000003,8000000004,8000000005,8000000006,8000000007,8000000008,8000000009,8000000010, 8000000011, 9000000029,9000000030,9000000031,9000000001,9000000002,9000000003,9000000004,9000000005,9000000006,9000000007,9000000008,9000000009,9000000010,9000000011,9000000012,9000000013,9000000014,9000000015,9000000016,9000000017,9000000018,9000000019,9000000020,9000000021,9000000022,9000000023,9000000024,9000000025,9000000026,9000000027,9000000028,9000000029,9000000030,9000000031, 9000000032)
    5. 

  5. 

  6. 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 (1000000026, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-02T12: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'ProductId Based 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)
    7. 

  7. 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 (1000000027, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-02T12:06:15.347' AS DateTime), N'826', CAST(20.00 AS Decimal(9, 2)), N'ETU*DISSERTS.COM       310-9190902   CA ', N'00', N'00', N'D', 214786495, N'A', 30.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(938.40 AS Decimal(9, 2)), CAST(00.00 AS Decimal(9, 2)), 1, N'000000', 0, 0, 0, N'705948', N'ProductId Based Transaction', N'0', CAST(2.00 AS Decimal(9, 2)), CAST(0.40 AS Decimal(9, 2)), CAST(0.20 AS Decimal(9, 2)), CAST(0.20 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', NULL, NULL, NULL, NULL, N'BNET-20210101-MCC208538', NULL)
    8. 

  8. 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 (1000000028, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-02T12:06:15.347' AS DateTime), N'144', CAST(20.00 AS Decimal(9, 2)), N'ETU*DISSERTS.COM       310-9190902   CA ', N'00', N'00', N'A', 214786495, N'A', 30.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(10000.00 AS Decimal(9, 2)), CAST(-6543.60 AS Decimal(9, 2)), -1, N'000000', 0, 0, 0, N'705948', N'ProductId Based Transaction', N'0', CAST(2.00 AS Decimal(9, 2)), CAST(0.04 AS Decimal(9, 2)), CAST(0.20 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.20 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'000', NULL, NULL, NULL, N'BNET-20210101-MCC208538', NULL)
    9. 

  9. 

  10. 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 (900000001, 3161298874256, CAST(N'2015-07-17T16:21:40.790' AS DateTime), CAST(N'2015-07-17T16:21:40.790' AS DateTime), N'978', CAST(100.00 AS Decimal(9, 2)), N'Test Load', N'00', N'00', N'B', 0, N'S', 100.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(100.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'021000', 0, 0, 0, NULL, N'Test Load', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 60068824, CAST(100.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    11. 

  11. 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 (900000002, 3187007310413960, CAST(N'2018-11-23T04:36:22.093' AS DateTime), CAST(N'2018-11-23T04:36:22.093' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'Primary Card Activation Fee. Posted date - Nov 23 2018  4:36AM', N'00', N'00', N'P', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(97.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 0, N'087999', NULL, 0, 0, N'16582093', N'Fees', N'', CAST(3.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 507967, 2295703716, CAST(0.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    12. 

  12. 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 (900000003, 3187009719671308, CAST(N'2018-11-23T04:36:31.517' AS DateTime), CAST(N'2018-11-23T04:36:31.517' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'Card Issue Fee (Physical) . Posted date - Nov 23 2018  4:36AM', N'00', N'00', N'P', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(96.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 0, N'082999', NULL, 0, 0, N'16591516', N'Fees', N'', CAST(1.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 507972, 2295703723, CAST(0.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    13. 

  13. 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 (900000004, 3425138996040927, CAST(N'2018-11-23T05:14:44.543' AS DateTime), CAST(N'2018-11-23T05:14:44.440' AS DateTime), N'144', CAST(20.00 AS Decimal(9, 2)), N'Visa Test                               ', N'00', N'00', N'D', 157349645, N'A', 30.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(5.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'000000', NULL, NULL, 0, N'918200', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(1.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'', 0, 181123918199323232, CAST(20.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'', NULL)
    14. 

  14. 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 (900000005, 3189555214291380, CAST(N'2018-11-23T07:11:31.743' AS DateTime), CAST(N'2018-11-23T07:11:31.737' AS DateTime), N'840', CAST(5.50 AS Decimal(9, 2)), N'Unload Online card transfer to 955738523 - By user - jishnu', N'00', N'00', N'U', 0, N'S', 5.5000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(391.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'230000', 0, 14, 0, N'25891620', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 2295703901, CAST(5.50 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    15. 

  15. 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 (900000006, 8068355351794216, CAST(N'2018-11-26T20:41:20.643' AS DateTime), CAST(N'2018-11-26T20:41:20.483' AS DateTime), N'826', CAST(120.00 AS Decimal(9, 2)), N'Load', N'00', N'00', N'L', 0, N'S', 120.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 14, 0, N'74480643', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 2295709111, CAST(120.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, NULL)
    16. 

  16. 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 (900000007, 3425138996040927, CAST(N'2018-11-26T20:41:23.890' AS DateTime), CAST(N'2018-11-26T20:41:23.883' AS DateTime), N'826', CAST(1.00 AS Decimal(9, 2)), N'AutomationNote', N'14', N'14', N'B', 0, N'S', 1.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(1.00 AS Decimal(9, 2)), CAST(19.00 AS Decimal(9, 2)), 1, N'021000', 0, 0, 0, NULL, N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 2295709112, CAST(1.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, NULL)
    17. 

  17. 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 (900000008, 8068355707321776, CAST(N'2019-12-31T20:42:26.810' AS DateTime), CAST(N'2019-12-31T20:42:26.810' AS DateTime), N'826', CAST(20.00 AS Decimal(9, 2)), N'Boundary Test Transaction. Do not change Pan or Date', N'00', N'00', N'A', 157352360, N'I', 20.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'565841', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 181126565841323232, CAST(20.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC251491', NULL)
    18. 

  18. 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 (900000009, 7591229857767875, CAST(N'2018-11-26T20:51:20.733' AS DateTime), CAST(N'2018-11-26T20:51:20.733' AS DateTime), N'036', CAST(10.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'A', 157352470, N'C', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'513493', N' ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 181126513493323232, CAST(10.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC671219', NULL)
    19. 

  19. 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 (900000010, 6771083486022888, CAST(N'2018-11-27T05:57:27.260' AS DateTime), CAST(N'2018-11-27T05:57:27.153' AS DateTime), N'826', CAST(15.00 AS Decimal(9, 2)), N'PT:PTPOUT : ;SC:556666;Acc:00049963;Name:TestUser XYZ      ;Ref:1;DDR:;', N'00', N'00', N'G', 102388, N'S', 15.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(90.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'160000', 0, 0, 0, N'', N'', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 2295710503, CAST(15.00 AS Decimal(9, 2)), N'', N'826', N'826', N'16', N'00', N'00', NULL, NULL)
    20. 

  20. 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 (900000011, 5179762040643138, CAST(N'2018-11-27T08:54:17.280' AS DateTime), CAST(N'2018-11-27T08:54:17.277' AS DateTime), N'862', CAST(3.00 AS Decimal(9, 2)), N'ACQUIRER NAME            CITY NAME    GB', N'00', N'00', N'A', 157353033, N'I', 3.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(462.82 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'000135', N'DR: MDES Invalid Card Number - payment_token not found', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 181127000135234567, CAST(0.00 AS Decimal(9, 2)), N'', N'   ', N'   ', N'00', N'00', N'00', N'VIS1-20181127-318331061370136', NULL)
    21. 

  21. 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 (900000012, 3173040045066091, CAST(N'2018-11-27T13:25:36.960' AS DateTime), CAST(N'2018-11-27T13:25:36.960' AS DateTime), N'826', CAST(62.27 AS Decimal(9, 2)), N'The Local Bank  part   London         GB', N'10', N'10', N'A', 157353095, N'A', 11.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(110.00 AS Decimal(9, 2)), CAST(-107.51 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'246461', N'GEN: AUTOMATIC AUTHORISATION REMOVALDR: Auth Amount      :200.00 PaddingAmount    :10.00 (Padding 5.00%)  Total            :210.00 Available Amount :68.00        Partial Approve! - Auth Removed', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(3.24 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 181127246461280719, CAST(200.00 AS Decimal(9, 2)), N'', N'978', N'978', N'00', N'00', N'00', N'BNET-20181127-MCC248324', NULL)
    22. 

  22. 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 (900000013, 3186762710517944, CAST(N'2018-11-28T08:29:50.817' AS DateTime), CAST(N'2018-11-28T08:29:50.580' AS DateTime), N'840', CAST(5.00 AS Decimal(9, 2)), N'DEV_MT_MC-148 Mrchnt C\\try  CANBERRA\             IND', N'00', N'00', N'C', 1241, N'S', 5.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(83.70 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'010000', 0, 0, 0, N'', N'ChargeBack - Credit to Card', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 181128012666123456, CAST(5.00 AS Decimal(9, 2)), N'', N'840', N'840', N'01', N'00', N'00', N'', NULL)
    23. 

  23. 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 (900000014, 3187157797424494, CAST(N'2018-11-28T13:31:37.553' AS DateTime), CAST(N'2018-11-28T13:31:37.553' AS DateTime), N'840', CAST(4.00 AS Decimal(9, 2)), N'Load', N'00', N'00', N'L', 0, N'S', 4.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(323.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 139, 0, N'48697553', N'Web service load by - jishnu, Source - 210.18.59.21, Date - Nov 28 2018  1:31PM', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 2295712572, CAST(4.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    24. 

  24. 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 (900000015, 3178042060841493, CAST(N'2018-11-29T08:47:43.267' AS DateTime), CAST(N'2018-11-29T08:47:41.443' AS DateTime), N'978', CAST(10.00 AS Decimal(9, 2)), N'ETU*DISSERTS.COM\\310-9190902\             CA', N'00', N'00', N'E', 1225230, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(500.00 AS Decimal(9, 2)), CAST(-36.30 AS Decimal(9, 2)), 1, N'000000', NULL, NULL, 0, N'288505', N'Presentment Reversal, Retrieval Reference Number - 000047461076', N'', CAST(2.00 AS Decimal(9, 2)), CAST(0.10 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N' CA', 509223, 181129288505002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', N'00', N'00', N'00', N'', NULL)
    25. 

  25. 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 (900000016, 1751144528024763, CAST(N'2018-12-17T12:19:01.963' AS DateTime), CAST(N'2018-12-17T12:20:26.103' AS DateTime), N'826', CAST(0.00 AS Decimal(9, 2)), N'Monthly Fee - Following reload', N'00', N'00', N'P', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(495.00 AS Decimal(9, 2)), CAST(19.00 AS Decimal(9, 2)), 0, N'999999', NULL, NULL, 0, N'0', N'Monthly Fee - Following reload', N'0', CAST(2.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 513271, 0, CAST(0.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, NULL)
    26. 

  26. 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 (900000017, 3187669174638864, CAST(N'2018-12-18T13:51:10.393' AS DateTime), CAST(N'2018-12-18T13:51:10.393' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'Load fee : POS Standard', N'00', N'00', N'P', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(39.15 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 0, N'001999', NULL, 0, 0, N'49870393', N'Fees', N'', CAST(30.00 AS Decimal(9, 2)), CAST(10.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 534047, 2296823504, CAST(0.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    27. 

  27. 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 (900000018, 3187674948643514, CAST(N'2018-12-18T14:02:27.320' AS DateTime), CAST(N'2018-12-18T14:02:27.320' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'Load fee : POS Standard', N'00', N'00', N'P', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(67.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 0, N'001999', NULL, 0, 0, N'50547320', N'Fees', N'', CAST(30.00 AS Decimal(9, 2)), CAST(1.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 534050, 2296823510, CAST(0.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    28. 

  28. 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 (900000019, 6771096490339182, CAST(N'2019-01-04T08:49:19.613' AS DateTime), CAST(N'2019-01-04T08:49:19.610' AS DateTime), N'826', CAST(120.00 AS Decimal(9, 2)), N'PT:PTPOUT : ;SC:556666;Acc:00051459;Name:TestUser XYZ      ;Ref:1;DDR:;', N'00', N'00', N'G', 102657, N'V', 120.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'160000', 0, 0, 0, N'', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 2297071657, CAST(120.00 AS Decimal(9, 2)), N'', N'826', N'826', N'16', N'00', N'00', NULL, NULL)
    29. 

  29. 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 (900000020, 5179762040643138, CAST(N'2019-02-07T09:17:15.037' AS DateTime), CAST(N'2019-02-07T09:17:15.027' AS DateTime), N'978', CAST(20.00 AS Decimal(9, 2)), N'v  User - Kevin.I Date - 07-02-2019 14:46:23 ', N'00', N'00', N'L', 0, N'S', 20.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(25.56 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 0, 11, 0, N'33434910', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 2297659415, CAST(0.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    30. 

  30. 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 (900000021, 2469036722636631, CAST(N'2019-02-12T06:48:16.930' AS DateTime), CAST(N'2019-02-12T06:48:15.260' AS DateTime), N'978', CAST(10.00 AS Decimal(9, 2)), N'ETU*DISSERTS.COM\\310-9190902\             CA', N'00', N'00', N'N', 1480868, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(940.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N' CA', 0, 1190212978571002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', N'00', N'00', N'00', N'', NULL)
    31. 

  31. 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 (900000022, 3188217694541622, CAST(N'2019-02-16T12:25:14.857' AS DateTime), CAST(N'2019-02-16T12:25:14.857' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'Unload fee : Card Processor', N'00', N'00', N'P', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(498.56 AS Decimal(9, 2)), CAST(-8.20 AS Decimal(9, 2)), 0, N'004999', NULL, 0, 0, N'44714856', N'Fees', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.11 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 550586, 2297719497, CAST(0.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    32. 

  32. 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 (900000023, 6905342138769450, CAST(N'2019-03-11T13:34:33.900' AS DateTime), CAST(N'2019-03-11T13:34:33.900' AS DateTime), N'8  ', CAST(100.00 AS Decimal(9, 2)), N'Load', N'00', N'00', N'L', 0, N'S', 100.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(100.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 118, 3, N'48873900', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 2298360671, CAST(100.00 AS Decimal(9, 2)), N'', N'8  ', N'8  ', NULL, NULL, NULL, NULL, NULL)
    33. 

  33. 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 (900000024, 3186762710517944, CAST(N'2019-03-27T14:23:21.157' AS DateTime), CAST(N'2019-03-27T14:23:21.157' AS DateTime), N'840', CAST(72.87 AS Decimal(9, 2)), N'DEV_MT_MC-148 Mrchnt Cntry  CANBERRA IND', N'05', N'05', N'H', 159726666, N'I', 72.8700, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(500.00 AS Decimal(9, 2)), CAST(-476.15 AS Decimal(9, 2)), -1, N'010000', NULL, NULL, 0, N'530730', N'ProductId Based Transaction', N'', CAST(1.70 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'IND', 565220, 190327530730123456, CAST(72.87 AS Decimal(9, 2)), N'', N'840', N'840', N'01', N'00', N'00', N'BNET-20190327-MDHMQAHBU103', NULL)
    34. 

  34. 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 (900000025, 3421000591551411, CAST(N'2019-04-07T16:26:56.280' AS DateTime), CAST(N'2019-04-07T16:26:56.280' AS DateTime), N'826', CAST(20.00 AS Decimal(9, 2)), N'Visa Test                               ', N'05', N'05', N'K', 159747307, N'I', 20.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(39.30 AS Decimal(9, 2)), CAST(-11.14 AS Decimal(9, 2)), -1, N'010000', NULL, NULL, 0, N'928754', N'ProductId Based Transaction', N'', CAST(5.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'', 571143, 190407928754323232, CAST(20.00 AS Decimal(9, 2)), N'', N'826', N'826', N'01', N'00', N'00', N'VIS1-20191231-000000000930929', NULL)
    35. 

  35. 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 (900000026, 7598406073257928, CAST(N'2019-04-08T10:47:19.397' AS DateTime), CAST(N'2019-04-08T10:47:19.397' AS DateTime), N'826', CAST(0.00 AS Decimal(9, 2)), N'Card Expiry', N'00', N'54', N'Y', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(500.00 AS Decimal(9, 2)), CAST(19.00 AS Decimal(9, 2)), -1, N'230000', NULL, NULL, 0, NULL, N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 2298653957, CAST(0.00 AS Decimal(9, 2)), N'', N'826', N'826', N'23', N'00', N'00', NULL, NULL)
    36. 

  36. 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 (900000027, 7598406073257928, CAST(N'2019-04-27T03:20:17.607' AS DateTime), CAST(N'2019-04-27T03:20:17.607' AS DateTime), N'826', CAST(120.00 AS Decimal(9, 2)), N'Load', N'00', N'00', N'L', 0, N'S', 120.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 14, 0, N'12017606', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 2298729034, CAST(120.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, NULL)
    37. 

  37. 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 (900000028, 7598406073257928, CAST(N'2019-04-27T03:20:21.460' AS DateTime), CAST(N'2019-04-27T03:20:21.460' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'A', 159765341, N'C', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'917688', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 190427917688323232, CAST(10.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC328793', NULL)
    38. 

  38. 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 (900000029, 7598406073257928, CAST(N'2019-04-27T03:20:27.327' AS DateTime), CAST(N'2019-04-27T03:20:27.327' AS DateTime), N'826', CAST(21.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'A', 159765342, N'C', 21.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(-36.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'328323', N'ProductId Based Transaction', N'', CAST(5.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 577926, 190427328323323232, CAST(21.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC496171', NULL)
    39. 

  39. 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 (900000030, 7598406073257928, CAST(N'2019-04-27T03:20:31.477' AS DateTime), CAST(N'2019-04-27T03:20:30.903' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'P', 1753549, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(110.00 AS Decimal(9, 2)), CAST(-26.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'917688', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 190427917688323232, CAST(10.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC328793', NULL)
    40. 

  40. 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 (900000031, 7598406073257928, CAST(N'2019-04-27T03:20:31.477' AS DateTime), CAST(N'2019-04-27T03:20:30.913' AS DateTime), N'826', CAST(21.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'P', 1753550, N'S', 21.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(84.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'328323', N'ProductId Based Transaction', N'', CAST(5.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 577926, 190427328323323232, CAST(21.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC496171', NULL)
    41. 

  41. 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 (900000032, 8068355707321776, CAST(N'2010-07-20T20:42:26.810' AS DateTime), CAST(N'2010-07-20T20:42:26.810' AS DateTime), N'826', CAST(20.00 AS Decimal(9, 2)), N'Boundary Test Transaction. Do not change Pan or Date', N'00', N'00', N'A', 157352360, N'I', 20.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'565841', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 181126565841323232, CAST(20.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC251491', NULL)
    42. 

  42. 

  43. INSERT [dbo].[Transaction] 
    44. 

  44. ([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])
    45. 

  45. VALUES (300000001, 3211927544494378, CAST(N'2019-10-01T12:06:15.440' AS DateTime), CAST(N'2019-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 Cold 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)
    46. 

  46. 

  47. INSERT [dbo].[Transaction] 
    48. 

  48. ([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])
    49. 

  49. VALUES (300000002, 3211927544494378, CAST(N'2019-10-01T12:06:15.440' AS DateTime), CAST(N'2019-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 Cold 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)
    50. 

  50. 

  51. 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 (900000029, 7598406073257928, CAST(N'2010-04-27T03:20:27.327' AS DateTime), CAST(N'2010-04-27T03:20:27.327' AS DateTime), N'826', CAST(21.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'A', 159765342, N'C', 21.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(-36.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'328323', N'', N'', CAST(5.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 577926, 190427328323323232, CAST(21.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC496171', NULL)
    52. 

  52. 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 (900000030, 7598406073257928, CAST(N'2010-04-27T03:20:31.477' AS DateTime), CAST(N'2010-04-27T03:20:30.903' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'P', 1753549, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(110.00 AS Decimal(9, 2)), CAST(-26.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'917688', N'', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 190427917688323232, CAST(10.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC328793', NULL)
    53. 

  53. 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 (900000031, 7598406073257928, CAST(N'2010-04-27T03:20:31.477' AS DateTime), CAST(N'2010-04-27T03:20:30.913' AS DateTime), N'826', CAST(21.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'P', 1753550, N'S', 21.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(84.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'328323', N'', N'', CAST(5.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 577926, 190427328323323232, CAST(21.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC496171', NULL)
    54. 

  54. 

  55. 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 (800000001, 3161298874256, CAST(N'2010-07-17T16:21:40.790' AS DateTime), CAST(N'2010-07-17T16:21:40.790' AS DateTime), N'978', CAST(100.00 AS Decimal(9, 2)), N'Test Load', N'00', N'00', N'B', 0, N'S', 100.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(100.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'021000', 0, 0, 0, NULL, N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 60068824, CAST(100.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    56. 

  56. 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 (800000002, 3187007310413960, CAST(N'2009-11-23T04:36:22.093' AS DateTime), CAST(N'2009-11-23T04:36:22.093' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'Primary Card Activation Fee. Posted date - Nov 23 2018  4:36AM', N'00', N'00', N'P', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(97.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 0, N'087999', NULL, 0, 0, N'16582093', N'ProductId Based Transaction', N'', CAST(3.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 507967, 2295703716, CAST(0.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    57. 

  57. 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 (800000003, 3187009719671308, CAST(N'2009-11-23T04:36:31.517' AS DateTime), CAST(N'2009-11-23T04:36:31.517' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'Card Issue Fee (Physical) . Posted date - Nov 23 2018  4:36AM', N'00', N'00', N'P', 0, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(96.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 0, N'082999', NULL, 0, 0, N'16591516', N'ProductId Based Transaction', N'', CAST(1.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 507972, 2295703723, CAST(0.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    58. 

  58. 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 (800000004, 3425138996040927, CAST(N'2009-11-23T05:14:44.543' AS DateTime), CAST(N'2009-11-23T05:14:44.440' AS DateTime), N'144', CAST(20.00 AS Decimal(9, 2)), N'Visa Test                               ', N'00', N'00', N'D', 157349645, N'A', 30.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(5.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'000000', NULL, NULL, 0, N'918200', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(1.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'', 0, 181123918199323232, CAST(20.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'', NULL)
    59. 

  59. 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 (800000005, 3189555214291380, CAST(N'2009-11-23T07:11:31.743' AS DateTime), CAST(N'2009-11-23T07:11:31.737' AS DateTime), N'840', CAST(5.50 AS Decimal(9, 2)), N'Unload Online card transfer to 955738523 - By user - jishnu', N'00', N'00', N'U', 0, N'S', 5.5000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(391.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'230000', 0, 14, 0, N'25891620', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 2295703901, CAST(5.50 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    60. 

  60. 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 (800000006, 8068355351794216, CAST(N'2009-11-26T20:41:20.643' AS DateTime), CAST(N'2009-11-26T20:41:20.483' AS DateTime), N'826', CAST(120.00 AS Decimal(9, 2)), N'Load', N'00', N'00', N'L', 0, N'S', 120.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 14, 0, N'74480643', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 2295709111, CAST(120.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, NULL)
    61. 

  61. 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 (800000007, 3425138996040927, CAST(N'2009-11-26T20:41:23.890' AS DateTime), CAST(N'2009-11-26T20:41:23.883' AS DateTime), N'826', CAST(1.00 AS Decimal(9, 2)), N'AutomationNote', N'14', N'14', N'B', 0, N'S', 1.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(1.00 AS Decimal(9, 2)), CAST(19.00 AS Decimal(9, 2)), 1, N'021000', 0, 0, 0, NULL, N'AutomationNote', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 2295709112, CAST(1.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, NULL)
    62. 

  62. 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 (800000008, 8068355707321776, CAST(N'2010-07-18T20:42:26.810' AS DateTime), CAST(N'2010-07-18T20:42:26.810' AS DateTime), N'826', CAST(20.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'A', 157352360, N'I', 20.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'565841', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 181126565841323232, CAST(20.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC251491', NULL)
    63. 

  63. 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 (800000009, 7591229857767875, CAST(N'2009-11-26T20:51:20.733' AS DateTime), CAST(N'2009-11-26T20:51:20.733' AS DateTime), N'036', CAST(10.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'A', 157352470, N'C', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'513493', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 181126513493323232, CAST(10.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC671219', NULL)
    64. 

  64. 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 (800000010, 8068355707321776, CAST(N'2012-11-18T20:42:26.810' AS DateTime), CAST(N'2012-11-18T20:42:26.810' AS DateTime), N'826', CAST(25.00 AS Decimal(9, 2)), N'The Local Bank         London         GB', N'00', N'00', N'A', 157352360, N'I', 20.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(120.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'565841', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 181126565841323232, CAST(20.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC251491', NULL)
    65. 

  65. 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 (800000011, 3161298874256, CAST(N'2012-11-17T16:21:40.790' AS DateTime), CAST(N'2012-11-17T16:21:40.790' AS DateTime), N'978', CAST(100.00 AS Decimal(9, 2)), N'Test Load', N'00', N'00', N'B', 0, N'S', 100.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(100.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'021000', 0, 0, 0, NULL, N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 60068824, CAST(100.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    66.