USP_DATAFORMTEMPLATE_VIEW_PLANNEDGIFTSTOBERECONCILED

The load procedure used by the view dataform template "Planned Gift Reconciliation List Detail View"

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.
@ORIGINALAMOUNT	money	INOUT	Original amount (base currency)
@ADJUSTEDAMOUNT	money	INOUT	Adjusted amount (base currency)
@ORIGINALDATE	datetime	INOUT	Original date
@ADJUSTEDDATE	datetime	INOUT	Adjusted date
@DESIGNATIONSCHANGED	bit	INOUT	Designations changed
@DATECHANGED	datetime	INOUT	Date changed
@CHANGEDBY	nvarchar(200)	INOUT	Changed by
@ORIGINALDONOTRECEIPT	bit	INOUT	Original do not receipt
@ADJUSTEDDONOTRECEIPT	bit	INOUT	Adjusted do not receipt
@ORIGINALRECEIPTAMOUNT	money	INOUT	Original receipt amount
@ADJUSTEDRECEIPTAMOUNT	money	INOUT	Adjusted receipt amount
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	TRANSACTIONCURRENCYID
@TRANSACTIONORIGINALAMOUNT	money	INOUT	Original amount
@TRANSACTIONADJUSTEDAMOUNT	money	INOUT	Adjusted amount

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PLANNEDGIFTSTOBERECONCILED
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ORIGINALAMOUNT money = null output,
    @ADJUSTEDAMOUNT money = null output,
    @ORIGINALDATE datetime = null output,
    @ADJUSTEDDATE datetime = null output,
    @DESIGNATIONSCHANGED bit = null output,
    @DATECHANGED datetime = null output,
    @CHANGEDBY nvarchar(200) = null output,
  @ORIGINALDONOTRECEIPT bit = null output,
    @ADJUSTEDDONOTRECEIPT bit = null output,
  @ORIGINALRECEIPTAMOUNT money = null output,
    @ADJUSTEDRECEIPTAMOUNT money = null output,
    @BASECURRENCYID uniqueidentifier = null output,
  @TRANSACTIONCURRENCYID uniqueidentifier = null output,
  @TRANSACTIONORIGINALAMOUNT money = null output,
  @TRANSACTIONADJUSTEDAMOUNT money = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select 
    @DATALOADED = 1,
    @ORIGINALAMOUNT = PLANNEDGIFTRECONCILE.OLDAMOUNT,
    @ADJUSTEDAMOUNT = PLANNEDGIFTRECONCILE.NEWAMOUNT,
    @ORIGINALDATE = PLANNEDGIFTRECONCILE.OLDDATE, 
    @ADJUSTEDDATE = PLANNEDGIFTRECONCILE.NEWDATE,
    @DESIGNATIONSCHANGED = PLANNEDGIFTRECONCILE.DESIGNATIONCHANGED,
    @DATECHANGED = PLANNEDGIFTRECONCILE.DATECHANGED,
    @CHANGEDBY = CHANGEAGENT.USERNAME,
    @ORIGINALDONOTRECEIPT = PLANNEDGIFTRECONCILE.OLDDONOTRECEIPT,
    @ADJUSTEDDONOTRECEIPT = PLANNEDGIFTRECONCILE.DONOTRECEIPT,
    @ORIGINALRECEIPTAMOUNT = PLANNEDGIFTRECONCILE.OLDRECEIPTAMOUNT,
    @ADJUSTEDRECEIPTAMOUNT = PLANNEDGIFTRECONCILE.RECEIPTAMOUNT,
      @BASECURRENCYID = PLANNEDGIFTRECONCILE.BASECURRENCYID,
    @TRANSACTIONCURRENCYID = PLANNEDGIFTRECONCILE.TRANSACTIONCURRENCYID,
    @TRANSACTIONORIGINALAMOUNT = PLANNEDGIFTRECONCILE.TRANSACTIONOLDAMOUNT,
    @TRANSACTIONADJUSTEDAMOUNT = PLANNEDGIFTRECONCILE.TRANSACTIONNEWAMOUNT
  from
    dbo.PLANNEDGIFTRECONCILE
      --left join dbo.REVENUE on PLANNEDGIFTRECONCILE.REVENUEID = REVENUE.ID

    left join dbo.CHANGEAGENT on PLANNEDGIFTRECONCILE.CHANGEDBYID = CHANGEAGENT.ID
  where
    PLANNEDGIFTRECONCILE.ID = @ID;

  return 0;