Operation Details
Description: Operation to search on the SuspenseAccount entity on a combination of partial match issuerName and other search criteria.
Sterotype: nsmulti
SQL 
SELECT
  suspenseAccountID,
  amount,
  receivedDate,
  effectiveDate,
  creationDate,
  datePosted,
  pmtRecInstrumentID,
  concernRoleID,
  statusCode,
  currencyTypeCode,
  currencyExchangeID,
  receiptMethodCode,
  issuerName,
  addressID,
  chequeNumber,
  ledgerNumber,
  originSortCode,
  originAccountNumber,
  originAccountName,
  destSortCode,
  destAccountNumber,
  destAccountName,
  referenceText,
  depositSlipNumber,
  receiptNumber,
  comments
INTO
  :suspenseAccountID,
  :amount,
  :receivedDate,
  :effectiveDate,
  :creationDate,
  :datePosted,
  :pmtRecInstrumentID,
  :concernRoleID,
  :statusCode,
  :currencyTypeCode,
  :currencyExchangeID,
  :receiptMethodCode,
  :issuerName,
  :addressID,
  :chequeNumber,
  :ledgerNumber,
  :originSortCode,
  :originAccountNumber,
  :originAccountName,
  :destSortCode,
  :destAccountNumber,
  :destAccountName,
  :referenceText,
  :depositSlipNumber,
  :receiptNumber,
  :comments 
FROM
  SuspenseAccount 
WHERE issuerName LIKE :issuerName 
  AND 
  (
    
    (
      amount = :amount 
      OR :amount = 0 
    ) 
    AND 
    (
      receiptMethodCode = :receiptMethodCode 
      OR :receiptMethodCode IS NULL 
    ) 
    AND 
    (
      receivedDate >= :receivedDateFrom 
      OR :receivedDateFrom IS NULL 
    ) 
    AND 
    (
      receivedDate <= :receivedDateTo 
      OR :receivedDateTo IS NULL 
    ) 
  )