SQL-060: clsPaymentEvent retrieve by sequence number¶

Retrieves a single payment event with code and return reason descriptions by event sequence number.

Classification¶

Field	Value
SQL ID	SQL-060
Operation type	Read
Execution method	Inline SQL
Database	Oracle*
Schema	[unqualified]**
Command type	Text
Business object	`clsPaymentEvent`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve / AfterRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
:PaymentEventSeqNum\	Input	Decimal	—	Binds \MyCriteria.PaymentEventSeqNum*

Tables¶

Table	Access	Columns used
PAYMENT_EVENT	—	—
PAYMENT_EVENT_CODE	—	—
PAYMENT_RETURN_REASON_CODE	—	—

Sample SQL¶

Select PE.BANK_EFF_ENTRY_DATE as BankEffEntryDate,
  PE.BATCH_DATE as BatchDate,
  PE.BATCH_NUM as BatchNum,
  PE.CREATE_DATE as CreateDate,
  PE.CREATE_USER as CreateUser,
  PE.PAYMENT_DETAIL_SEQ_NUM as PaymentDetailSeqNum,
  PE.PAYMENT_EVENT_CODE as PaymentEventCode,
  PE.PAYMENT_EVENT_SEQ_NUM as PaymentEventSeqNum,
  PE.PAYMENT_RETURN_REASON_CODE as PaymentReturnReasonCode,
  PE.TRACE_NUM as TraceNum,
  PEC.CODE_DESCR as PaymentEventCodeDescr,
  PRRC.CODE_DESCR as PaymentReturnReasonCodeDescr
From PAYMENT_EVENT PE
  JOIN PAYMENT_EVENT_CODE PEC ON (PE.PAYMENT_EVENT_CODE = PEC.CODE)
  LEFT OUTER JOIN PAYMENT_RETURN_REASON_CODE PRRC ON (PE.PAYMENT_RETURN_REASON_CODE = PRRC.CODE)
Where PE.PAYMENT_EVENT_SEQ_NUM = :PaymentEventSeqNum

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.

Sources¶

Business\SAIF.Business.Payment.EFT\clsPaymentEvent.vb