USP_DATAFORMTEMPLATE_EDITLOAD_BANKACCOUNTEFTINFO

The load procedure used by the edit dataform template "Bank Account EFT Info Edit Data 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.
@IMMEDIATEDESTINATIONNUMBER	nvarchar(10)	INOUT	Immediate destination
@IMMEDIATEDESTINATIONNAME	nvarchar(23)	INOUT	Immediate destination name
@IMMEDIATEORIGINNUMBEROPTIONCODE	tinyint	INOUT	Immediate origin
@IMMEDIATEORIGINNUMBER	nvarchar(10)	INOUT	Immediate origin
@IMMEDIATEORIGINNAMEOPTIONCODE	tinyint	INOUT	Immediate origin name
@IMMEDIATEORIGINNAME	nvarchar(23)	INOUT	Immediate origin name
@REFERENCECODE	nvarchar(8)	INOUT	Reference code
@COMPANYNAMEOPTIONCODE	tinyint	INOUT	Company name
@COMPANYNAME	nvarchar(16)	INOUT	Company name
@COMPANYIDPREFIX	tinyint	INOUT	Company ID prefix
@COMPANYID	nvarchar(9)	INOUT	Company ID
@CREATEOFFSETTINGTRANSACTIONS	bit	INOUT	Create offsetting transactions
@INCLUDECARRIAGERETURN	bit	INOUT	Include carriage return/line feed
@ROUTINGNUMBER	nvarchar(9)	INOUT	Routing number
@ORGNAME	nvarchar(100)	INOUT	Organization name
@ORGEIN	nvarchar(20)	INOUT	Organization EIN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BANKACCOUNTEFTINFO(
    @ID uniqueidentifier
    ,@DATALOADED bit = 0 output
    ,@TSLONG bigint = 0 output
    ,@IMMEDIATEDESTINATIONNUMBER nvarchar(10) = null output
    ,@IMMEDIATEDESTINATIONNAME nvarchar(23) = null output
    ,@IMMEDIATEORIGINNUMBEROPTIONCODE tinyint = null output
    ,@IMMEDIATEORIGINNUMBER nvarchar(10) = null output
    ,@IMMEDIATEORIGINNAMEOPTIONCODE tinyint = null output
    ,@IMMEDIATEORIGINNAME nvarchar(23) = null output
    ,@REFERENCECODE nvarchar(8) = null output
    ,@COMPANYNAMEOPTIONCODE tinyint = null output
    ,@COMPANYNAME nvarchar(16) = null output
    ,@COMPANYIDPREFIX tinyint = null output
    ,@COMPANYID nvarchar(9) = null output
    ,@CREATEOFFSETTINGTRANSACTIONS bit = null output
    ,@INCLUDECARRIAGERETURN bit = null output
    ,@ROUTINGNUMBER nvarchar(9) = null output
    ,@ORGNAME nvarchar(100) = null output
    ,@ORGEIN nvarchar(20) = null output
)
as

    set nocount on;

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

    set @DATALOADED = 0
    set @TSLONG = 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.  Also note that we fetch the TSLONG so that concurrency

    -- can be considered.

    select
        @DATALOADED = 1
        ,@TSLONG = isnull(EFT.TSLONG, BA.TSLONG)
        ,@IMMEDIATEDESTINATIONNUMBER = EFT.IMMEDIATEDESTINATIONNUMBER
        ,@IMMEDIATEDESTINATIONNAME = EFT.IMMEDIATEDESTINATIONNAME
        ,@IMMEDIATEORIGINNUMBEROPTIONCODE = isnull(EFT.IMMEDIATEORIGINNUMBEROPTIONCODE, 0)
        ,@IMMEDIATEORIGINNUMBER = EFT.IMMEDIATEORIGINNUMBER
        ,@IMMEDIATEORIGINNAMEOPTIONCODE = isnull(EFT.IMMEDIATEORIGINNAMEOPTIONCODE, 0)
        ,@IMMEDIATEORIGINNAME = EFT.IMMEDIATEORIGINNAME
        ,@REFERENCECODE = EFT.REFERENCECODE
        ,@COMPANYNAMEOPTIONCODE = isnull(EFT.COMPANYNAMEOPTIONCODE, 0)
        ,@COMPANYNAME = EFT.COMPANYNAME
        ,@COMPANYIDPREFIX = EFT.COMPANYIDPREFIX
        ,@COMPANYID = EFT.COMPANYID
        ,@CREATEOFFSETTINGTRANSACTIONS = EFT.CREATEOFFSETTINGTRANSACTIONS
        ,@INCLUDECARRIAGERETURN = isnull(EFT.INCLUDECARRIAGERETURN, 1)
        ,@ROUTINGNUMBER = BA.ROUTINGNUMBER
    from dbo.BANKACCOUNT BA
    left join dbo.BANKACCOUNTEFTINFO EFT on BA.ID = EFT.ID
    where BA.ID = @ID;

    select @ORGNAME = O.NAME
        ,@ORGEIN = O.EIN
    from dbo.ORGANIZATIONINFORMATION O;

    return 0;