UFN_REVENUERECEIPT_SAMEORNEWRERECEIPTNUMBER

Returns if a revenue transaction is rereceipted using new or same receipt number

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@SAMEMESSAGE	nvarchar(100)	IN
@NEWMESSAGE	nvarchar(100)	IN

Definition

Copy



create function dbo.UFN_REVENUERECEIPT_SAMEORNEWRERECEIPTNUMBER
            (
                @REVENUEID uniqueidentifier,
                @SAMEMESSAGE nvarchar(100),
                @NEWMESSAGE nvarchar(100)
            )
            returns nvarchar(100)
            with execute as caller
            as
            begin
                declare @RETVAL nvarchar(100);

                select top 1 
                    @RETVAL = CASE RD.NEWNUMBERONRERECEIPT WHEN  1 THEN coalesce(@NEWMESSAGE,'New receipt number') ELSE coalesce(@SAMEMESSAGE, 'Same receipt number') END

                from 
                    dbo.REVENUERECEIPT RR 
                inner join dbo.REVENUERECEIPTRERECEIPTDETAIL RD on RD.REVENUERECEIPTID = RR.ID
                where 
                    RR.REVENUEID = @REVENUEID
                order by 
                    RR.RECEIPTPROCESSDATE desc;

                return @RETVAL; 
end