TYPE=VIEW
query=(select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `co-operativebank-224`.`synop_details` where ((`synop_details`.`sl_no` = 1) or (`synop_details`.`sl_no` = 2) or (`synop_details`.`sl_no` = 3)) group by `synop_details`.`sub_head` order by `synop_details`.`sl_no`,`synop_details`.`sub_head`)
md5=41b8c901b579c12e4dc91162216ad619
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-09-02 14:42:46
create-version=1
source=(select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,tolmem from `synop_details` where ((`synop_details`.`sl_no` = 1) or (`synop_details`.`sl_no` = 2) or (`synop_details`.`sl_no` = 3)) group by `synop_details`.`sub_head` order by `synop_details`.`sl_no`,`synop_details`.`sub_head`)
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=(select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `co-operativebank-224`.`synop_details` where ((`synop_details`.`sl_no` = 1) or (`synop_details`.`sl_no` = 2) or (`synop_details`.`sl_no` = 3)) group by `synop_details`.`sub_head` order by `synop_details`.`sl_no`,`synop_details`.`sub_head`)
