UFN_BATCHREVENUECONSTITUENTRELATION_ISVALIDBUSINESS

Checks that the relationid points to an organization batch constituent record.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@RELATIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BATCHREVENUECONSTITUENTRELATION_ISVALIDBUSINESS(@RELATIONID uniqueidentifier) returns bit
            as
            begin
                declare @result bit;
                set @result = 0
                select @result=1 from dbo.BATCHREVENUECONSTITUENT where ID = @RELATIONID and ISORGANIZATION = 1;
                return @result;
            end;