Inicio Explorar Axuda
Iniciar sesión
paul
/
gps.docker
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: 171bbf76d0
Ramas Etiquetas
gps.docker
/
daldb
/
SeedData
/
AlexisPTSTest
/
TransactionAddDetails.sql

TransactionAddDetails.sql 34 KB
Histórico Raw

1234567891011121314151617181920212223242526272829303132333435363738 
  1. DELETE FROM [TransactionAddDetails] where TransactionID between 1000000001 and 1000000029
    2. 

  2. DELETE FROM [TransactionAddDetails] where TransactionID in (800000001,800000002,800000003,800000004,800000005,800000006,800000007,800000008,800000009,800000010, 900000029,
    3. 

  3. 900000030,900000031,900000032,900000001,900000002,900000003,900000004,900000005,900000006,900000007,
    4. 

  4. 900000009,900000010,900000011,900000012,900000013,900000014,900000015,900000016,900000017,900000018,
    5. 

  5. 900000019,900000020,900000021,900000022,900000023,900000024,900000025,900000026,900000027,900000028,
    6. 

  6. 900000029,900000030,900000031,300000001,300000002,900000008);
    7. 

  7. DELETE FROM [TransactionAddDetails] where TransactionID in (8000000001,8000000002,8000000003,8000000004,8000000005,8000000006,8000000007,8000000008,8000000009,8000000010, 9000000029,
    8. 

  8. 9000000030,9000000031,9000000032,9000000001,9000000002,9000000003,9000000004,9000000005,9000000006,9000000007,
    9. 

  9. 9000000009,9000000010,9000000011,9000000012,9000000013,9000000014,9000000015,9000000016,9000000017,9000000018,
    10. 

  10. 9000000019,9000000020,9000000021,9000000022,9000000023,9000000024,9000000025,9000000026,9000000027,9000000028,
    11. 

  11. 9000000029,9000000030,9000000031,300000001,300000002,9000000008);
    12. 

  12. 

  13. 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)
    14. 

  14. 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');
    15. 

  15. 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)
    16. 

  16. 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 );
    17. 

  17. 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)
    18. 

  18. 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');
    19. 

  19. 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)
    20. 

  20. 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');
    21. 

  21. 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)
    22. 

  22. 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');
    23. 

  23. 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)
    24. 

  24. 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');
    25. 

  25. 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)
    26. 

  26. 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');
    27. 

  27. 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)
    28. 

  28. 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');
    29. 

  29. 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)
    30. 

  30. 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');
    31. 

  31. 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)
    32. 

  32. 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');
    33. 

  33. 

  34. 

  35. 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)
    36. 

  36. 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');
    37. 

  37. 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)
    38. 

  38. 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 );
    39.