Skip to content

SQL-089: clsBankAccountTransfer delete

Deletes a bank account transfer record from BANK_ACCOUNT_TRANSFER.

Classification

Field Value
SQL ID SQL-089
Operation type Delete
Execution method Inline SQL
Database Oracle*
Schema [unqualified]**
Command type Text
Business object clsBankAccountTransfer
Criteria property DeleteSQL
Lifecycle method BeforeDelete / AfterDelete

Parameters

Parameter Direction Type Max length Description
:BankAccountSeqNum\ Input Decimal — Binds \BankAccountSeqNum\
:USBankUserSeqNum\ Input Decimal — Binds \USBankUserSeqNum\

Tables

Table Access Columns used
BANK_ACCOUNT_TRANSFER Write —

Sample SQL

Delete BANK_ACCOUNT_TRANSFER
Where BANK_ACCOUNT_TRANSFER.BANK_ACCOUNT_SEQ_NUM = :BankAccountSeqNum
  AND BANK_ACCOUNT_TRANSFER.US_BANK_USER_SEQ_NUM = :USBankUserSeqNum

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.

Sources

  • Business\SAIF.Business.Payment.EFT\clsBankAccountTransfer.vb