SQL-077: clsBankAccount update
Updates a bank account record in BANK_ACCOUNT identified by BANK_ACCOUNT_SEQ_NUM.
Classification
Field
Value
SQL ID SQL-077
Operation type Update
Execution method Inline SQL
Database Oracle*
Schema [unqualified]**
Command type Text
Business object clsBankAccount
Criteria property UpdateSQL
Lifecycle method BeforeUpdate / AfterUpdate
Parameters
Parameter
Direction
Type
Max length
Description
:BankAccountDataSourceCode
Input
String
5
Binds BankAccountDataSourceCode
:BankAccountNickName
Input
String
50
Binds BankAccountNickName
:BankAccountNum
Input
String
255
Binds BankAccountNum
:BankAccountOwnerName
Input
String
20
Binds BankAccountOwnerName
:BankAccountStatusCode
Input
String
5
Binds BankAccountStatusCode
:BankAccountTypeCode
Input
String
5
Binds BankAccountTypeCode
:BusinessConsumerCode
Input
String
5
Binds m_BusinessConsumerCode*
:HistoricalAuthorizationFlag
Input
String
1
Binds HistoricalAuthorizationFlag
:BankAccountHolderName
Input
String
50
Binds m_BankAccountHolderName*
:BankName
Input
String
50
Binds m_BankName*
:BankRoutingNum
Input
String
255
Binds m_BankRoutingNum*
:PaymentReturnReasonCode
Input
String
5
Binds m_PaymentReturnReasonCode*
:UpdateDate
Input
Date
—
Binds m_UpdateDate / UpdateDate*
:UpdateIPAddr
Input
String
30
Binds m_UpdateIPAddr / UpdateIPAddr
:UpdateUser
Input
String
30
Binds m_UpdateUser / UpdateUser*
:BankAccountID
Input
Decimal
—
Binds BankAccountID
Tables
Sample SQL
Update BANK_ACCOUNT
Set BANK_ACCOUNT_DATA_SOURCE_CODE = : BankAccountDataSourceCode ,
BANK_ACCOUNT_HOLDER_NAME = : BankAccountHolderName ,
BANK_ACCOUNT_NICK_NAME = : BankAccountNickName ,
BANK_ACCOUNT_NUM = : BankAccountNum ,
BANK_ACCOUNT_OWNER_NAME = : BankAccountOwnerName ,
BANK_ACCOUNT_SEQ_NUM = : BankAccountID ,
BANK_ACCOUNT_STATUS_CODE = : BankAccountStatusCode ,
BANK_ACCOUNT_TYPE_CODE = : BankAccountTypeCode ,
BANK_NAME = : BankName ,
BANK_ROUTING_NUM = : BankRoutingNum ,
BUSINESS_CONSUMER_CODE = : BusinessConsumerCode ,
HISTORICAL_AUTHORIZATION_FLAG = : HistoricalAuthorizationFlag ,
PAYMENT_RETURN_REASON_CODE = : PaymentReturnReasonCode ,
UPDATE_DATE = : UpdateDate ,
UPDATE_IP_ADDR = : UpdateIPAddr ,
UPDATE_USER = : UpdateUser
Where BANK_ACCOUNT . BANK_ACCOUNT_SEQ_NUM = : BankAccountID
Operations and processes
Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.
Business rules
Sources
Business\SAIF.Business.Payment.EFT\clsBankAccount.vb