UFN_ACCOUNTSTRUCTURE_GETMETADATA

CREATE function dbo.UFN_ACCOUNTSTRUCTURE_GETMETADATA(@SEGMENTSONLY bit = 0,@ACCOUNTSYSTEMID uniqueidentifier = null)
returns @STRUCTURE table
  (ID uniqueidentifier,
  DESCRIPTION nvarchar(100),
  LENGTH integer,
  SEQUENCE tinyint,
  SEGMENTSEQUENCE tinyint,
  SEGMENTCOLUMN tinyint, 
  ELEMENTTYPECODE tinyint,
  ELEMENTDEFINITIONCODE tinyint,
  CLOSINGELEMENT bit,
  SEPARATORCODE tinyint,
  SEPARATOR nvarchar(15))
with execute as caller
as begin
  insert into @STRUCTURE  
    (ID, 
      DESCRIPTION,
      LENGTH, 
      SEQUENCE,
    SEGMENTSEQUENCE,
    SEGMENTCOLUMN,
      ELEMENTTYPECODE,
      ELEMENTDEFINITIONCODE,
    CLOSINGELEMENT,
    SEPARATORCODE,
    SEPARATOR)
  select
    ID, 
      DESCRIPTION,
      case LENGTH when 0 then 100 else LENGTH end LENGTH, 
      SEQUENCE,
    SEGMENTSEQUENCE,
    SEGMENTCOLUMN,
      ELEMENTTYPECODE,
      ELEMENTDEFINITIONCODE,
    CLOSINGELEMENT,
    SEPARATORCODE,
    SEPARATOR
  from dbo.PDACCOUNTSTRUCTURE
  where
    (@SEGMENTSONLY = 0 or ELEMENTTYPECODE = 1) and
    (PDACCOUNTSYSTEMID = isnull(@ACCOUNTSYSTEMID, '4B121C2C-CCE6-440D-894C-EA0DEF80D50B') 
   -- and ISBASICGL = 0

   )
  return;
end