USP_DATAFORMTEMPLATE_EDITLOAD_VOIDCHECK

The load procedure used by the edit dataform template "Bank Account Disbursement Transaction Void 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.
@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.
@TRANSACTIONNUMBER	int	INOUT
@TRANSACTIONDATE	datetime	INOUT	Payment date
@REVERSALPOSTSTATUS	nvarchar(14)	INOUT	Reversal post status
@REVERSALPOSTDATETYPECODE	tinyint	INOUT	Reversal post date
@REVERSALPOSTDATE	datetime	INOUT
@CLEAREDDATE	datetime	INOUT	Cleared on
@POSTSTATUS	nvarchar(14)	INOUT	Post status
@POSTDATE	datetime	INOUT	Post date
@VOIDDATE	date	INOUT
@VOIDDATETYPECODE	tinyint	INOUT	Void date
@VENDORNAME	nvarchar(154)	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@AMOUNT	money	INOUT
@DESCRIPTION	nvarchar(100)	INOUT
@TRANSACTIONTYPE	nvarchar(23)	INOUT
@TRANSACTIONS	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_VOIDCHECK(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @TRANSACTIONNUMBER int = null output,
    @TRANSACTIONDATE datetime = null output,
    @REVERSALPOSTSTATUS nvarchar(14) = null output,
    @REVERSALPOSTDATETYPECODE tinyint = null output,
    @REVERSALPOSTDATE datetime = null output,
    @CLEAREDDATE datetime = null output,
    @POSTSTATUS nvarchar(14) = null output,
    @POSTDATE datetime = null output,
    @VOIDDATE date = null output,
    @VOIDDATETYPECODE tinyint = null output,
    @VENDORNAME  nvarchar(154) = null output,
    @CONSTITUENTID uniqueidentifier = null output,
    @AMOUNT money = null output,
    @DESCRIPTION  nvarchar(100) = null output,
    @TRANSACTIONTYPE nvarchar(23) = null output,
    @TRANSACTIONS xml = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows
    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = BT.TSLONG,
        @TRANSACTIONNUMBER = BT.TRANSACTIONNUMBER,
        @TRANSACTIONDATE = BT.TRANSACTIONDATE,
        @VOIDDATE = BT.VOIDDATE,
        @CLEAREDDATE = BT.CLEAREDDATE,
        @POSTSTATUS = BT.POSTSTATUS,
        @POSTDATE = BT.POSTDATE,
        @VENDORNAME = C.NAME,
        @CONSTITUENTID = C.ID,
        @AMOUNT = FTPAID.TRANSACTIONAMOUNT,
        @DESCRIPTION = FTPAID.DESCRIPTION,
        @TRANSACTIONTYPE = BT.TRANSACTIONTYPE,
        @TRANSACTIONS = dbo.UFN_BANKACCOUNTDISBURSEMENTTRANSACTIONS_TOITEMLISTXML(@ID, @REVERSALPOSTDATETYPECODE, @REVERSALPOSTDATE, @TRANSACTIONTYPE)
    from dbo.BANKACCOUNTTRANSACTION BT
    join dbo.FINANCIALTRANSACTION FT on BT.ID = FT.ID
    inner join dbo.CONSTITUENT as C on FT.CONSTITUENTID = C.ID
      inner join dbo.FINANCIALTRANSACTIONAPPLICATION as FTA on FT.ID = FTA.FINANCIALTRANSACTIONID and FTA.TYPECODE = 0
      inner join dbo.FINANCIALTRANSACTIONSCHEDULE as FTS on FTA.FINANCIALTRANSACTIONSCHEDULEID = FTS.ID
      inner join dbo.FINANCIALTRANSACTION as FTPAID on FTS.FINANCIALTRANSACTIONID = FTPAID.ID


    where BT.ID = @ID

    return 0;