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;