USP_SIMPLEDATALIST_ORDERPAYMENTMETHODS

Returns the available payment methods for the supplied sales order method.

Parameters

Parameter	Parameter Type	Mode	Description
@SALESMETHODID	uniqueidentifier	IN	Sales method

Definition

Copy



            CREATE procedure dbo.USP_SIMPLEDATALIST_ORDERPAYMENTMETHODS(@SALESMETHODID uniqueidentifier) as
                select distinct
                    PAYMENTTYPECODE as VALUE, 
                    PAYMENTTYPE as LABEL
                from dbo.SALESMETHODPAYMENTMETHOD
                where SALESMETHODID = @SALESMETHODID
                order by PAYMENTTYPECODE