USP_SIMPLEDATALIST_DEPOSITABLE_OTHERPAYMENTMETOHD
Miscellaneous Payment Simple Data List for Other Payment Methods.
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_DEPOSITABLE_OTHERPAYMENTMETOHD as
select
OTHERPAYMENTMETHODCODE.ID as VALUE,
DESCRIPTION as LABEL
from dbo.OTHERPAYMENTMETHODCODE
left join dbo.NONDEPOSITABLEPAYMENTMETHOD on NONDEPOSITABLEPAYMENTMETHOD.ID = OTHERPAYMENTMETHODCODE.ID
where ACTIVE = 1 and NONDEPOSITABLEPAYMENTMETHOD.ID is null
order by DESCRIPTION