CREATE VIEW al_paydetsums
    (
      cost_id,
      total_pddueamt,
      total_pdpayamt,
      total_due_pay_balance
    )
    AS
      SELECT  cost_id,
      sum(COALESCE(pddueamt,0)),
      sum(COALESCE(pdpayamt,0)),
      sum(COALESCE(pddueamt,0))-sum(COALESCE(pdpayamt,0))
      FROM al_paydet
      GROUP BY cost_id
GO