USP_DATALIST_BANKACCOUNTDISBURSEMENTTRANSACTION

            CREATE procedure dbo.USP_DATALIST_BANKACCOUNTDISBURSEMENTTRANSACTION
            (
                @ID uniqueidentifier
            )
            as
                set nocount on;

                select
                    VD.DISBURSEMENTID
                    ,VD.TRANSACTIONDATE
                    ,case 
                        when (VD.TRANSACTIONNETAMOUNT < 0) and (FT.DELETEDON IS NULL) then 'Credit Memo' 
                        when (VD.TRANSACTIONNETAMOUNT < 0) and (NOT FT.DELETEDON IS NULL) then 'Credit Memo (deleted)' 
                        when (VD.TRANSACTIONNETAMOUNT >=0) and (FT.DELETEDON IS NULL) then 'Invoice'
                        else 'Invoice (deleted)' 
                     end as [TYPE]
                    ,VD.TRANSACTIONNUMBER
                    ,VD.TRANSACTIONDESCRIPTION
                    ,VD.TRANSACTIONDISCOUNTAMOUNT
                    ,VD.TRANSACTIONNETAMOUNT
                    ,VD.TRANSACTIONID
                    ,VD.TRANSACTIONTYPECODE
                    ,case when FT.DELETEDON is null then 0 else 1 end as [DELETED]
                from dbo.V_DISBURSEMENT_SHOWTRANSACTIONS as VD
                    inner join dbo.FINANCIALTRANSACTION FT on FT.ID = VD.TRANSACTIONID
                where VD.DISBURSEMENTID = @ID
                order by VD.TRANSACTIONDATE