USP_SIMPLEDATALIST_ORDERPAYMENTOTHERMETHODS

Returns a list of the other payment methods available to order payments for the supplied sales method.

Parameters

Parameter	Parameter Type	Mode	Description
@SALESMETHODID	uniqueidentifier	IN	Sales method

Definition

Copy



        CREATE procedure dbo.USP_SIMPLEDATALIST_ORDERPAYMENTOTHERMETHODS(@SALESMETHODID uniqueidentifier) as
            select 
                OTHERPAYMENTMETHODCODEID as VALUE, 
                dbo.UFN_OTHERPAYMENTMETHODCODE_GETDESCRIPTION(OTHERPAYMENTMETHODCODEID) as LABEL
            from dbo.SALESMETHODPAYMENTMETHOD
            where SALESMETHODID = @SALESMETHODID
                and PAYMENTTYPECODE = 10
            order by dbo.UFN_OTHERPAYMENTMETHODCODE_GETDESCRIPTION(OTHERPAYMENTMETHODCODEID)