USP_SIMPLEDATALIST_LEDGERACCOUNT

List of ledger accounts.

Definition

Copy


CREATE procedure dbo.USP_SIMPLEDATALIST_LEDGERACCOUNT as
  select 
    ID as VALUE
    ACCOUNTSTRING + ' - ' + ACCOUNTDESCRIPTION as LABEL
  from dbo.GLACCOUNT
  order by LABEL