V_QUERY_REVENUE_INSTALLMENTPLANBALANCE

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:34:00 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REVENUE_INSTALLMENTPLANBALANCE AS



                select
                    FINANCIALTRANSACTION.ID,
                    cast(
                        FINANCIALTRANSACTION.TRANSACTIONAMOUNT -   
                            (coalesce((    
                                select sum(INSTALLMENTSPLITPAYMENT.AMOUNT)   
                                from dbo.INSTALLMENTSPLITPAYMENT   
                                where INSTALLMENTSPLITPAYMENT.PLEDGEID = FINANCIALTRANSACTION.ID)
                            , 0) + 
                            coalesce((
                                select sum(INSTALLMENTSPLITWRITEOFF.TRANSACTIONAMOUNT)   
                                from dbo.INSTALLMENTSPLITWRITEOFF   
                                    inner join dbo.INSTALLMENTSPLIT on INSTALLMENTSPLITWRITEOFF.INSTALLMENTSPLITID = INSTALLMENTSPLIT.ID   
                                where INSTALLMENTSPLIT.PLEDGEID = FINANCIALTRANSACTION.ID)
                            , 0)
                        ) as money
                    ) BALANCE  
                from dbo.FINANCIALTRANSACTION