USP_DATAFORMTEMPLATE_VIEW_MATCHINGGIFTVIEW

The load procedure used by the view dataform template "Matching Gift Detail View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@APPLIEDID	uniqueidentifier	INOUT	Applied ID
@APPLIEDAMOUNT	money	INOUT	Applied amount
@APPLIEDTYPE	nvarchar(100)	INOUT	Applied type
@APPLIEDNAME	nvarchar(400)	INOUT	Applied name
@REVENUEREFERENCE	nvarchar(255)	INOUT	Revenue reference
@APPLIEDTRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Applied transaction currency ID
@ORGANIZATIONAMOUNT	money	INOUT	Organization amount
@BASEEXCHANGERATE	decimal(20, 8)	INOUT	Transaction to base exchange rate
@ORGANIZATIONEXCHANGERATE	decimal(20, 8)	INOUT	Base to organization exchange rate
@APPLIEDLOOKUPID	nvarchar(100)	INOUT	Applied lookup ID
@OPPORTUNITYID	uniqueidentifier	INOUT
@OPPORTUNITYNAME	nvarchar(500)	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MATCHINGGIFTVIEW
                (
                    @ID uniqueidentifier,    
                    @DATALOADED bit = 0 output,
                    @APPLIEDID uniqueidentifier = null output,
                    @APPLIEDAMOUNT money = null output,
                    @APPLIEDTYPE nvarchar(100) = null output,
                    @APPLIEDNAME nvarchar(400) = null output,
                    @REVENUEREFERENCE nvarchar(255) = null output,
                    @APPLIEDTRANSACTIONCURRENCYID uniqueidentifier = null output,
                    @ORGANIZATIONAMOUNT money = null output,
                    @BASEEXCHANGERATE decimal(20,8) = null output,
                    @ORGANIZATIONEXCHANGERATE decimal(20,8) = null output,
                    @APPLIEDLOOKUPID nvarchar(100) = null output,
                    @OPPORTUNITYID uniqueidentifier = null output,
                    @OPPORTUNITYNAME nvarchar(500) = null output
                )
                as

                set nocount on;

                set @DATALOADED = 1;

                select top 1
                    @APPLIEDID = FINANCIALTRANSACTION.ID,
                    @APPLIEDAMOUNT  = FINANCIALTRANSACTION.TRANSACTIONAMOUNT,
                    @APPLIEDTYPE = FINANCIALTRANSACTION.TYPE,
                    @APPLIEDNAME = NF.NAME,
                    @APPLIEDTRANSACTIONCURRENCYID = FINANCIALTRANSACTION.TRANSACTIONCURRENCYID,
                    @APPLIEDLOOKUPID = CONSTITUENT.LOOKUPID
                from dbo.REVENUEMATCHINGGIFT
                    inner join dbo.FINANCIALTRANSACTION on REVENUEMATCHINGGIFT.MGSOURCEREVENUEID = FINANCIALTRANSACTION.ID
                    inner join dbo.CONSTITUENT on FINANCIALTRANSACTION.CONSTITUENTID = CONSTITUENT.ID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FINANCIALTRANSACTION.CONSTITUENTID) NF 

                where REVENUEMATCHINGGIFT.ID = @ID;

                select
                    @REVENUEREFERENCE = REVENUEREFERENCE.REFERENCE
                from dbo.REVENUEREFERENCE
                where REVENUEREFERENCE.ID = @APPLIEDID;

                select
                    @ORGANIZATIONAMOUNT = FINANCIALTRANSACTION.ORGAMOUNT,
                    @BASEEXCHANGERATE = BASERATE.RATE,
                    @ORGANIZATIONEXCHANGERATE = ORGANIZATIONRATE.RATE
                from dbo.FINANCIALTRANSACTION
                    left join dbo.CURRENCYEXCHANGERATE BASERATE on FINANCIALTRANSACTION.BASEEXCHANGERATEID = BASERATE.ID
                    left join dbo.CURRENCYEXCHANGERATE ORGANIZATIONRATE on FINANCIALTRANSACTION.ORGEXCHANGERATEID = ORGANIZATIONRATE.ID
                where FINANCIALTRANSACTION.ID = @ID;

                select
                    @OPPORTUNITYID = REVENUEOPPORTUNITY.OPPORTUNITYID,
                    @OPPORTUNITYNAME = dbo.UFN_OPPORTUNITY_GETDESCRIPTION(REVENUEOPPORTUNITY.OPPORTUNITYID)
                from dbo.REVENUEOPPORTUNITY
                inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.ID = REVENUEOPPORTUNITY.ID
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @ID;

                return 0;