USP_DATALIST_SALESMETHODFEE

List all fees associated with a sales method.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_SALESMETHODFEE
                (
                    @ID uniqueidentifier,
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on;

                    select 
                        SALESMETHODFEE.ID,
                        FEE.NAME,
                        FEE.APPLIESTO,
                        case FEE.[TYPECODE] when 0 then FEE.AMOUNT else null end,
                        case FEE.[TYPECODE] when 1 then FEE.[PERCENT] else null end,
                        FEE.ISACTIVE,
                        FEE.[DESCRIPTION]
                    from dbo.SALESMETHODFEE
                    inner join dbo.FEE on SALESMETHODFEE.FEEID = FEE.ID
                    where 
                        SALESMETHODFEE.SALESMETHODID = @ID and
                        (@INCLUDEINACTIVE = 1 or FEE.ISACTIVE = 1)

                    return 0;