SQL-081: clsEFTAuthorization update
Updates a payment authorization record in PAYMENT_AUTHORIZATION identified by PAYMENT_AUTHORIZATION_SEQ_NUM.
Classification
Field
Value
SQL ID SQL-081
Operation type Update
Execution method Inline SQL
Database Oracle*
Schema [unqualified]**
Command type Text
Business object clsEFTAuthorization
Criteria property UpdateSQL
Lifecycle method BeforeUpdate / AfterUpdate
Parameters
Parameter
Direction
Type
Max length
Description
:AuthorizationTypeCode
Input
String
5
Binds AuthorizationTypeCode*
:EnrollRequestSeqNum
Input
Decimal
—
Binds EnrollRequestSeqNum*
:AuthDate
Input
Date
—
Binds AuthDate*
:BankAccountSeqNum
Input
Decimal
—
Binds BankAccountSeqNum*
:CustomerContactEmailAddr
Input
String
100
Binds CustomerContactEmailAddr*
:CustomerContactName
Input
String
50
Binds CustomerContactName*
:CustomerContactPhoneNum
Input
String
23
Binds CustomerContactPhoneNum*
:CustomerID
Input
String
20
Binds CustomerID*
:CustomerSecondID
Input
String
20
Binds CustomerSecondID*
:CustomerTypeCode
Input
String
5
Binds CustomerTypeCode*
:CustomerEmailNotificationFlag
Input
String
1
Binds CustomerEmailNotificationFlag*
:IATFlag
Input
String
1
Binds IATFlag*
:IATCity
Input
String
35
Binds IATCity*
:IATStreetAddress
Input
String
35
Binds IATStreetAddress*
:IATStateProvince
Input
String
35
Binds IATStateProvince*
:IATPostalCode
Input
String
20
Binds IATPostalCode*
:IATCountryCode
Input
String
5
Binds IATCountryCode*
:PaymentDayOFMonthNum
Input
Decimal
—
Binds PaymentDayOFMonthNum*
:PaymentSourceSystemCode
Input
String
5
Binds PaymentSourceSystemCode*
:PrenoteFailDate
Input
Date
—
Binds PrenoteFailDate*
:PrenoteSuccessDate
Input
Date
—
Binds PrenoteSuccessDate*
:PrenoteRequiredFlag
Input
String
1
Binds PrenoteRequiredFlag*
:RevokeReasonCode
Input
String
5
Binds RevokeReasonCode*
:RevokeDate
Input
Date
—
Binds RevokeDate*
:UpdateDate
Input
Date
—
Binds UpdateDate*
:UpdateIPAddr
Input
String
30
Binds UpdateIPAddr*
:UpdateUser
Input
String
30
Binds UpdateUser*
:AutoPayConfirmationNum
Input
String
25
Binds AutoPayConfirmationNum*
:PaymentAuthorizationSeqNum
Input
Decimal
—
Binds PaymentAuthorizationSeqNum*
Tables
Sample SQL
Update PAYMENT_AUTHORIZATION
Set AUTHORIZATION_TYPE_CODE = : AuthorizationTypeCode ,
ENROLL_REQUEST_SEQ_NUM = : EnrollRequestSeqNum ,
AUTH_AGREEMENT_VERSION = : AuthAgreementVersion ,
AUTH_DATE = : AuthDate ,
BANK_ACCOUNT_SEQ_NUM = : BankAccountSeqNum ,
CUSTOMER_CONTACT_EMAIL_ADDR = : CustomerContactEmailAddr ,
CUSTOMER_CONTACT_NAME = : CustomerContactName ,
CUSTOMER_CONTACT_PHONE_NUM = : CustomerContactPhoneNum ,
CUSTOMER_ID = : CustomerID ,
Customer_Second_ID = : CustomerSecondID ,
CUSTOMER_TYPE_CODE = : CustomerTypeCode ,
EMAIL_NOTIFICATION_FLAG = : CustomerEmailNotificationFlag ,
IAT_FLAG = : IATFlag ,
IAT_CITY = : IATCity ,
IAT_STREET_ADDRESS = : IATStreetAddress ,
IAT_STATE_PROVINCE = : IATStateProvince ,
IAT_POSTAL_CODE = : IATPostalCode ,
IAT_COUNTRY_CODE = : IATCountryCode ,
PAYMENT_DAY_OF_MONTH_NUM = : PaymentDayOFMonthNum ,
PAYMENT_SOURCE_SYSTEM_CODE = : PaymentSourceSystemCode ,
PRENOTE_FAIL_DATE = : PrenoteFailDate ,
PRENOTE_REQUIRED_FLAG = : PrenoteRequiredFlag ,
PRENOTE_SUCCESS_DATE = : PrenoteSuccessDate ,
REVOKE_REASON_CODE = : RevokeReasonCode ,
REVOKE_DATE = : RevokeDate ,
UPDATE_DATE = : UpdateDate ,
UPDATE_IP_ADDR = : UpdateIPAddr ,
UPDATE_USER = : UpdateUser ,
AUTO_PAY_CONFIRMATION_NUM = : AutoPayConfirmationNum
Where PAYMENT_AUTHORIZATION . PAYMENT_AUTHORIZATION_SEQ_NUM = : PaymentAuthorizationSeqNum
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\clsEFTAuthorization.vb