UFN_REVENUE_GETPREVIOUSRECEIPTRECORD

Returns the previous receipt record for the given revenue transaction record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUE_GETPREVIOUSRECEIPTRECORD
            (
                @REVENUEID uniqueidentifier
            )            
            returns table
            as
            return
            (
                select top 1
                    ID,
                    RECEIPTNUMBER,
                    UNIQUERECEIPTNUMBER,
                    RECEIPTSTACKSHORTNAME,
                    RECEIPTSTACKINFOID
                from dbo.REVENUERECEIPT
                where 
                    REVENUEID = @REVENUEID
                order by 
                    RECEIPTPROCESSDATE desc
            )