USP_REPORT_DEFAULTREFUNDITEMIZEDRECEIPT_GETORDERINFORMATION

create procedure [dbo].[USP_REPORT_DEFAULTREFUNDITEMIZEDRECEIPT_GETORDERINFORMATION]
(
    @CREDITID uniqueidentifier
)
as
    set nocount on;
    set transaction isolation level read uncommitted;

    select
        isnull(sum(CREDITPAYMENT.AMOUNT), 0) ORDERTOTAL,
        cast(dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(getutcdate()) as nvarchar) TIMEOFPURCHASE,
        coalesce(CHILDSALESORDER.SEQUENCEID, SALESORDER.SEQUENCEID, 0) ORDERNUMBER
    from 
        dbo.FINANCIALTRANSACTION as FT
    inner join
        dbo.CREDIT_EXT as EXT on EXT.ID = FT.ID
    left outer join 
        dbo.CREDITPAYMENT on CREDITPAYMENT.CREDITID = FT.ID
    left outer join
        dbo.SALESORDER as CHILDSALESORDER on CHILDSALESORDER.REVENUEID = FT.PARENTID
    left outer join 
        dbo.SALESORDER on SALESORDER.ID = EXT.SALESORDERID
    where 
        FT.ID = @CREDITID
    group by 
        coalesce(CHILDSALESORDER.SEQUENCEID, SALESORDER.SEQUENCEID, 0);

    return 0;