SQL-085: clsPaymentDetail update

Updates a payment detail record in PAYMENT_DETAIL.

Classification

Field	Value
SQL ID	SQL-085
Operation type	Update
Execution method	Inline SQL
Database	Oracle*
Schema	[unqualified]**
Command type	Text
Business object	clsPaymentDetail
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate / AfterUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:ConfirmationCheckNum	Input	String	25	Binds ConfirmationCheckNum*
:CreditDebitCode	Input	String	5	Binds CreditDebitCode*
:CurrentPaymentEventCode	Input	String	5	Binds CurrentPaymentEventCode*
:NsfCount	Input	Decimal	—	Binds NsfCount*
:OnlinePaymentTypeCode	Input	String	5	Binds OnlinePaymentTypeCode*
:PaymentAmt	Input	Decimal	—	Binds PaymentAmt*
:PaymentAuthorizationSeqNum	Input	Decimal	—	Binds PaymentAuthorizationSeqNum*
:PaymentDate	Input	Date	—	Binds PaymentDate*
:PaymentDetailSeqNum	Input	Decimal	—	Binds PaymentDetailSeqNum
:PrenoteFlag	Input	String	1	Binds PrenoteFlag*
:AchStdEntryClassCode	Input	String	5	Binds m_AchStdEntryClassCode*
:AchAddendumText	Input	String	80	Binds m_AchAddendumText*
:PaymentVendorXMLText	Input	String	4000	Binds m_PaymentVendorXMLText*
:ResubmitDate	Input	Date	—	Binds m_ResubmitDate*
:UpdateDate	Input	Date	—	Binds m_UpdateDate*
:UpdateUser	Input	String	30	Binds m_UpdateUser*
:CreateDate	Input	Date	—	Binds CreateDate*
:CreateUser	Input	String	30	Binds CreateUser*

Tables

Table	Access	Columns used
PAYMENT_DETAIL	Write	—

Sample SQL

Update PAYMENT_DETAIL
Set ACH_STD_ENTRY_CLASS_CODE = :AchStdEntryClassCode,
  ACH_ADDENDUM_TEXT = :AchAddendumText,
  CONFIRMATION_CHECK_NUM = :ConfirmationCheckNum,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  CREDIT_DEBIT_CODE = :CreditDebitCode,
  CURRENT_PAYMENT_EVENT_CODE = :CurrentPaymentEventCode,
  NSF_COUNT = :NsfCount,
  ONLINE_PAYMENT_TYPE_CODE = :OnlinePaymentTypeCode,
  PAYMENT_AMT = :PaymentAmt,
  PAYMENT_AUTHORIZATION_SEQ_NUM = :PaymentAuthorizationSeqNum,
  PAYMENT_DATE = :PaymentDate,
  PAYMENT_DETAIL_SEQ_NUM = :PaymentDetailSeqNum,
  PAYMENT_VENDOR_XML_TEXT = :PaymentVendorXMLText,
  PRENOTE_FLAG = :PrenoteFlag,
  RESUBMIT_DATE = :ResubmitDate,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser
Where PAYMENT_DETAIL.PAYMENT_DETAIL_SEQ_NUM = :PaymentDetailSeqNum

Operations and processes

• Payment detail and allocation*

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-05: Insert/update must affect exactly 1 row

Sources

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