USP_DATALIST_CREDITREFUNDDONATION

CREATE procedure dbo.USP_DATALIST_CREDITREFUNDDONATION
(
    @CREDITID uniqueidentifier
)
as
    set nocount on;

    select 
        EXT.SALESORDERITEMID as ID,
        SALESORDERITEM.[DESCRIPTION],
        SALESORDERITEMDONATION.DESIGNATIONNAME,
        LI.BASEAMOUNT - EXT.DISCOUNTS as TOTAL,
        SALESORDERITEM.SALESORDERID
    from
        dbo.FINANCIALTRANSACTIONLINEITEM LI
    inner join
        dbo.CREDITITEM_EXT as EXT on EXT.ID = LI.ID
    inner join
        dbo.SALESORDERITEM on SALESORDERITEM.ID = EXT.SALESORDERITEMID
    inner join
        dbo.SALESORDERITEMDONATION on SALESORDERITEMDONATION.ID = EXT.SALESORDERITEMID
    where
        LI.FINANCIALTRANSACTIONID = @CREDITID

    return 0;