USP_SIMPLEDATALIST_ACCOUNTSTRUCTURE

CREATE procedure dbo.USP_SIMPLEDATALIST_ACCOUNTSTRUCTURE (@TYPE tinyint = null) as
begin
  declare @PDACCOUNTSYSTEMID uniqueidentifier
  set @PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'

    select 
        ID as VALUE, 
        DESCRIPTION as LABEL
    from dbo.PDACCOUNTSTRUCTURE
  where (ELEMENTDEFINITIONCODE = @TYPE or @TYPE is null)
  and ISBASICGL = 0
  and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
    order by DESCRIPTION
  end