USP_DATAFORMTEMPLATE_VIEW_PENDINGGIFTPAYMENTINFORMATION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TRANSACTIONTYPE	nvarchar(20)	INOUT
@AMOUNT	money	INOUT
@PAYMENTMETHODCODE	tinyint	INOUT
@PAYMENTMETHOD	nvarchar(28)	INOUT
@CHECKDATE	UDT_FUZZYDATE	INOUT
@CHECKNUMBER	nvarchar(20)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PENDINGGIFTPAYMENTINFORMATION
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TRANSACTIONTYPE nvarchar(20) = null output,
  @AMOUNT money = null output,
  @PAYMENTMETHODCODE tinyint = null output,
  @PAYMENTMETHOD nvarchar(28) = null output,
  @CHECKDATE UDT_FUZZYDATE = null output,
  @CHECKNUMBER nvarchar(20) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

    select @DATALOADED = 1,
           @TRANSACTIONTYPE = [REVENUE].TYPE,
           @AMOUNT =  [REVENUE].TRANSACTIONAMOUNT,
           @PAYMENTMETHODCODE = RPM.PAYMENTMETHODCODE,
       @PAYMENTMETHOD = RPM.PAYMENTMETHOD,
       @CHECKDATE = CPM.CHECKDATE,
       @CHECKNUMBER = coalesce(CPM.CHECKNUMBER, ROD.CHECKNUMBER)
    from dbo.FINANCIALTRANSACTION [REVENUE]
  left join dbo.REVENUEPAYMENTMETHOD RPM with (nolock) on RPM.REVENUEID = [REVENUE].ID
  left join dbo.CHECKPAYMENTMETHODDETAIL CPM With (nolock) on RPM.ID = CPM.ID
  left join dbo.REVENUEOFFLINEDONATION ROD on [REVENUE].ID = ROD.ID
    where [REVENUE].ID = @ID

    return 0;