USP_DATALIST_SALESMETHODPAYMENTMETHOD

List all payment methods available to a sales method

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SALESMETHODPAYMENTMETHOD
(
    @ID uniqueidentifier
)
as
    set nocount on;

    select
        ID,
        case when PAYMENTTYPECODE = 10 then
            dbo.UFN_OTHERPAYMENTMETHODCODE_GETDESCRIPTION(OTHERPAYMENTMETHODCODEID)
        else
            PAYMENTTYPE
        end as [PAYMENTTYPE]        
    from
        dbo.SALESMETHODPAYMENTMETHOD
    where
        SALESMETHODPAYMENTMETHOD.SALESMETHODID = @ID

    return 0;