UFN_SALESDEPOSITTEMPLATE_HASPAYMENTMETHOD

This function returns whether or not the sales deposit template contains the payment method.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@PAYMENTMETHODCODE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_SALESDEPOSITTEMPLATE_HASPAYMENTMETHOD
            (
                @ID uniqueidentifier,
                @PAYMENTMETHODCODE tinyint
            )
            returns bit
            with execute as caller
            as begin
                declare @HASPAYMENTMETHOD bit = 0
                if exists(
                    select [ID]  
                    from dbo.[SALESDEPOSITTEMPLATEPAYMENTMETHOD] 
                    where 
                        [PAYMENTMETHODCODE] = @PAYMENTMETHODCODE and
                        [SALESDEPOSITTEMPLATEID] = @ID
                ) 
                or exists(select 1 from dbo.SALESDEPOSITTEMPLATE where ID = @ID and PAYMENTMETHODOPTIONCODE = 0)
                    set @HASPAYMENTMETHOD = 1

                return @HASPAYMENTMETHOD
            end