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;