---
title: "SQL-081: clsEFTAuthorization update"
summary: Updates a payment authorization record in PAYMENT_AUTHORIZATION identified by PAYMENT_AUTHORIZATION_SEQ_NUM.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Payment.EFT
reference_type: package
---

# 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

| Table | Access | Columns used |
| --- | --- | --- |
| [PAYMENT_AUTHORIZATION](../database-tables.md#payment_authorization) | Write | — |

## Sample SQL

```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
- [EFT authorization / consent](../operations/eft-authorization-consent.md)*

> **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
- [BR-EFT-01: EFT authorization required for payment](../business-rules.md#br-eft-01-eft-authorization-gates-electronic-payment-eligibility)
- [BR-EFT-05: Insert/update must affect exactly 1 row](../business-rules.md#br-eft-05-insertupdate-operations-require-exactly-one-affected-row)

## Sources
- `Business\SAIF.Business.Payment.EFT\clsEFTAuthorization.vb`