UFN_DELIVERYMETHODFEE_GETFEES

This function returns a delivery type's fees types given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DELIVERYMETHODID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_DELIVERYMETHODFEE_GETFEES
        (
            @DELIVERYMETHODID uniqueidentifier
        )
            returns table
            as return
                select
                    DELIVERYMETHODFEE.ID,
                    FEEID
                from
                    dbo.DELIVERYMETHODFEE
                inner join dbo.FEE on
                    DELIVERYMETHODFEE.FEEID = FEE.ID
                where
                    FEE.ISACTIVE = 1 and 
                    DELIVERYMETHODID=@DELIVERYMETHODID;