Operation Details
Description: Search of the Suspense Account using receivedDateFrom >=, receivedDateTo <= and receiptMethodCode
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 receiptMethodCode = :receiptMethodCode 
  AND receivedDate >= :receivedDateFrom 
  AND receivedDate <= :receivedDateTo