UFN_REVENUE_GETGIFTFEEGLDISTRIBUTION

            CREATE function dbo.UFN_REVENUE_GETGIFTFEEGLDISTRIBUTION
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            return
            (
                select 
                    GIFTFEEGLDISTRIBUTION.ID, 
                    GIFTFEEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                    GIFTFEEGLDISTRIBUTION.TRANSACTIONTYPECODE, 
                    GIFTFEEGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT, 
                    GIFTFEEGLDISTRIBUTION.ACCOUNT, 
                    GIFTFEEGLDISTRIBUTION.AMOUNT, 
                    GIFTFEEGLDISTRIBUTION.REFERENCE,
                    GIFTFEEGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                    GIFTFEEGLDISTRIBUTION.BASECURRENCYID,
                    GIFTFEEGLDISTRIBUTION.TRANSACTIONAMOUNT,
                    GIFTFEEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                    GIFTFEEGLDISTRIBUTION.BASEEXCHANGERATEID,
                    GIFTFEEGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID
                from dbo.GIFTFEEGLDISTRIBUTION
                where 
                    GIFTFEEGLDISTRIBUTION.REVENUEID = @REVENUEID
                    and GIFTFEEGLDISTRIBUTION.OUTDATED = 0
            )