USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNT

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ACCOUNTNAME	nvarchar(100)	IN	Account name
@ACCOUNTNUMBER	nvarchar(19)	IN	Account number
@ROUTINGNUMBER	nvarchar(9)	IN	Routing number
@ACCOUNTTYPECODE	tinyint	IN	Account type
@MINIMUMBALANCE	decimal(19, 4)	IN	Minimum balance
@DEFAULTCASHACCOUNTTYPECODE	tinyint	IN	Default cash account type
@GLACCOUNTID	uniqueidentifier	IN	Account
@PDACCOUNTSEGMENTVALUEID	uniqueidentifier	IN	Account code
@USERNUMBER	nvarchar(24)	IN	User number
@CLIENTNAME	nvarchar(100)	IN	Client name
@SORTCODE	nvarchar(6)	IN	Sort code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNT(
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @ACCOUNTNAME nvarchar(100),
                        @ACCOUNTNUMBER nvarchar(19),
                        @ROUTINGNUMBER nvarchar(9),
                        @ACCOUNTTYPECODE tinyint,
                        @MINIMUMBALANCE decimal(19, 4),
                        --@DEFAULTPRINTER nvarchar(255),

                        --@RECONCILED bit,

                        --@RECONCILEDBALANCE decimal(19,4),

                        --@LASTDEPOSITNUM integer

                        @DEFAULTCASHACCOUNTTYPECODE tinyint,
                        @GLACCOUNTID uniqueidentifier,
                        @PDACCOUNTSEGMENTVALUEID uniqueidentifier,
                        @USERNUMBER nvarchar(24),
                        @CLIENTNAME nvarchar(100),
                        @SORTCODE nvarchar(6) 
                    )
            as
                set nocount on;    

                declare @PDACCOUNTSYSTEMID uniqueidentifier ;
                declare    @UKINSTALLED  bit ; 
                declare    @SHOWACCOUNTSYSTEM bit ;            

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BANKACCOUNT
                    @ID,
                    @PDACCOUNTSYSTEMID output, 
                    @UKINSTALLED  output,
                    @SHOWACCOUNTSYSTEM output

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNT_2                
                        @ID,
                        @CHANGEAGENTID ,
                        @ACCOUNTNAME ,
                        @ACCOUNTNUMBER ,
                        @ROUTINGNUMBER ,
                        @ACCOUNTTYPECODE ,
                        @MINIMUMBALANCE ,
                        @DEFAULTCASHACCOUNTTYPECODE ,
                        @GLACCOUNTID ,
                        @PDACCOUNTSEGMENTVALUEID ,
                        @USERNUMBER ,
                        @CLIENTNAME ,
                        @SORTCODE ,
                        @PDACCOUNTSYSTEMID                 

    return 0;