UFN_CONSTITUENT_ISPAYABLESVENDOR

Validates whether the constituent record is a payables vendor.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_CONSTITUENT_ISPAYABLESVENDOR
    (
        @CONSTITUENTID uniqueidentifier
    ) 
    returns bit
    with execute as caller
    as begin
        if exists(
            select
                ID
            from
                dbo.VENDOR AS V
            where
                V.ID = @CONSTITUENTID
        ) return 1;

        return 0;
    end