UFN_SALESDEPOSITTEMPLATE_CALCULATEDEFAULTALLOWEDPAYMENTMETHODS

This function returns the tinyint that represents the allowed payment methods in a bank account deposit for a sales deposit template.

Return

Return Type
tinyint

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_SALESDEPOSITTEMPLATE_CALCULATEDEFAULTALLOWEDPAYMENTMETHODS
            (
                @ID uniqueidentifier
            )
            returns tinyint
            with execute as caller
            as begin
                declare @DEFAULTALLOWEDPAYMENTMETHODS tinyint = 0

                --Check : 1 for bank account deposits, 1 for payment method code

                if dbo.UFN_SALESDEPOSITTEMPLATE_HASPAYMENTMETHOD(@ID, 1) = 1
                    set @DEFAULTALLOWEDPAYMENTMETHODS += 1

                --Cash : 2 for bank account deposits, 0 for payment method code

                if dbo.UFN_SALESDEPOSITTEMPLATE_HASPAYMENTMETHOD(@ID, 0) = 1
                    set @DEFAULTALLOWEDPAYMENTMETHODS += 2

                --Credit card: 8 for bank account deposits, 2 for payment method code

                if dbo.UFN_SALESDEPOSITTEMPLATE_HASPAYMENTMETHOD(@ID, 2) = 1
                    set @DEFAULTALLOWEDPAYMENTMETHODS += 8

                --Other payment methods: 32 for bank account deposits, 10 for payment method code

                if dbo.UFN_SALESDEPOSITTEMPLATE_HASPAYMENTMETHOD(@ID, 10) = 1
                    set @DEFAULTALLOWEDPAYMENTMETHODS += 32

                return @DEFAULTALLOWEDPAYMENTMETHODS;    
            end