USP_DATAFORMTEMPLATE_VIEW_BANKACCOUNTDISBURSEMENTPAGEDATA

The load procedure used by the view dataform template "Bank Account Disbursement Expression 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.
@BANKACCOUNTID	uniqueidentifier	INOUT	Bank account
@BANKACCOUNTNAME	nvarchar(100)	INOUT	Account name
@TRANSACTIONDATE	datetime	INOUT	Check date
@TRANSACTIONTYPE	nvarchar(60)	INOUT	Transaction Type
@TRANSACTIONNUMBER	int	INOUT	Check number
@AMOUNT	numeric(19, 4)	INOUT	Check amount
@STATUSCODE	tinyint	INOUT	Status code
@BANKACCOUNTSTATUS	tinyint	INOUT	Bank account status
@PURGED	bit	INOUT	Purged

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BANKACCOUNTDISBURSEMENTPAGEDATA
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @BANKACCOUNTID uniqueidentifier = null output,
    @BANKACCOUNTNAME nvarchar(100) = null output, 
    @TRANSACTIONDATE datetime = null output,
    @TRANSACTIONTYPE nvarchar(60) = null output,
    @TRANSACTIONNUMBER int = null output,    
    @AMOUNT numeric(19,4) = null output,
    @STATUSCODE tinyint = null output,
    @BANKACCOUNTSTATUS tinyint = null output,
    @PURGED bit = null output

)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

                    select
                        @DATALOADED = 1,
                        @TRANSACTIONDATE = BAT.TRANSACTIONDATE,
                        @AMOUNT = BAT.AMOUNT,
                        @TRANSACTIONNUMBER = BAT.TRANSACTIONNUMBER,
                        @TRANSACTIONTYPE = case BAT.TRANSACTIONTYPECODE when 1 then 'Check' else '' end,
                        @BANKACCOUNTID = BAT.BANKACCOUNTID,
                        @BANKACCOUNTNAME = BA.ACCOUNTNAME,
                        @STATUSCODE = BAT.STATUSCODE,
                        @BANKACCOUNTSTATUS = BA.STATUSCODE,
                        @PURGED = dbo.UFN_BANKACCOUNTDISBURSEMENT_ISPURGED(@ID)

                    from dbo.BANKACCOUNTTRANSACTION as BAT
                    inner join dbo.BANKACCOUNT as BA on BAT.BANKACCOUNTID = BA.ID

                    where BAT.ID = @ID and BAT.DELETED = 0

                    return 0;