TYPE=VIEW
query=select `dep_return1`.`shcode` AS `shcode`,`dep_return1`.`sub_head` AS `sub_head`,sum(`dep_return1`.`Opening`) AS `Opening`,sum(`dep_return1`.`received`) AS `received`,sum(`dep_return1`.`refund`) AS `refund`,sum(`dep_return1`.`total_no_acc`) AS `total_no_acc` from `co-operativebank`.`dep_return1` where ((`dep_return1`.`Opening` > 0) or (`dep_return1`.`received` > 0) or (`dep_return1`.`refund` > 0) or (`dep_return1`.`total_no_acc` > 0)) group by `dep_return1`.`shcode`
md5=37c5ad5241008ab83c3d3541df7ccd27
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-12-04 07:25:47
create-version=1
source=SELECT `shcode`, `sub_head`, sum(`Opening`) as Opening, sum(`received`) as received, sum(`refund`) as refund, sum(`total_no_acc`) as total_no_acc FROM `dep_return1` where (Opening>0 or received >0 or refund >0 or total_no_acc>0) group by shcode
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `dep_return1`.`shcode` AS `shcode`,`dep_return1`.`sub_head` AS `sub_head`,sum(`dep_return1`.`Opening`) AS `Opening`,sum(`dep_return1`.`received`) AS `received`,sum(`dep_return1`.`refund`) AS `refund`,sum(`dep_return1`.`total_no_acc`) AS `total_no_acc` from `co-operativebank`.`dep_return1` where ((`dep_return1`.`Opening` > 0) or (`dep_return1`.`received` > 0) or (`dep_return1`.`refund` > 0) or (`dep_return1`.`total_no_acc` > 0)) group by `dep_return1`.`shcode`
