SQL-024: clsAchStandardEntryClassCode retrieve¶

Retrieves an ACH standard entry class code filtered by banking network, data source, business/consumer type, addenda count, and IAT flag.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
:BankingNetworkCode	Input	String	5	Binds `MyCriteria.BankingNetworkCode`*
:BankAccountDataSourceCode	Input	String	5	Binds `MyCriteria.BankAccountDataSourceCode`*
:BusinessConsumerCode	Input	String	5	Binds `MyCriteria.BusinessConsumerCode`*
:MaxAddendaRecordCount	Input	Decimal	—	Binds `MyCriteria.MaxAddendaRecordCount`*
:IATFlag	Input	String	1	Binds `MyCriteria.IATFlag`*

Tables¶

Table	Access	Columns used
ACH_STANDARD_ENTRY_CLASS_CODE	—	—

Sample SQL¶

Select ACH_STANDARD_ENTRY_CLASS_CODE.BANKING_NETWORK_CODE as BankingNetworkCode,
  ACH_STANDARD_ENTRY_CLASS_CODE.BANK_ACCOUNT_DATA_SOURCE_CODE as BankAccountDataSourceCode,
  ACH_STANDARD_ENTRY_CLASS_CODE.BUSINESS_CONSUMER_CODE as BusinessConsumerCode,
  decode(:IATFlag, 'N', ACH_STANDARD_ENTRY_CLASS_CODE.CODE, 'Y', 'IAT') as Code,
  decode(:IATFlag, 'N', ACH_STANDARD_ENTRY_CLASS_CODE.CODE_DESCR, 'Y', 'International ACH transaction') as CodeDescr,
  ACH_STANDARD_ENTRY_CLASS_CODE.MAX_ADDENDA_RECORD_COUNT as MaxAddendaRecordCount
From ACH_STANDARD_ENTRY_CLASS_CODE
Where ACH_STANDARD_ENTRY_CLASS_CODE.BANKING_NETWORK_CODE = :BankingNetworkCode
AND ACH_STANDARD_ENTRY_CLASS_CODE.BANK_ACCOUNT_DATA_SOURCE_CODE = :BankAccountDataSourceCode
AND ACH_STANDARD_ENTRY_CLASS_CODE.BUSINESS_CONSUMER_CODE = :BusinessConsumerCode
AND ACH_STANDARD_ENTRY_CLASS_CODE.MAX_ADDENDA_RECORD_COUNT >= :MaxAddendaRecordCount

Operations and processes¶

Output control tracking*

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