USP_DATALIST_GLACCOUNTSTRUCTURE

CREATE procedure dbo.USP_DATALIST_GLACCOUNTSTRUCTURE
as
    set nocount on;

  declare @PDACCOUNTSYSTEMID uniqueidentifier = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B';

    select ID,
  DESCRIPTION,
    ELEMENTTYPE,
    ELEMENTDEFINITION,
  nullif(LENGTH, 0) LENGTH
    from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ISBASICGL = 0
  order by SEQUENCE