USP_DATAFORMTEMPLATE_VIEW_PLEDGEWRITEOFFBATCHPLEDGE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@CALCULATEDUSERDEFINEDID	nvarchar(30)	INOUT
@CONSTITUENTNAME	nvarchar(100)	INOUT
@PDACCOUNTSYSTEMNAME	nvarchar(100)	INOUT
@CONSTITUENTLOOKUPID	nvarchar(30)	INOUT
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT
@TRANSACTIONAMOUNT	money	INOUT
@PLEDGEBALANCE	money	INOUT
@POSTSTATUS	nvarchar(30)	INOUT
@POSTDATE	datetime	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PLEDGEWRITEOFFBATCHPLEDGE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CALCULATEDUSERDEFINEDID nvarchar(30) = null output,
  @CONSTITUENTNAME nvarchar(100) = null output,
  @PDACCOUNTSYSTEMNAME nvarchar(100) = null output,
  @CONSTITUENTLOOKUPID nvarchar(30) = null output,
  @TRANSACTIONCURRENCYID uniqueidentifier = null output,
  @TRANSACTIONAMOUNT money = null output,
  @PLEDGEBALANCE money = null output,
  @POSTSTATUS nvarchar(30) = null output,
  @POSTDATE datetime = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
    @DATALOADED = 1,
    @CALCULATEDUSERDEFINEDID = CALCULATEDUSERDEFINEDID,
    @PDACCOUNTSYSTEMNAME = PDACCOUNTSYSTEM.NAME,
    @CONSTITUENTNAME = CONSTITUENT.NAME,
    @CONSTITUENTLOOKUPID = CONSTITUENT.LOOKUPID,
    @TRANSACTIONAMOUNT = TRANSACTIONAMOUNT,
    @TRANSACTIONCURRENCYID = TRANSACTIONCURRENCYID,
    @PLEDGEBALANCE = dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID),
    @POSTSTATUS = POSTSTATUS,
    @POSTDATE = POSTDATE
    from dbo.FINANCIALTRANSACTION as REVENUE
inner join dbo.CONSTITUENT on REVENUE.CONSTITUENTID = CONSTITUENT.ID
inner join dbo.PDACCOUNTSYSTEM on REVENUE.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
    where REVENUE.ID = @ID

    return 0;