USP_DATAFORMTEMPLATE_PRELOAD_ADD_PAYMENT

Stored procedure used to load on the payment add form.

Parameters

Parameter	Parameter Type	Mode
@HOUSEHOLDSCANBEDONORS	bit	INOUT
@APPLICATIONCODE	tinyint	INOUT
@DATE	datetime	INOUT
@GIFTINKINDUSEAPPRAISALTHRESHOLD	bit	INOUT
@GIFTINKINDAPPRAISALTHRESHOLD	money	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT
@SHOWACCOUNTSYSTEM	bit	INOUT

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PAYMENT
            (
                @HOUSEHOLDSCANBEDONORS bit = null output,
                @APPLICATIONCODE tinyint = null output,
                @DATE datetime = null output,
                @GIFTINKINDUSEAPPRAISALTHRESHOLD bit = null output,
                @GIFTINKINDAPPRAISALTHRESHOLD money = null output,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                @SHOWACCOUNTSYSTEM bit = null output                
            )
            as
                set nocount on;

                set @HOUSEHOLDSCANBEDONORS = dbo.UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS()
                set @APPLICATIONCODE = 0;
                set @DATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());
                select top 1
                    @GIFTINKINDUSEAPPRAISALTHRESHOLD = USEAPPRAISALTHRESHOLD,
                    @GIFTINKINDAPPRAISALTHRESHOLD = APPRAISALTHRESHOLD
                from
                    dbo.GIFTINKINDAPPRAISALSETTINGS

                if dbo.UFN_VALID_BASICGL_INSTALLED() != 0
                    begin
                        declare    @NUMBEROFACCOUNTSYSTEMSFORUSER smallint 

                        set @NUMBEROFACCOUNTSYSTEMSFORUSER = dbo.UFN_PDACCOUNTSYSTEM_GETNUMBEROFSYSTEMSFORUSER(@CURRENTAPPUSERID)
                        if @NUMBEROFACCOUNTSYSTEMSFORUSER = 1
                            begin
                                set @SHOWACCOUNTSYSTEM = 0
                                select @PDACCOUNTSYSTEMID =  T1.ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSER(@CURRENTAPPUSERID) as T1
                            end 
                        else
                            begin
                                set @SHOWACCOUNTSYSTEM = 1        
                                set @PDACCOUNTSYSTEMID = dbo.UFN_PDACCOUNTSYSTEM_GETDEFAULTSYSTEMIDSFORUSER(@CURRENTAPPUSERID)
                            end 
                    end
                else
                    begin
                        set @SHOWACCOUNTSYSTEM = 0
                        set @PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'
                    end