UFN_REVENUE_GETSPLITS_2

            CREATE function dbo.UFN_REVENUE_GETSPLITS_2
            (
                @REVENUEID uniqueidentifier
            )
            returns table            
            AS            
            return 
                (
                    select 
                        FINANCIALTRANSACTIONLINEITEM.ID,
                        REVENUESPLIT_EXT.APPLICATIONCODE,
                        REVENUESPLIT_EXT.TYPECODE,
                        FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT as AMOUNT,
                        REVENUESPLIT_EXT.DESIGNATIONID,
                        REVENUECATEGORY.GLREVENUECATEGORYMAPPINGID CATEGORYCODEID,
                        coalesce(REVENUESPLITGIFTAID.DECLINESGIFTAID, cast(0 as bit)) as DECLINESGIFTAID,
                        coalesce(REVENUESPLITGIFTAID.ISSPONSORSHIP, cast(0 as bit)) as ISGIFTAIDSPONSORSHIP,
                        isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, CURRENCYSET.BASECURRENCYID) as BASECURRENCYID,
                        FINANCIALTRANSACTIONLINEITEM.ORGAMOUNT as ORGANIZATIONAMOUNT,
                        FINANCIALTRANSACTION.ORGEXCHANGERATEID as ORGANIZATIONEXCHANGERATEID,
                        FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT,
                        FINANCIALTRANSACTION.TRANSACTIONCURRENCYID,
                        FINANCIALTRANSACTION.BASEEXCHANGERATEID
                    from 
                        dbo.FINANCIALTRANSACTIONLINEITEM 
                    inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                    inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                    inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                    inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
                    inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
                    left outer join dbo.REVENUECATEGORY 
                        on REVENUECATEGORY.ID = FINANCIALTRANSACTIONLINEITEM.ID
                    left outer join dbo.REVENUESPLITGIFTAID
                        on REVENUESPLITGIFTAID.ID = FINANCIALTRANSACTIONLINEITEM.ID
                    where 
                        FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @REVENUEID
                        and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
            and FINANCIALTRANSACTION.TYPECODE in (0,1,2,3,4,5,6,7,8,9,15) 
            and FINANCIALTRANSACTIONLINEITEM.TYPECODE != 1
                );