UFN_DOCUMENT_GETPRINTINGHISTORYCREDIT

CREATE function dbo.UFN_DOCUMENT_GETPRINTINGHISTORYCREDIT(@CREDITID uniqueidentifier)
returns table            
as return
    select
        DOCUMENTPRINTINGHISTORY.ID,
        DOCUMENTPRINTINGHISTORY.TYPECODE,
        DOCUMENTPRINTINGHISTORY.CREDITCARDPAYMENTMETHODDETAILID,
        DOCUMENTPRINTINGHISTORY.CREDITID,
        DOCUMENTPRINTINGHISTORY.CREDITPAYMENTID,
        case DOCUMENTPRINTINGHISTORY.TYPECODE
            when 2 then  -- Credit Card Receipt

                DOCUMENTPRINTINGHISTORY.TYPE + ':  ' + CURRENCY.CURRENCYSYMBOL +
                cast(SALESORDERPAYMENT.AMOUNT as nvarchar) + ' *' +  
                CREDITCARDPAYMENTMETHODDETAIL.CREDITCARDPARTIALNUMBER + ' ' + 
                dbo.UFN_CREDITTYPECODE_GETDESCRIPTION(CREDITCARDPAYMENTMETHODDETAIL.CREDITTYPECODEID)
            when 5 then  -- Refund Itemized Receipt

                DOCUMENTPRINTINGHISTORY.TYPE + ':  (' + CURRENCY.CURRENCYSYMBOL +
                cast(FT.TRANSACTIONAMOUNT as nvarchar) + ') ' +
                convert(nvarchar, FT.DATEADDED, 101)
            when 6 then  -- Refund Credit Card Receipt

                DOCUMENTPRINTINGHISTORY.TYPE + ':  (' + CURRENCY.CURRENCYSYMBOL +
                cast(CREDITPAYMENT.AMOUNT as nvarchar) + ') ' + ' *' +  
                CREDITCREDITCARDPAYMENTMETHODDETAIL.CREDITCARDPARTIALNUMBER + ' ' + 
                dbo.UFN_CREDITTYPECODE_GETDESCRIPTION(CREDITCREDITCARDPAYMENTMETHODDETAIL.CREDITTYPECODEID) + ' ' +
                convert(nvarchar, FT.DATEADDED, 101)
            else
                DOCUMENTPRINTINGHISTORY.TYPE
        end as [TYPE],
        DOCUMENTPRINTINGHISTORY.PRINTDATEWITHTIMEOFFSET PRINTEDDATE,
        convert(nvarchar, cast(DOCUMENTPRINTINGHISTORY.PRINTDATEWITHTIMEOFFSET as time), 100) PRINTEDTIME,
        APPUSER.DISPLAYNAME APPUSER,
        WORKSTATION.NAME WORKSTATION
    from
        dbo.DOCUMENTPRINTINGHISTORY
    inner join
        dbo.WORKSTATION on DOCUMENTPRINTINGHISTORY.WORKSTATIONID = WORKSTATION.ID
    inner join
        dbo.APPUSER on DOCUMENTPRINTINGHISTORY.APPUSERID = APPUSER.ID
    inner join
        dbo.FINANCIALTRANSACTION as FT on FT.ID = DOCUMENTPRINTINGHISTORY.CREDITID
    left outer join
        dbo.CREDITCARDPAYMENTMETHODDETAIL on DOCUMENTPRINTINGHISTORY.CREDITCARDPAYMENTMETHODDETAILID = CREDITCARDPAYMENTMETHODDETAIL.ID
    left outer join
        dbo.REVENUEPAYMENTMETHOD on CREDITCARDPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID
    left outer join
        dbo.SALESORDERPAYMENT on SALESORDERPAYMENT.PAYMENTID = REVENUEPAYMENTMETHOD.REVENUEID
    left outer join
        dbo.CREDITPAYMENT on CREDITPAYMENT.ID = DOCUMENTPRINTINGHISTORY.CREDITPAYMENTID
    left outer join
        dbo.FINANCIALTRANSACTIONLINEITEM as LI on LI.ID = CREDITPAYMENT.REVENUESPLITID and LI.DELETEDON is null and LI.TYPECODE <> 1  -- Reversal

    left outer join
        dbo.REVENUEPAYMENTMETHOD CREDITREVENUEPAYMENTMETHOD on CREDITREVENUEPAYMENTMETHOD.REVENUEID = isnull(CREDITPAYMENT.REVENUEID, LI.FINANCIALTRANSACTIONID)
    left outer join
        dbo.CREDITCARDPAYMENTMETHODDETAIL CREDITCREDITCARDPAYMENTMETHODDETAIL on CREDITREVENUEPAYMENTMETHOD.PAYMENTMETHODCODE = 2 and CREDITCREDITCARDPAYMENTMETHODDETAIL.ID = CREDITREVENUEPAYMENTMETHOD.ID
    outer apply
        (select top 1 CURRENCYSYMBOL from dbo.CURRENCY where ISORGANIZATIONCURRENCY = 1) CURRENCY
    where
        DOCUMENTPRINTINGHISTORY.CREDITID = @CREDITID