USP_DATALIST_SALESORDERREVENUECREDIT

Returns a list of credits applied against a sales order.

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SALESORDERREVENUECREDIT(@REVENUEID uniqueidentifier)
as
    set nocount on;

    select
        FT.ID,
        coalesce(cast(FT.DATE as datetime), SALESORDER.TRANSACTIONDATE),
        FT.TYPE,
        FT.TRANSACTIONAMOUNT as AMOUNT
    from
        dbo.SALESORDER
    cross apply
        dbo.UFN_SALESORDER_REFUNDS(SALESORDER.ID) as REFUNDS
    inner join
        dbo.FINANCIALTRANSACTION as FT on FT.ID = REFUNDS.ID
    where
        SALESORDER.REVENUEID = @REVENUEID

    return 0;