USP_DATALIST_SALESDEPOSITTEMPLATEPAYMENTMETHODLOOKUP

Provides look-up information for sales deposit template payment methods within a deposit process.

Parameters

Parameter	Parameter Type	Mode	Description
@SALESDEPOSITPROCESSID	uniqueidentifier	IN	Sales deposit process ID
@SALESDEPOSITTEMPLATEID	uniqueidentifier	IN	Sales deposit template ID
@PAYMENTMETHODCODE	tinyint	IN	Payment method code
@CREDITTYPECODEID	uniqueidentifier	IN	Credit card type code ID
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN	Other payment method code ID

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_SALESDEPOSITTEMPLATEPAYMENTMETHODLOOKUP
                (
                    @SALESDEPOSITPROCESSID uniqueidentifier,
                    @SALESDEPOSITTEMPLATEID uniqueidentifier = null,
                    @PAYMENTMETHODCODE tinyint = null,
                    @CREDITTYPECODEID uniqueidentifier = null,
                    @OTHERPAYMENTMETHODCODEID uniqueidentifier = null
                )
                as
                set nocount on;

                    select
                        [SALESDEPOSITTEMPLATE].[NAME],
                        [SALESDEPOSITTEMPLATE].[ID],
                        [SALESDEPOSITTEMPLATEPAYMENTMETHOD].[PAYMENTMETHODCODE],
                        [SALESDEPOSITTEMPLATEPAYMENTMETHOD].[CREDITTYPECODEID],
                        [SALESDEPOSITTEMPLATEPAYMENTMETHOD].[OTHERPAYMENTMETHODCODEID]
                    from dbo.[SALESDEPOSITTEMPLATE]
                    inner join dbo.[SALESDEPOSITTEMPLATEPAYMENTMETHOD]
                        on [SALESDEPOSITTEMPLATE].[ID] = [SALESDEPOSITTEMPLATEPAYMENTMETHOD].[SALESDEPOSITTEMPLATEID]
                    where
                        [SALESDEPOSITTEMPLATE].[SALESDEPOSITPROCESSID] = @SALESDEPOSITPROCESSID and
                        ([SALESDEPOSITTEMPLATEPAYMENTMETHOD].[SALESDEPOSITTEMPLATEID] = @SALESDEPOSITTEMPLATEID or @SALESDEPOSITTEMPLATEID is null) and
                        (
                            ([SALESDEPOSITTEMPLATEPAYMENTMETHOD].[PAYMENTMETHODCODE] = @PAYMENTMETHODCODE and
                                ([SALESDEPOSITTEMPLATEPAYMENTMETHOD].[PAYMENTMETHODCODE] <> 2 or ([SALESDEPOSITTEMPLATEPAYMENTMETHOD].[CREDITTYPECODEID] = @CREDITTYPECODEID or @CREDITTYPECODEID is null)) and
                                ([SALESDEPOSITTEMPLATEPAYMENTMETHOD].[PAYMENTMETHODCODE] <> 10 or ([SALESDEPOSITTEMPLATEPAYMENTMETHOD].[OTHERPAYMENTMETHODCODEID] = @OTHERPAYMENTMETHODCODEID or @OTHERPAYMENTMETHODCODEID is null))
                            ) or 
                            @PAYMENTMETHODCODE is null
                        )
                    order by [SALESDEPOSITTEMPLATEPAYMENTMETHOD].[PAYMENTMETHODCODE]