UFN_SALESDEPOSITPROCESS_GETNUMBEROFRECONCILED

        create function dbo.UFN_SALESDEPOSITPROCESS_GETNUMBEROFRECONCILED()
            returns integer
            with execute as caller
            as begin

                declare @NUMBEROFPROCESSES integer = 0

                select @NUMBEROFPROCESSES = count(*)
                from dbo.[SALESDEPOSITPROCESS]
                where [ISRECONCILEDPROCESS] = 1

                return @NUMBEROFPROCESSES;
            end