UFN_QUERY_REVENUE_GETGLDISTRIBUTION

            CREATE function dbo.UFN_QUERY_REVENUE_GETGLDISTRIBUTION(
                @REVENUEID uniqueidentifier
            )
            returns @REVENUEGLDISTRIBUTION table
            (
                ID uniqueidentifier null,
                REVENUEID uniqueidentifier not null,
                TRANSACTIONTYPE nvarchar(20) not null,
                ACCOUNT nvarchar(100) not null,
                PROJECT nvarchar(100) null,
                AMOUNT money not null
            )

            as 
            begin    
                if @REVENUEID is null return;

                insert into @REVENUEGLDISTRIBUTION (
                    ID, 
                    REVENUEID, 
                    TRANSACTIONTYPE,
                    ACCOUNT, 
                    PROJECT, 
                    AMOUNT
                )
                select 
                    ID, 
                    REVENUEID, 
                    TRANSACTIONTYPE, 
                    ACCOUNT, 
                    PROJECT, 
                    AMOUNT
                from dbo.REVENUEGLDISTRIBUTION 
                where REVENUEID = @REVENUEID
                    and OUTDATED = 0

                union all

                --Auction purchase GL distributions

                select 
                    ID, 
                    REVENUEPURCHASEID, 
                    TRANSACTIONTYPE, 
                    ACCOUNT, 
                    PROJECT, 
                    AMOUNT
                from dbo.AUCTIONPURCHASEGLDISTRIBUTION
                where REVENUEPURCHASEID = @REVENUEID
                    and OUTDATED = 0;


                return;
            end