USP_DATAFORMTEMPLATE_VIEW_REVENUEHISTORYPAGEDATA

The load procedure used by the view dataform template "Revenue History Page Expression 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.
@REVENUEDATE	datetime	INOUT	Revenue date
@ISPAYMENT	bit	INOUT	Is payment
@REVENUETYPE	nvarchar(50)	INOUT	Revenue type
@REVENUEAMOUNT	money	INOUT	Revenue amount
@REVENUECONSTITUENTNAME	nvarchar(700)	INOUT	Revenue constituent name
@REVENUECONSTITUENTID	uniqueidentifier	INOUT	Revenue constituent ID
@TRANSACTIONID	uniqueidentifier	INOUT	Revenue ID
@TRANSACTIONAMOUNT	money	INOUT	Revenue amount
@ISPOSTABLE	bit	INOUT	ISPOSTABLE
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	TRANSACTIONCURRENCYID

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUEHISTORYPAGEDATA
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @REVENUEDATE datetime = null output,
                    @ISPAYMENT bit = null output,
                    @REVENUETYPE nvarchar(50) = null output,
                    @REVENUEAMOUNT money = null output,
                    @REVENUECONSTITUENTNAME nvarchar(700) = null output,
                    @REVENUECONSTITUENTID uniqueidentifier = null output,
                    @TRANSACTIONID uniqueidentifier = null output,
                    @TRANSACTIONAMOUNT money = null output,
                    @ISPOSTABLE bit = null output,
          @TRANSACTIONCURRENCYID uniqueidentifier = null output
                )
                as
                set nocount on;

                set @DATALOADED = 0;
                set @ISPAYMENT = 0;

                select
                    @DATALOADED = 1,
                    @REVENUEDATE = cast(FINANCIALTRANSACTION.DATE as datetime),
                    @ISPAYMENT = case when FINANCIALTRANSACTION.TYPECODE = 0 then 1 else 0 end,
                    @REVENUETYPE = FINANCIALTRANSACTION.TYPE,
                    @REVENUEAMOUNT = FINANCIALTRANSACTION.BASEAMOUNT,
                    @REVENUECONSTITUENTNAME = NF.NAME,
                    @REVENUECONSTITUENTID = FINANCIALTRANSACTION.CONSTITUENTID,
                    @TRANSACTIONID = FINANCIALTRANSACTION.ID,
                    @TRANSACTIONAMOUNT = FINANCIALTRANSACTION.TRANSACTIONAMOUNT,
                    @ISPOSTABLE = case when FINANCIALTRANSACTION.TYPECODE in (2, 3, 8, 15) then 0 else 1 end,
                    @TRANSACTIONCURRENCYID = FINANCIALTRANSACTION.TRANSACTIONCURRENCYID
                from dbo.FINANCIALTRANSACTION
                inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FINANCIALTRANSACTION.CONSTITUENTID) NF
                where FINANCIALTRANSACTION.ID = @ID
                    and FINANCIALTRANSACTION.DELETEDON is null;