CREATE OR REPLACE DEFINER=`vn`@`localhost` SQL SECURITY DEFINER VIEW `vn`.`exchangeInsuranceInPrevious` AS SELECT `ei`.`dueDated` AS `dated`, `ei`.`amount` AS `amount`, `ei`.`rate` AS `rate` FROM `vn`.`exchangeInsurance` `ei` WHERE `ei`.`amount` <> 0 AND `ei`.`financialProductTypefk` = 'SC'