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