USP_DATALIST_REVENUEBENEFIT

This datalist returns a list of benefits received for revenue within a revenue context.

Parameters

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

Definition

Copy



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

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