USP_DATALIST_REFUNDDISCOUNTGLDISTRIBUTION

CREATE procedure dbo.USP_DATALIST_REFUNDDISCOUNTGLDISTRIBUTION(
    @ID uniqueidentifier
)
as
    set nocount on;

    select
        JE.TRANSACTIONTYPE,
        isnull(GLACCOUNT.ACCOUNTNUMBER, '') as ACCOUNT,
        JE.TRANSACTIONAMOUNT as AMOUNT,
        isnull(convert(nvarchar(255),JE.COMMENT),'') as REFERENCE
    from dbo.JOURNALENTRY_EXT as JEXT
    inner join dbo.JOURNALENTRY as JE on JE.ID = JEXT.ID
    inner join dbo.FINANCIALTRANSACTIONLINEITEM as LI on LI.ID = JEXT.CREDITITEMID
    left outer join dbo.GLACCOUNT on GLACCOUNT.ID = JE.GLACCOUNTID
    where
        LI.FINANCIALTRANSACTIONID = @ID and 
        JEXT.DISCOUNTCREDITITEMID is not null -- Make sure these are actually discount distributions

    order by JE.TRANSACTIONTYPE, isnull(GLACCOUNT.ACCOUNTNUMBER, '') desc;

    return 0;