USP_DATAFORMTEMPLATE_LOAD_NAMINGOPPORTUNITYREVENUERECOGNITION

The load procedure used by the edit dataform template "Naming Opportunity Revenue Recognition Edit 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.
@NAMINGOPPORTUNITYID	uniqueidentifier	INOUT	Naming opportunity
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent
@CONSTITUENTNAMEFORMATID	uniqueidentifier	INOUT	Name format
@CUSTOMNAMEFORMAT	nvarchar(100)	INOUT	Custom name format
@STARTDATE	UDT_FUZZYDATE	INOUT	Recognition date
@ENDDATE	UDT_FUZZYDATE	INOUT	Recognition ends
@AMOUNT	money	INOUT	Recognition amount
@QUANTITY	int	INOUT	Quantity
@INSCRIPTION	nvarchar(max)	INOUT	Inscription
@SPECIALREQUEST	nvarchar(max)	INOUT	Special request
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@REVENUESPLITAPPLICATION	nvarchar(100)	INOUT	Revenue split application
@REVENUESPLITAMOUNT	money	INOUT	Revenue split amount
@REVENUESPLITISO4217	nvarchar(3)	INOUT	ISO4217
@REVENUESPLITDECIMALDIGITS	tinyint	INOUT	Decimal digits
@REVENUESPLITCURRENCYSYMBOL	nvarchar(5)	INOUT	Currency symbol
@REVENUESPLITSYMBOLDISPLAYSETTINGCODE	tinyint	INOUT	Symbol display setting
@CONSTITUENTNAME	nvarchar(255)	INOUT	Constituent name

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_LOAD_NAMINGOPPORTUNITYREVENUERECOGNITION
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @NAMINGOPPORTUNITYID uniqueidentifier = null output,
                        @CONSTITUENTID uniqueidentifier = null output,
                        @CONSTITUENTNAMEFORMATID uniqueidentifier = null output,
                        @CUSTOMNAMEFORMAT nvarchar(100) = null output,
                        @STARTDATE dbo.UDT_FUZZYDATE = null output,
                        @ENDDATE dbo.UDT_FUZZYDATE = null output,
                        @AMOUNT money = null output,
                        @QUANTITY int = null output,
                        @INSCRIPTION nvarchar(max) = null output,
                        @SPECIALREQUEST nvarchar(max) = null output,
                        @TSLONG bigint = 0 output,
                        @BASECURRENCYID uniqueidentifier = null output,
                        @REVENUESPLITAPPLICATION nvarchar(100) = null output,
                        @REVENUESPLITAMOUNT money = null output,
                        @REVENUESPLITISO4217 nvarchar(3)  = null output,
                        @REVENUESPLITDECIMALDIGITS tinyint = null output,
                        @REVENUESPLITCURRENCYSYMBOL nvarchar(5) = null output,
                        @REVENUESPLITSYMBOLDISPLAYSETTINGCODE tinyint = null output,
                        @CONSTITUENTNAME nvarchar(255) = null output
                    )
                    as
                    set nocount on;

                    select
                        @DATALOADED = 1,
                        @NAMINGOPPORTUNITYID = NAMINGOPPORTUNITYRECOGNITION.NAMINGOPPORTUNITYID,
                        @CONSTITUENTID = NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTID,
                        @CONSTITUENTNAMEFORMATID = NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTNAMEFORMATID,
                        @CUSTOMNAMEFORMAT = NAMINGOPPORTUNITYRECOGNITION.CUSTOMNAMEFORMAT,
                        @STARTDATE = NAMINGOPPORTUNITYRECOGNITION.STARTDATE,
                        @ENDDATE = NAMINGOPPORTUNITYRECOGNITION.ENDDATE,
                        @AMOUNT = NAMINGOPPORTUNITYRECOGNITION.AMOUNT,
                        @QUANTITY = NAMINGOPPORTUNITYRECOGNITION.QUANTITY,
                        @INSCRIPTION = NAMINGOPPORTUNITYRECOGNITION.INSCRIPTION,
                        @SPECIALREQUEST = NAMINGOPPORTUNITYRECOGNITION.SPECIALREQUEST,
                        @TSLONG = NAMINGOPPORTUNITYRECOGNITION.TSLONG,
                        @BASECURRENCYID = NAMINGOPPORTUNITYRECOGNITION.BASECURRENCYID,
                        @REVENUESPLITAPPLICATION = REVENUESPLIT_EXT.APPLICATION,
                        @REVENUESPLITAMOUNT = FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT,
                        @REVENUESPLITISO4217 = CURRENCY.ISO4217,
                        @REVENUESPLITDECIMALDIGITS = CURRENCY.DECIMALDIGITS,
                        @REVENUESPLITCURRENCYSYMBOL = CURRENCY.CURRENCYSYMBOL,
                        @REVENUESPLITSYMBOLDISPLAYSETTINGCODE = CURRENCY.SYMBOLDISPLAYSETTINGCODE,
                        @CONSTITUENTNAME = NF.NAME
                    from
                      dbo.NAMINGOPPORTUNITYRECOGNITION
                    inner join
                      dbo.NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT on NAMINGOPPORTUNITYRECOGNITION.ID = NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.NAMINGOPPORTUNITYRECOGNITIONID
                    inner join
                      dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.ID = NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.REVENUESPLITID
                    inner join
                      dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                    inner join
                      dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                    inner join
                      dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                    inner join
                      dbo.CURRENCY on CURRENCY.ID = FINANCIALTRANSACTION.TRANSACTIONCURRENCYID
                    outer apply
                      dbo.UFN_CONSTITUENT_DISPLAYNAME(FINANCIALTRANSACTION.CONSTITUENTID) NF
                    where
                      NAMINGOPPORTUNITYRECOGNITION.ID = @ID
                      and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1
                      and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null;

                    if not @CONSTITUENTNAMEFORMATID is null
                        set @CUSTOMNAMEFORMAT = N'';