UFN_SALESMETHODDISCOUNT_GETDISCOUNTS

This function returns the discounts 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_SALESMETHODDISCOUNT_GETDISCOUNTS
            (
                @SALESMETHODID uniqueidentifier
            )
            returns table
            as return

                select ID,
                    DISCOUNTID
                from dbo.SALESMETHODDISCOUNT
                where SALESMETHODID=@SALESMETHODID;