TYPE=VIEW
query=select `v`.`vch_no` AS `vch_no`,`v`.`date` AS `date`,`v`.`vch_type` AS `vch_type`,`v`.`deposit_type` AS `deposit_type`,`v`.`dr` AS `dr`,`v`.`cr` AS `cr`,`v`.`Acc_no` AS `ledger`,`l`.`name` AS `name`,`l1`.`sub_head` AS `sub_head` from ((`co-operativebank-durgapur`.`voucher` `v` join `co-operativebank-durgapur`.`ledger` `l`) join `co-operativebank-durgapur`.`ledger` `l1`) where ((`v`.`cash_acc` = `l`.`acc_no`) and (`v`.`status` = \'1\') and (`v`.`Acc_no` = `l1`.`acc_no`))
md5=f355f14478e5cd0c78925f52d3b5516b
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-04-04 10:26:47
create-version=1
source=select  `v`.`vch_no`  AS  `vch_no` ,\n `v`.`date`  AS  `date` ,\n `v`.`vch_type`  AS  `vch_type` ,\n `v`.`deposit_type`  AS  `deposit_type` ,\n `v`.`dr`  AS  `dr` ,\n `v`.`cr`  AS  `cr` ,\n `v`.`Acc_no`  AS  `ledger` ,\n `l`.`name`  AS  `name` ,\n `l1`.`sub_head`  AS  `sub_head`  from ( (  `co-operativebank-durgapur`.`voucher`  `v`  join  `co-operativebank-durgapur`.`ledger`  `l`  ) join  `co-operativebank-durgapur`.`ledger`  `l1`  ) where ( (  `v`.`cash_acc`  =  `l`.`acc_no`  ) and (  `v`.`status`  =  \'1\' ) and (  `v`.`Acc_no`  =  `l1`.`acc_no`  ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`vch_no` AS `vch_no`,`v`.`date` AS `date`,`v`.`vch_type` AS `vch_type`,`v`.`deposit_type` AS `deposit_type`,`v`.`dr` AS `dr`,`v`.`cr` AS `cr`,`v`.`Acc_no` AS `ledger`,`l`.`name` AS `name`,`l1`.`sub_head` AS `sub_head` from ((`co-operativebank-durgapur`.`voucher` `v` join `co-operativebank-durgapur`.`ledger` `l`) join `co-operativebank-durgapur`.`ledger` `l1`) where ((`v`.`cash_acc` = `l`.`acc_no`) and (`v`.`status` = \'1\') and (`v`.`Acc_no` = `l1`.`acc_no`))
