USP_DATALIST_DISBURSEMENTFORMAT

CREATE procedure dbo.USP_DATALIST_DISBURSEMENTFORMAT
as
    set nocount on;

    select D.ID,
    D.NAME,
    D.DESCRIPTION,
        D.PAYMENTMETHOD,
        C.NAME as REPORTCATALOGNAME,
    D.TYPE,
    D.PRENUMBERED
    from dbo.DISBURSEMENTFORMAT D
  inner join dbo.REPORTCATALOG C on C.ID = D.REPORTCATALOGID