UFN_ACCOUNTSTRUCTURE_TOTALSEGMENTS

Returns the total number of accounting elements that have been defined.

Return

Return Type
tinyint

Definition

Copy



CREATE function dbo.UFN_ACCOUNTSTRUCTURE_TOTALSEGMENTS()
returns tinyint
with execute as caller
as begin
    declare @TOTAL tinyint
  select @TOTAL = coalesce(count(*),0) from dbo.PDACCOUNTSTRUCTURE
    return @TOTAL
end