UFN_REVENUE_GETPREVIOUSTRANSACTIONDATEBYID

Returns the previous transaction date for a revenue ID.

Return

Return Type
datetime

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUE_GETPREVIOUSTRANSACTIONDATEBYID
            (
                @REVENUEID uniqueidentifier
            )
            returns datetime
            as
            begin
                declare @RETVAL datetime;

                select top 1 
                    @RETVAL = dbo.UFN_REVENUE_GETPREVIOUSTRANSACTIONDATE_BYID_1_1(@REVENUEID, NEXTTRANSACTIONDATE)
                from dbo.REVENUESCHEDULE
                where ID = @REVENUEID;

                return @RETVAL;
            end