SQL-006: Payment_detail_seq sequence

Generates the next PAYMENT_DETAIL_SEQ_NUM for clsPaymentDetail. This sequence value is generated before the corresponding INSERT operation to obtain the primary key.

Classification

Field	Value
SQL ID	SQL-006
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle*
Schema	[unqualified]**
Command type	Text
Business object	clsPaymentDetail
Criteria property	CreateSQL
Lifecycle method	BeforeCreate / AfterCreate

Parameters

This statement has no input parameters.

Tables

Table	Access	Columns used
DUAL	SELECT NEXTVAL	N/A

Sample SQL

SELECT Payment_detail_seq.NEXTVAL FROM DUAL

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\clsPaymentDetail.vb