USP_SIMPLEDATALIST_HEADERDOCUMENT

CREATE procedure dbo.USP_SIMPLEDATALIST_HEADERDOCUMENT
as
    set nocount on;

    select 
        ID as VALUE, 
        NAME as LABEL
    from
        dbo.DOCUMENT
    where
        TYPECODE in (3,4)  -- Mailing Header, Will Call Header

        and ISACTIVE = 1
    order by
        NAME;

    return 0;