CORE-POS/IS4C

use is4c_log;

DROP VIEW IF EXISTS `memchargebalance`;
CREATE VIEW `memchargebalance` AS 

select 
`dtransactions`.`card_no` AS `card_no`,
sum(`dtransactions`.`total`) AS `chargeTotal` 

from `dtransactions` 
where ((`dtransactions`.`trans_subtype` ='MI') 
and 
((to_days(`dtransactions`.`datetime`) - to_days(now())) = 0)) 

group by `dtransactions`.`card_no`