﻿DELETE FROM [TransactionAddDetails] where TransactionID between 1000000001 and 1000000029
DELETE FROM [TransactionAddDetails] where TransactionID in (800000001,800000002,800000003,800000004,800000005,800000006,800000007,800000008,800000009,800000010, 900000029,
900000030,900000031,900000032,900000001,900000002,900000003,900000004,900000005,900000006,900000007,
900000009,900000010,900000011,900000012,900000013,900000014,900000015,900000016,900000017,900000018,
900000019,900000020,900000021,900000022,900000023,900000024,900000025,900000026,900000027,900000028,
900000029,900000030,900000031,300000001,300000002,900000008);
DELETE FROM [TransactionAddDetails] where TransactionID in (8000000001,8000000002,8000000003,8000000004,8000000005,8000000006,8000000007,8000000008,8000000009,8000000010, 9000000029,
9000000030,9000000031,9000000032,9000000001,9000000002,9000000003,9000000004,9000000005,9000000006,9000000007,
9000000009,9000000010,9000000011,9000000012,9000000013,9000000014,9000000015,9000000016,9000000017,9000000018,
9000000019,9000000020,9000000021,9000000022,9000000023,9000000024,9000000025,9000000026,9000000027,9000000028,
9000000029,9000000030,9000000031,300000001,300000002,9000000008);

INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000001   ,'AC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant Name','Merchant Street','Merchant City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,'9C'        ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,'00'        ,'000000'       ,1000000001       ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000003   ,null     ,null       ,null     ,null  ,null       ,null            ,null           ,null,          null      ,null    ,null,null,null,null    ,null  ,null,null                   ,null             ,null           ,null                          ,null                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,null             ,null           ,null                             ,null                    ,null             ,null       ,null            ,null     ,null       ,null           ,null             ,null       ,null                     ,null                               ,null              ,null                    ,null                 ,null            ,null               ,null                ,null                    ,null                ,null                  ,null        ,null       ,null           ,null    ,null ,null          ,null            ,null               ,null                  ,null                 ,null               ,null             ,null                       ,null                   ,null                              ,null                       ,null                   ,null                ,null                 ,null );
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000005   ,'BC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant1','Merchant Street','Mercahnt City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,null       ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,null        ,null       ,1000000005     ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000006   ,'BC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant2','Merchant Street','Mercahnt City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,null       ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,null        ,null       ,1000000006      ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000007   ,'BC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant3','Merchant Street','Mercahnt City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,null       ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,null        ,null       ,1000000007      ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000008   ,'BC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant4','Merchant Street','Mercahnt City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,null       ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,null        ,null       ,1000000008       ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000009   ,'BC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant5','Merchant Street','Mercahnt City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,null       ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,null        ,null       ,1000000009       ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000010   ,'BC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant6','Merchant Street','Mercahnt City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,null       ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,null        ,null       ,1000000010       ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000011   ,'BC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant7','Merchant Street','Mercahnt City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,null       ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,null        ,null       ,null           ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (1000000012   ,'BC1'     ,'LoadedBy','S'     ,1.23  ,'Merchant8','Merchant Street','Mercahnt City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,null       ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,null        ,null       ,null           ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');


INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (800000002   ,'BC2'     ,'LoadedBy','S'     ,1.23  ,'Merchant Name','Merchant Street','Merchant City','X',          'ABC123'      ,'London'    ,'Telephone','Merchant Contact','http://merchant.com','Net Id'    ,'Tax Id'   ,'Merchant Other Name','0'                   ,'1'             ,'0'           ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'3'                          ,'0'              ,'0'          ,'1'                             ,'2'                    ,'A'             ,'0'      ,1           ,'2021-11-10'    ,1      ,2          ,0            ,'9C'        ,'0'                    ,'1'                              ,'12'             ,'10'                    ,'0'                ,'2'            ,'0'               ,'0'               ,'0'                   ,'1'               ,'6'                 ,'00'        ,'000000'       ,800000002       ,'111111UUUUUU1RFU'   ,'111111UUUUUU1RFU','IIIIIIIIIIIIIRFU'         ,1            ,0              ,0                  ,0                ,0               ,'826'            ,'826'                       ,1.23                  ,0.00                             ,1                      ,1                  ,'1234'               ,'1'                ,'3');
INSERT INTO TransactionAddDetails (TransactionID,BranchCode,LoadedBy  ,RateType,FxRate,Merch_Name ,Merch_Street     ,Merch_City     ,Merch_Region, Merch_Postcode,Merch_County,Merch_Tel  ,Merch_Contact     ,Merch_URL            ,Merch_Net_id,Merch_Tax_id,Merch_Name_Other    ,pos_cardholder_present,pos_card_present,pos_card_input,pos_cardholder_authen_method1,pos_cardholder_authen_entity1,pos_cardholder_authen_method2,pos_cardholder_authen_entity2,pos_cardholder_authen_method3,pos_cardholder_authen_entity3,pos_cardholder_authen_method4,pos_cardholder_authen_entity4,pos_chip_fallback,pos_fraud_ind,pos_security_cardholder2merchant,pos_3dsec_authen_method,card_device_type,auth_type,preauth_days,auth_expdate_utc,emv_atc,emv_cvmcode,emv_cvmresult,emv_txncode,poscap_partial_approval,poscap_purchase_amt_only_approval,poscap_card_input,poscap_Cardholder_authen,poscap_card_capture,poscap_attended,poscap_environment,poscap_card_output,poscap_terminal_output,poscap_pin_capture,poscap_terminal_type,emv_termtype,emv_termcap,Matching_Txn_ID,check_results_arrived,check_results_sent,check_results_sent_location,DCC_Indicator,multi_part_txn,multi_part_txn_final,multi_part_number,multi_part_count,currency_code_fee,currency_code_fee_settlement,interchange_amount_fee,interchange_amount_fee_settlement,Instant_Funding_Network,Instant_Funding_GPS,Acquirer_Forwarder_ID,SettlementIndicator,psd_sca_exempt)
VALUES 						      (800000010   ,null     ,null       ,null     ,null  ,null       ,null            ,null           ,null,          null      ,null    ,null,null,null,null    ,null  ,null,null                   ,null             ,null           ,null                          ,null                          ,null                         ,null                         ,null                         ,null                         ,null                         ,null                         ,null             ,null           ,null                             ,null                    ,null             ,null       ,null            ,null     ,null       ,null           ,null             ,null       ,null                     ,null                               ,null              ,null                    ,null                 ,null            ,null               ,null                ,null                    ,null                ,null                  ,null        ,null       ,null           ,null    ,null ,null          ,null            ,null               ,null                  ,null                 ,null               ,null             ,null                       ,null                   ,null                              ,null                       ,null                   ,null                ,null                 ,null );
