USP_DATAFORMTEMPLATE_VIEW_RECEIPTPREFERENCE

The load procedure used by the view dataform template "Receipt Preference View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@RECURRINGGIFTPAYMENTPREFERENCE	nvarchar(50)	INOUT	Recurring gift payments
@PLEDGEPAYMENTPREFERENCE	nvarchar(50)	INOUT	Pledge payments
@RERECEIPTPAYMENTS	nvarchar(3)	INOUT	Allow new receipt numbers for re-receipt payments
@SAMENUMBERONRERECEIPT	nvarchar(3)	INOUT	Allow the same receipt numbers for re-receipt payments
@REGULATEDRECEIPTING	nvarchar(3)	INOUT	Apply strict receipt rules

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RECEIPTPREFERENCE
                (
                    @DATALOADED bit = 0 output,
                    @RECURRINGGIFTPAYMENTPREFERENCE nvarchar(50) = null output,
                    @PLEDGEPAYMENTPREFERENCE nvarchar(50) = null output,
                    @RERECEIPTPAYMENTS nvarchar(3) = null output,
                    @SAMENUMBERONRERECEIPT nvarchar(3) = null output,
                    @REGULATEDRECEIPTING nvarchar(3) = null output
                )
                as
                    set nocount on;

                    select top 1
                        @RECURRINGGIFTPAYMENTPREFERENCE = RECURRINGGIFTPAYMENTPREFERENCE,
                        @PLEDGEPAYMENTPREFERENCE = PLEDGEPAYMENTPREFERENCE,
                        @RERECEIPTPAYMENTS = case RERECEIPTPAYMENTS when 0 then 'No' else 'Yes' end,
                        @SAMENUMBERONRERECEIPT = case SAMENUMBERONRERECEIPT when 0 then 'No' else 'Yes' end
                    from 
                        dbo.RECEIPTPREFERENCEINFO;


                    if exists (select ID from dbo.CONDITIONSETTING where NAME = 'RegulatedReceipting')
                        set @REGULATEDRECEIPTING = 'Yes'
                    else
                        set @REGULATEDRECEIPTING = 'No'

                    select @DATALOADED = 1;

                    return 0;