USP_DATALIST_SALESORDERBENEFIT

This datalist returns a list of benefits received for a given salesorder

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SALESORDERBENEFIT(@SALESORDERID uniqueidentifier)
as
    set nocount on;

    select
        BENEFIT.NAME as BENEFIT,
        REVENUEBENEFIT.QUANTITY,
        case when BENEFIT.USEPERCENT = 1 then null else REVENUEBENEFIT.UNITVALUE end as UNITVALUE,
        case when BENEFIT.USEPERCENT = 0 then null else REVENUEBENEFIT.PERCENTAPPLICABLEAMOUNT end as PERCENTAPPLICABLEAMOUNT,
        case when BENEFIT.USEPERCENT = 0 then null else REVENUEBENEFIT.VALUEPERCENT end as VALUEPERCENT,
        REVENUEBENEFIT.TOTALVALUE,
        REVENUEBENEFIT.TRANSACTIONTOTALVALUE,
        REVENUEBENEFIT.DETAILS,
        REVENUEBENEFIT.BASECURRENCYID,
        REVENUEBENEFIT.TRANSACTIONCURRENCYID,
        REVENUEBENEFIT.SEQUENCE,
        REVENUEBENEFIT.ID
    from dbo.SALESORDER
    inner join dbo.REVENUEBENEFIT on REVENUEBENEFIT.REVENUEID = SALESORDER.REVENUEID
    inner join dbo.BENEFIT on BENEFIT.ID = REVENUEBENEFIT.BENEFITID
    where SALESORDER.ID = @SALESORDERID