USP_SIMPLEDATALIST_ACCOUNTELEMENTDESCRIPTION

List of all account segment elements

Parameters

Parameter Parameter Type Mode Description
@PDACCOUNTSYSTEMID uniqueidentifier IN

Definition

Copy


        CREATE procedure dbo.USP_SIMPLEDATALIST_ACCOUNTELEMENTDESCRIPTION(@PDACCOUNTSYSTEMID uniqueidentifier = null)  as
          select 
              ID as VALUE
              DESCRIPTION + ' description' as LABEL
          from dbo.PDACCOUNTSTRUCTURE
        where ELEMENTTYPECODE = 1 and PDACCOUNTSYSTEMID = isnull(@PDACCOUNTSYSTEMID,'4B121C2C-CCE6-440D-894C-EA0DEF80D50B') and ISBASICGL = 0
          order by SEGMENTSEQUENCE