USP_DATAFORMTEMPLATE_VIEW_BANKACCOUNTEFTINFO

The load procedure used by the view dataform template "Bank Account EFT Information View 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.
@IMMEDIATEDESTINATIONNUMBER	nvarchar(10)	INOUT	Immediate destination
@IMMEDIATEDESTINATIONNAME	nvarchar(23)	INOUT	Immediate destination name
@IMMEDIATEORIGINNUMBER	nvarchar(10)	INOUT	Immediate origin
@IMMEDIATEORIGINNAME	nvarchar(23)	INOUT	Immediate origin name
@REFERENCECODE	nvarchar(8)	INOUT	Reference code
@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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BANKACCOUNTEFTINFO
(
    @ID uniqueidentifier
    ,@DATALOADED bit = 0 output
    ,@IMMEDIATEDESTINATIONNUMBER nvarchar(10) = null output
    ,@IMMEDIATEDESTINATIONNAME nvarchar(23) = null output
    ,@IMMEDIATEORIGINNUMBER nvarchar(10) = null output
    ,@IMMEDIATEORIGINNAME nvarchar(23) = null output
    ,@REFERENCECODE nvarchar(8) = null output
    ,@COMPANYNAME nvarchar(16) = null output
    ,@COMPANYIDPREFIX tinyint = null output
    ,@COMPANYID nvarchar(9) = null output
    ,@CREATEOFFSETTINGTRANSACTIONS bit = null output
    ,@INCLUDECARRIAGERETURN bit = null output
)
as
    set nocount on;

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

    set @DATALOADED = 0;

    declare @ORGNAME nvarchar(100) = null
    declare @ORGEIN nvarchar(20) = null

    -- 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 @ORGNAME = O.NAME
        ,@ORGEIN = O.EIN
    from dbo.ORGANIZATIONINFORMATION O;

    select
        @DATALOADED = 1
        ,@IMMEDIATEDESTINATIONNUMBER = EFT.IMMEDIATEDESTINATIONNUMBER
        ,@IMMEDIATEDESTINATIONNAME = EFT.IMMEDIATEDESTINATIONNAME
        ,@IMMEDIATEORIGINNUMBER = case EFT.IMMEDIATEORIGINNUMBEROPTIONCODE when 0 then BA.ROUTINGNUMBER when 1 then LEFT(@ORGEIN, 9) else EFT.IMMEDIATEORIGINNUMBER end
        ,@IMMEDIATEORIGINNAME = case EFT.IMMEDIATEORIGINNAMEOPTIONCODE when 0 then LEFT(@ORGNAME, 23) else EFT.IMMEDIATEORIGINNAME end
        ,@REFERENCECODE = EFT.REFERENCECODE
        ,@COMPANYNAME = case EFT.COMPANYNAMEOPTIONCODE when 0 then LEFT(@ORGNAME, 16) else EFT.COMPANYNAME end
        ,@COMPANYIDPREFIX = EFT.COMPANYIDPREFIX
        ,@COMPANYID = EFT.COMPANYID
        ,@CREATEOFFSETTINGTRANSACTIONS = EFT.CREATEOFFSETTINGTRANSACTIONS
        ,@INCLUDECARRIAGERETURN = EFT.INCLUDECARRIAGERETURN
    from dbo.BANKACCOUNT BA
    left join dbo.BANKACCOUNTEFTINFO EFT on BA.ID = EFT.ID
    where BA.ID = @ID;

    return 0;