UPDATE tm_testing_session SET fee_first_system=(SELECT CAST(pr.preference_value AS numeric) FROM cmn_application_preference pr where pr.preference_name='fee_first_system');
DELETE FROM cmn_application_preference pr where pr.preference_name='fee_first_system';
UPDATE tm_testing_session SET fee_additional_system=(SELECT CAST(pr.preference_value AS numeric) FROM cmn_application_preference pr where pr.preference_name='fee_additional_system');
DELETE FROM cmn_application_preference pr where pr.preference_name='fee_additional_system';
UPDATE tm_testing_session SET domain_fee=(SELECT CAST(pr.preference_value AS numeric) FROM cmn_application_preference pr where pr.preference_name='domain_fee');
DELETE FROM cmn_application_preference pr where pr.preference_name='domain_fee';
UPDATE tm_testing_session SET currency_id=(SELECT pr.preference_value FROM cmn_application_preference pr where pr.preference_name='currency');
DELETE FROM cmn_application_preference pr where pr.preference_name='currency';
UPDATE tm_testing_session SET vat_percent=(SELECT CAST(pr.preference_value AS numeric) FROM cmn_application_preference pr where pr.preference_name='vat_percent');
DELETE FROM cmn_application_preference pr where pr.preference_name='vat_percent';
