CORE-POS/IS4C

use is4c_op;
DROP VIEW IF EXISTS `memchargebalance`;

CREATE view memchargebalance as
SELECT 
c.cardNo,
(case when m.card_no is null then c.memDiscountLimit - c.balance else
c.memDiscountLimit -(c.balance-m.chargeTotal)end) 
as availBal,
(case when m.card_no is null then c.balance else c.balance-m.chargeTotal end) as balance
FROM custdata c left outer join is4c_log.memchargetotals m on
c.CardNo = m.card_no