UFN_SALESMETHODFEE_GETFEES

This function returns the fees associated with a sales type's ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SALESMETHODID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_SALESMETHODFEE_GETFEES
            (
                @SALESMETHODID uniqueidentifier
            )
            returns table
            as return

                select 
                    SALESMETHODFEE.ID,
                    FEEID
                from dbo.SALESMETHODFEE
                inner join dbo.FEE on SALESMETHODFEE.FEEID = FEE.ID
                where SALESMETHODID=@SALESMETHODID and FEE.ISACTIVE = 1;