TYPE=VIEW
query=select `co-operativebank-dekhaliannapurna`.`voucher`.`Acc_no` AS `acc_no`,`l`.`name` AS `name`,`co-operativebank-dekhaliannapurna`.`voucher`.`vch_no` AS `vch_no`,`co-operativebank-dekhaliannapurna`.`voucher`.`vch_type` AS `vch_type`,`co-operativebank-dekhaliannapurna`.`voucher`.`dr` AS `dr`,`co-operativebank-dekhaliannapurna`.`voucher`.`cr` AS `cr`,`co-operativebank-dekhaliannapurna`.`voucher`.`date` AS `date`,`l`.`acc_type` AS `acc_type`,`l`.`sub_head` AS `sub_head`,`co-operativebank-dekhaliannapurna`.`voucher`.`deposit_type` AS `deposit_type` from (`co-operativebank-dekhaliannapurna`.`voucher` join `co-operativebank-dekhaliannapurna`.`ledgers` `l`) where ((`l`.`acc_no` = `co-operativebank-dekhaliannapurna`.`voucher`.`Acc_no`) and (`co-operativebank-dekhaliannapurna`.`voucher`.`status` = \'1\'))
md5=25bdbad1d31ca88cc823df55878be28f
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-05-24 07:43:28
create-version=1
source=select  `co-operativebank-dekhaliannapurna`.`voucher`.`Acc_no`  AS  `acc_no` ,\n `l`.`name`  AS  `name` ,\n `co-operativebank-dekhaliannapurna`.`voucher`.`vch_no`  AS  `vch_no` ,\n `co-operativebank-dekhaliannapurna`.`voucher`.`vch_type`  AS  `vch_type` ,\n `co-operativebank-dekhaliannapurna`.`voucher`.`dr`  AS  `dr` ,\n `co-operativebank-dekhaliannapurna`.`voucher`.`cr`  AS  `cr` ,\n `co-operativebank-dekhaliannapurna`.`voucher`.`date`  AS  `date` ,\n `l`.`acc_type`  AS  `acc_type` ,\n `l`.`sub_head`  AS  `sub_head` ,\n `co-operativebank-dekhaliannapurna`.`voucher`.`deposit_type`  AS  `deposit_type`  from (  `co-operativebank-dekhaliannapurna`.`voucher`  join  `co-operativebank-dekhaliannapurna`.`ledgers`  `l`  ) where ( (  `l`.`acc_no`  =  `co-operativebank-dekhaliannapurna`.`voucher`.`Acc_no`  ) and (  `co-operativebank-dekhaliannapurna`.`voucher`.`status`  =  \'1\' ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-dekhaliannapurna`.`voucher`.`Acc_no` AS `acc_no`,`l`.`name` AS `name`,`co-operativebank-dekhaliannapurna`.`voucher`.`vch_no` AS `vch_no`,`co-operativebank-dekhaliannapurna`.`voucher`.`vch_type` AS `vch_type`,`co-operativebank-dekhaliannapurna`.`voucher`.`dr` AS `dr`,`co-operativebank-dekhaliannapurna`.`voucher`.`cr` AS `cr`,`co-operativebank-dekhaliannapurna`.`voucher`.`date` AS `date`,`l`.`acc_type` AS `acc_type`,`l`.`sub_head` AS `sub_head`,`co-operativebank-dekhaliannapurna`.`voucher`.`deposit_type` AS `deposit_type` from (`co-operativebank-dekhaliannapurna`.`voucher` join `co-operativebank-dekhaliannapurna`.`ledgers` `l`) where ((`l`.`acc_no` = `co-operativebank-dekhaliannapurna`.`voucher`.`Acc_no`) and (`co-operativebank-dekhaliannapurna`.`voucher`.`status` = \'1\'))
