UFN_REVENUE_GETDETAILS

            create function dbo.UFN_REVENUE_GETDETAILS
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            as
            return
                (
                    select 
                        REVENUE.ID,
                        REVENUE.AMOUNT as [APPLIED],
                        REVENUE.TYPECODE, 
                        cast('DESCRIPTION' as nvarchar(max)) as [DESCRIPTION],
                        cast('0.00' as money) as [BALANCE],
                        cast('0.00' as money) as [AMOUNTDUE],
                        getdate() as [DATEDUE],
                        REVENUE.RECEIPTAMOUNT,
                        REVENUE.DONOTRECEIPT
                    from dbo.REVENUE                    
                    where REVENUE.ID = @REVENUEID
                );