UFN_REVENUETRANSACTION_GETRECEIPTSTATUS

            CREATE function dbo.UFN_REVENUETRANSACTION_GETRECEIPTSTATUS
            (
                @TRANSACTIONID uniqueidentifier
            )
            returns nvarchar(50)
            with execute as caller
            as
            begin
                declare @STATUS nvarchar(50);
                declare @DONOTRECEIPT bit;

                if (select max(cast (DONOTRECEIPT as int)) from dbo.REVENUE where ID = @TRANSACTIONID ) = 1
                    return 'Do not receipt';

                declare @RECEIPTID uniqueidentifier;
                declare @RECEIPTDATE datetime;

                select top 1 @RECEIPTID = RR.ID, @RECEIPTDATE = RECEIPTDATE from dbo.REVENUERECEIPT RR where RR.REVENUEID in 
                    (
                        select ID from dbo.REVENUE R where R.ID = @TRANSACTIONID
                    ) 
                    order by RR.RECEIPTPROCESSDATE desc;

                if @RECEIPTID is null
                    set @STATUS = 'Not receipted';
                else if @RECEIPTDATE is null
                    set @STATUS = 'Pending';
                else
                    set @STATUS = 'Receipted';

                return @STATUS;
            end