USP_DATALIST_PAYMENT_TERM

CREATE procedure dbo.USP_DATALIST_PAYMENT_TERM
as
    set nocount on;
  select 
  P.ID
    ,P.NAME
    ,P.[DESCRIPTION]
    ,dbo.UFN_PAYMENTTERM_DUEDAYS_DESCRIPTION(PAYMENTDUECODE,DAYSDUE,P.DAYOFMONTHDUE,P.MONTHDUECODE) as DUEDAYSDESCRIPTION
    ,case when P.INCLUDEDISCOUNT=1 then P.DISCOUNTPERCENT else NULL end as DISCOUNTPERCENT
    ,case when P.INCLUDEDISCOUNT=1 then P.DISCOUNTDAYS else NULL end as DISCOUNTDAYS
from dbo.PAYMENTTERM as P