USP_SIMPLEDATALIST_PDACCOUNTCODEMAPFEE
Returns a list of fees and an all fees entry.
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEMAPFEE as
select
VALUE,
LABEL
from (
select
'99999999-9999-9999-9999-999999999999' as VALUE,
'All fees' as LABEL,
0 as SEQUENCE
union all
select
ID as VALUE,
NAME as LABEL,
1 as SEQUENCE
from
dbo.FEE
where
ISACTIVE = 1
) as FEES
order by
SEQUENCE, LABEL;