CORE-POS/IS4C

use translog;
DROP VIEW IF EXISTS `rp_list`;

CREATE view rp_list as

select
min(datetime) as time, 
register_no,
emp_no,
trans_no,
sum(CASE WHEN trans_type = 'T'  THEN -1 * total ELSE total END) as total
from localtranstoday
group by register_no, emp_no, trans_no