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