Strona główna Odkrywaj Pomoc
Zaloguj się
paul
/
gps.docker
1
0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki
Drzewo: 171bbf76d0
Gałęzie Tagi
gps.docker
/
daldb
/
SeedData
/
AlexisPTSTest
/
TransactionTable.sql

TransactionTable.sql 37 KB
Historia Czysty

1234567891011121314151617181920212223242526272829303132333435 
  1. DELETE FROM [Transaction] where ID in (1000000001,1000000002,1000000003,1000000004,1000000005,1000000006,1000000007,1000000008,1000000009,1000000010,1000000011,1000000012,1000000013,1000000014,1000000015,1000000016,1000000017,1000000018,1000000019,1000000020,1000000021,1000000022,1000000023,1000000024,1000000025,1000000026,1000000027,1000000028, 1000000029)
    2. 

  2. 

  3. SET IDENTITY_INSERT [dbo].[Transaction] ON 
    4. 

  4. 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 (1000000001, 3211927766605038, CAST(N'2020-11-12T13:39:54.507' AS DateTime), CAST(N'2020-11-11T18:00:00.000' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'Load', N'00', N'00', N'L', 0, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(10.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 14, 0, N'49194506', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(112.53 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, 6150036435, CAST(10.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, NULL)
    5. 

  5. 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], [WalletID], [AccountID]) VALUES (1000000002, 3211927622936488, CAST(N'2020-11-12T13:43:08.610' AS DateTime), CAST(N'2020-11-12T13:43:08.593' AS DateTime), N'826', CAST(11.89 AS Decimal(9, 2)), N'PT:FPIN : ;SC:000000;Acc:70292659;Name:InboundTest;Ref:PaymentRef                                                                                     ', N'00', N'00', N'G', 119273, N'S', 11.8900, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(21.89 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'290000', 0, 0, 0, N'0', N'000000 70292659 InboundTest', 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, 6150036442, CAST(11.89 AS Decimal(9, 2)), N'', N'826', N'826', N'29', N'00', N'00', 'BNET-20181013-MCC194167', NULL, 6, 2001)
    6. 

  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 (1000000003, 3211927766605038, CAST(N'2020-11-12T13:43:17.187' AS DateTime), CAST(N'2020-11-11T18:00:00.000' AS DateTime), N'826', CAST(0.00 AS Decimal(9, 2)), N'Loading bank transaction 119274 to suspense account for investigation', N'00', N'00', N'L', 119274, N'S', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(267806.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 0, 0, 0, N'', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(2.09 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, 6150036445, CAST(0.00 AS Decimal(9, 2)), N'', N'826', N'826', N'22', N'00', N'00', 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 (1000000004, 3211927622936488, CAST(N'2020-11-14T11:33:57.963' AS DateTime), CAST(N'2020-11-13T11:33:57.947' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'Load', N'00', N'00', N'L', 0, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(10.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 14, 0, N'41637963', N'ProductId Based Transaction', NULL, 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)), CAST(0.00 AS Decimal(9, 2)), N'GBR', 0, 6150036452, CAST(10.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, 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 (1000000005, 2494697286281, CAST(N'2020-11-14T04:36:21.890' AS DateTime), CAST(N'2020-11-14T04:36:21.823' AS DateTime), N'840', 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, 14, 0, N'16581890', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(-0.88 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, 2295703715, CAST(100.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, NULL)
    9. 

  9. 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 (1000000006, 3161298874256, CAST(N'2020-11-14T04:36:22.093' AS DateTime), CAST(N'2020-11-14T04: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)
    10. 

  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 (1000000007, 3161318282514, CAST(N'2020-11-14T04:36:28.693' AS DateTime), CAST(N'2020-11-14T04:36:28.690' AS DateTime), N'840', CAST(100.00 AS Decimal(9, 2)), N'! ^&)#', 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, 14, 0, N'16588693', 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, 2295703718, CAST(100.00 AS Decimal(9, 2)), N'', N'840', N'840', 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 (1000000008, 3161371085730, CAST(N'2020-11-14T04:36:28.737' AS DateTime), CAST(N'2020-11-14T04:36:28.737' 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'16588736', 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, 507969, 2295703719, 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 (1000000009, 3161371085730, CAST(N'2020-11-14T04:36:28.790' AS DateTime), CAST(N'2020-11-14T04:36:28.790' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'', 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'16588790', 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, 507970, 2295703720, 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 (1000000010, 3162000111416, CAST(N'2020-11-14T05:51:29.143' AS DateTime), CAST(N'2020-11-14T05:51:29.143' AS DateTime), N'840', CAST(10.00 AS Decimal(9, 2)), N'DEV_MT_MC-148 Mrchnt Cntry  CANBERRA IND', N'00', N'00', N'A', 0, N'I', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(540.00 AS Decimal(9, 2)), CAST(-1.00 AS Decimal(9, 2)), -1, N'010000', NULL, NULL, 0, N'012487', 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'IND', 0, 181123012487123456, CAST(10.00 AS Decimal(9, 2)), N'', N'840', N'840', NULL, NULL, NULL, NULL, 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 (1000000011, 3162189240263, CAST(N'2020-11-14T09:45:15.380' AS DateTime), CAST(N'2020-11-14T09:45:15.380' AS DateTime), N'840', CAST(0.00 AS Decimal(9, 2)), N'HSBC Bank       WestLondon           GB ', N'00', N'00', N'A', 0, N'I', 0.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 0, N'300000', NULL, NULL, 0, N'664018', 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, 181123664018323232, CAST(0.00 AS Decimal(9, 2)), N'', N'826', N'826', 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 (1000000012, 3162224992568, CAST(N'2020-11-14T16:47:23.820' AS DateTime), CAST(N'2020-11-14T16:47:23.820' AS DateTime), N'826', CAST(200.00 AS Decimal(9, 2)), N'Pati''s Shop London                      ', N'00', N'00', N'A', 157350041, N'A', 200.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(961.36 AS Decimal(9, 2)), CAST(-961.36 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, 0, N'288127', N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.03 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), NULL, 0, 181123288127323232, CAST(200.00 AS Decimal(9, 2)), N'', N'826', N'826', N'00', N'00', N'00', N'BNET-20181013-MCC991027', 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 (1000000013, 3162224992568, CAST(N'2020-11-14T10:15:23.890' AS DateTime), CAST(N'2020-11-14T10:15:23.887' AS DateTime), N'826', CAST(120.00 AS Decimal(9, 2)), N'                                          ', N'00', N'00', N'G', 102424, 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, 2295710622, CAST(120.00 AS Decimal(9, 2)), N'', N'826', N'826', N'16', N'00', N'00', 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 (1000000014, 3162264014022, CAST(N'2020-11-14T12:04:04.003' AS DateTime), CAST(N'2020-11-14T12:04:01.343' AS DateTime), N'036', CAST(1528.10 AS Decimal(9, 2)), N'OFFLINE - AHM\77 MARKET STREET\WOLLONGONG DC\2500         AUS', N'14', N'14', N'A', 1225809, N'C', 1528.1000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(0.00 AS Decimal(9, 2)), CAST(-1528.10 AS Decimal(9, 2)), -1, N'000000', NULL, NULL, NULL, NULL, N'ProductId Based Transaction', N'', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.02 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'AUS', 0, 1181129723465516000, CAST(1528.10 AS Decimal(9, 2)), N'', N'036', N'036', N'00', N'00', N'00', N'BNET-20181128-MCO0F52JJ', 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 (1000000015, 3161298874256, CAST(N'2021-01-14T12:06:15.440' AS DateTime), CAST(N'2020-11-14T12:06:15.347' AS DateTime), N'978', CAST(10.00 AS Decimal(9, 2)), N'ETU*DISSERTS.COM\\310-9190902\             CA ', N'00', N'00', N'C', 1489, N'S', 75.8800, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', 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)
    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 (1000000016, 3211927544494378, CAST(N'2021-01-12T13:39:54.507' AS DateTime), CAST(N'2021-01-11T18:00:00.000' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'Load With Unknown Billing Currency', N'00', N'00', N'L', 0, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(10.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 14, 0, N'49194506', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(112.53 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, 6150036435, CAST(10.00 AS Decimal(9, 2)), N'', N'000', N'826', NULL, NULL, NULL, 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 (1000000017, 3211927544494378, CAST(N'2021-01-12T13:39:54.507' AS DateTime), CAST(N'2021-01-11T18:00:00.000' AS DateTime), N'000', CAST(10.00 AS Decimal(9, 2)), N'Load With Unknown Transaction Currency', N'00', N'00', N'L', 0, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(10.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 14, 0, N'49194506', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(112.53 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, 6150036435, CAST(10.00 AS Decimal(9, 2)), N'', N'826', N'826', NULL, NULL, NULL, NULL, 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 (1000000018, 3211927544494378, CAST(N'2021-01-12T13:39:54.507' AS DateTime), CAST(N'2021-01-11T18:00:00.000' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'Load With Unknown Billing Currency', N'00', N'00', N'L', 0, N'S', 10.0000, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(10.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), 1, N'220000', 1, 14, 0, N'49194506', N'ProductId Based Transaction', NULL, CAST(0.00 AS Decimal(9, 2)), CAST(112.53 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, 6150036435, CAST(10.00 AS Decimal(9, 2)), N'', NULL, N'826', NULL, NULL, NULL, NULL, 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 (1000000019, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-02T12:06:15.347' AS DateTime), N'978', CAST(10.00 AS Decimal(9, 2)), N'ETU*DISSERTS.COM\\310-9190902\ CA ', N'00', N'00', N'J', 14890001, N'A', 75.8800, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', 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.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)
    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 (1000000020, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-02T12:06:15.347' AS DateTime), N'978', CAST(10.00 AS Decimal(9, 2)), N'ETU*DISSERTS.COM\\310-9190902\             CA ', N'00', N'00', N'C', 1489, N'S', 75.8800, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), -1, N'000000', 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)
    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 (1000000021, 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'Balance Update by Ws_BalanceUpdate WSID = 63732143', N'00', N'00', N'B', 28582698, N'S', 20.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(-10.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'660000', 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)
    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 (1000000022, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-02T12:06:15.347' AS DateTime), N'826', CAST(1.00 AS Decimal(9, 2)), N'OFFLINE - A&B<C>d\\\', N'00', N'00', N'A', 2147485924, N'C', 1.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(7100.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'000000', 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)
    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 (1000000023, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-02T12:06:15.347' AS DateTime), N'826', CAST(1.00 AS Decimal(9, 2)), N'A&B<C>d\\\', N'00', N'00', N'P', 2147485924, N'S', 1.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(20.00 AS Decimal(9, 2)), CAST(-8.00 AS Decimal(9, 2)), -1, N'000000', 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)
    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 (1000000024, 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', 2147927592, N'S', 20.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(-60.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'000000', 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)
    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 (1000000025, 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'00', N'00', N'A', 2147927660, 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)
    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 (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', 2147927660, 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)
    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 (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', 2147864952, 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)
    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 (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', 2147864952, 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)
    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 (1000000029, 8068355707321776, CAST(N'2020-01-01T20:42:26.810' AS DateTime), CAST(N'2020-01-01T20: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)
    33. 

  33. 

  34. 

  35. SET IDENTITY_INSERT [dbo].[Transaction] OFF
    36.