USP_SIMPLEDATALIST_ACCOUNTSTRUCTURENOACCOUNTCODE

List of all accounting elements minus account code

Definition

Copy


        CREATE procedure dbo.USP_SIMPLEDATALIST_ACCOUNTSTRUCTURENOACCOUNTCODE as
            select 
                ID as VALUE
                DESCRIPTION as LABEL
            from dbo.PDACCOUNTSTRUCTURE
          where ID <> '90C72BDA-7994-401B-8A9F-7B36FA65D9FC'
            order by DESCRIPTION