USP_SIMPLEDATALIST_DISBURSEMENTPROCESSTEMPLATEFORMATCHECK
Lists all disbursement formats with a payment method of check
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_DISBURSEMENTPROCESSTEMPLATEFORMATCHECK as
select
ID as VALUE,
NAME as LABEL
from dbo.DISBURSEMENTFORMAT
where PAYMENTMETHODCODE = 0 --Check
order by NAME