USP_DATALIST_REVENUEMERGEDATA_BASIC

CREATE procedure dbo.USP_DATALIST_REVENUEMERGEDATA_BASIC
(
      @REVENUEID uniqueidentifier
)
  as
      set nocount on;
select TOP 1
  TransactionDate=R.Date
  ,PaymentID = R.LOOKUPID 
    ,PaymentName = RPM.PAYMENTMETHOD 
    ,PaymentType = RPM.PAYMENTMETHOD 
    ,PaymentAmount = R.AMOUNT
    ,PaymentDate = R.DATE
  ,CreditCard = case when isnull(CPM.CREDITCARDPARTIALNUMBER,'')='' then '************' + CC.CREDITCARDPARTIALNUMBER else '************' + CPM.CREDITCARDPARTIALNUMBER END
    ,CreditCardType = case when CC.CREDITTYPECODEID is null then CTC.DESCRIPTION else dbo.UFN_CREDITTYPECODE_GETDESCRIPTION(CC.CREDITTYPECODEID) end
    ,CreditCardExpireson = case when isnull(CPM.EXPIRESON,'')='' then CC.EXPIRESON else CPM.EXPIRESON end

from REVENUE R
inner join dbo.REVENUEPAYMENTMETHOD RPM on RPM.REVENUEID =R.ID
left outer join dbo.REVENUESCHEDULE RS on RS.ID = R.ID
left outer join dbo.CREDITCARD CC on CC.ID = RS.CREDITCARDID
left outer join dbo.CREDITCARDPAYMENTMETHODDETAIL CPM on RPM.ID = CPM.ID
left outer join dbo.CREDITTYPECODE CTC ON CTC.ID = CPM.CREDITTYPECODEID 
where 
  R.ID = @REVENUEID