UFN_REVENUE_ISPENDING

Indicates if a revenue record is pending in a batch.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUE_ISPENDING
            (
                @REVENUEID uniqueidentifier
            )
            returns bit
            as
            begin
                declare @ISPENDING bit;

                select @ISPENDING = ISPENDING 
                from dbo.REVENUESCHEDULE
                where ID = @REVENUEID;

                return coalesce(@ISPENDING, 0);
            end