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 amount = :amount
AND receiptMethodCode = :receiptMethodCode
|