USP_BANKACCOUNT_CREATEACCOUNT

The save procedure used by the add dataform template "Bank Account Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ACCOUNTNAME	nvarchar(100)	IN	Account name
@BANKID	uniqueidentifier	IN	Bank
@ACCOUNTNUMBER	nvarchar(50)	IN	Account number
@ROUTINGNUMBER	nvarchar(9)	IN	Routing number
@STATUSCODE	tinyint	IN	Status
@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
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Currency
@BANKINGSYSTEMID	uniqueidentifier	IN
@BIC	nvarchar(11)	IN
@BANKCODE	nvarchar(25)	IN

Definition

Copy


                    CREATE procedure dbo.USP_BANKACCOUNT_CREATEACCOUNT
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @ACCOUNTNAME nvarchar(100) ='',
                        @BANKID uniqueidentifier = null,
                        @ACCOUNTNUMBER nvarchar(50) = null,
                        @ROUTINGNUMBER nvarchar(9) = null,
                        @STATUSCODE tinyint = 1,
                        @ACCOUNTTYPECODE tinyint = 1,
                        @MINIMUMBALANCE decimal(19, 4) = 0,
                        @DEFAULTCASHACCOUNTTYPECODE tinyint = 0,
                        @GLACCOUNTID uniqueidentifier = null,
                        @PDACCOUNTSEGMENTVALUEID uniqueidentifier = null,
                        @USERNUMBER nvarchar(24) = '',
                        @CLIENTNAME nvarchar(100) = '',
                        @SORTCODE nvarchar(6) = '',
                        @PDACCOUNTSYSTEMID uniqueidentifier = null,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null,
                        @BANKINGSYSTEMID uniqueidentifier = null,
                        @BIC nvarchar(11) = '',
                        @BANKCODE nvarchar(25) = ''
                    )
                    as


                    set nocount on;

                    if @ID is null
                        set @ID = newid();

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate();

                    declare @ISBANK bit;
                    set @ISBANK = dbo.UFN_CONSTITUENT_ISBANK(@BANKID);

                    if @ISBANK = 0
                        begin                                
                            exec dbo.USP_DATAFORMTEMPLATE_ADD_BANK
                                @CHANGEAGENTID = @CHANGEAGENTID,
                                @ORGANIZATIONID = @BANKID;
                        end

                    if @ROUTINGNUMBER is null
                        set @ROUTINGNUMBER = dbo.UFN_BANKACCOUNT_GETROUTINGNUMBER(@BANKID);

                    if @DEFAULTCASHACCOUNTTYPECODE = 0
                        set @PDACCOUNTSEGMENTVALUEID = null;

                    if @DEFAULTCASHACCOUNTTYPECODE = 1
                        set @GLACCOUNTID = null;

                    exec dbo.USP_GET_KEY_ACCESS;

                    begin try
                        insert into dbo.BANKACCOUNT
                            (ID
                            ,BANKID
                            ,ACCOUNTNUMBER
                            ,ROUTINGNUMBER
                            ,ACCOUNTNAME
                            ,ACCOUNTTYPECODE
                            ,STATUSCODE
                            ,MINIMUMBALANCE
                            ,DEFAULTCASHACCOUNTTYPECODE
                            ,PDACCOUNTSEGMENTVALUEID
                            ,GLACCOUNTID
                            ,USERNUMBER
                            ,CLIENTNAME
                            ,SORTCODE
                            ,ADDEDBYID
                            ,CHANGEDBYID
                            ,DATEADDED
                            ,DATECHANGED
                            ,PDACCOUNTSYSTEMID
                            ,TRANSACTIONCURRENCYID
                            ,BANKINGSYSTEMID
                            ,BIC
                            ,BANKCODE)
                        values
                            (@ID
                            ,@BANKID
                            ,EncryptByKey(key_GUID('sym_BBInfinity'), @ACCOUNTNUMBER)
                            ,@ROUTINGNUMBER
                            ,@ACCOUNTNAME
                            ,@ACCOUNTTYPECODE
                            ,@STATUSCODE
                            ,@MINIMUMBALANCE
                            ,@DEFAULTCASHACCOUNTTYPECODE
                            ,@PDACCOUNTSEGMENTVALUEID
                            ,@GLACCOUNTID
                            ,@USERNUMBER
                            ,@CLIENTNAME
                            ,@SORTCODE
                            ,@CHANGEAGENTID
                            ,@CHANGEAGENTID
                            ,@CURRENTDATE
                            ,@CURRENTDATE
                            ,@PDACCOUNTSYSTEMID
                            ,@TRANSACTIONCURRENCYID
                            ,@BANKINGSYSTEMID
                            ,@BIC
                            ,@BANKCODE
                            );
                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    exec USP_CLOSE_KEY_ACCESS;

                    return 0