UFN_PDACCOUNTSTRUCTURE_ACCOUNTEXISTS

Returns 1 if any accounts and BasicGL have been defined, 0 otherwise

Return

Return Type
bit

Definition

Copy


CREATE function dbo.UFN_PDACCOUNTSTRUCTURE_ACCOUNTEXISTS()
returns bit
            with execute as caller
            as begin

            declare @EXISTS bit;

            if exists(
                select *
                from
                    dbo.GLACCOUNT where PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'
            )
                set @EXISTS = 1
            else
                set @EXISTS = 0

            return @EXISTS;
        end