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