/**
     * Checks, if a representation of the given bank transaction has already been stored to the database.
     * 
     * Identifiying criteria could be a combination of:
     * 
     * - entry date
     * - value date
     * - amount
     * - debit credit mark
     * - business transaction type code / bank transaction type
     * - information to account owner 
     * - remittance information
     * 
     * @param transaction a given bank transaction, representated by a <code>CAMT054Transaction</code> object
     * 
     * @return true, if a representation of the given bank transaction has already been stored to the database
     * 
     * @throws BusinessException might be thrown in case of errors or other exceptions
     */
    public boolean doesBankTransactionAlreadyExist(CAMT054Transaction transaction) throws BusinessException
    {
        Query<BankTransaction> qryGetExistingBankTransactions = QueryProvider.create(BankTransaction.class);          
        final CreditDebitIndicator boCreditDebitIndicator = creditDebitIndicatorFacade.getCreditDebitIndicator(transaction.getCreditDebitIndicator().getCode());
        final EntryStatus boEntryStatus = entryStatusFacade.getEntryStatus(transaction.getEntryStatus().getCode());
        final AbstractCurrencyWrapper currencyWrapper = currencyFacade.getCurrencyByIso4217Code(transaction.getCurrencyCode());
        BankTransactionType bankTransactionType = null;
        
        if (transaction.getBankTransactionTypeCode() != null) {
            bankTransactionType = bankTransactionTypeFacade.getBankTransactionType(transaction.getBankTransactionTypeCode(),
                transaction.getBankTransactionTypeTxtComplement(),
                transaction.getSwiftTransactionCode());
        }
        
        if (bankTransactionType != null && bankTransactionType.getId() != null) {
            qryGetExistingBankTransactions.where(BankTransaction.MessageId.eq(transaction.getMessageId()))
                .and(BankTransaction.MessageDate.eq(transaction.getMessageDate()))
                .and(BankTransaction.MessageRecipient.eq(transaction.getMessageRecipient())) 
                .and(BankTransaction.NotificationId.eq(transaction.getNotificationId()))
                .and(BankTransaction.ElectronicSequenceNumber.eq(transaction.getElectronicSequenceNumber()))
                .and(BankTransaction.TransactionTypeId.eq(bankTransactionType.getId()))
                .and(BankTransaction.EntryStatusId.eq(boEntryStatus.getId()))
                .and(BankTransaction.Initiator.eq(transaction.getInitiator()))
                .and(BankTransaction.FinancialInstitution.eq(transaction.getFinancialInstitution()))
                .and(BankTransaction.Iban.eq(transaction.getIban()))
                .and(BankTransaction.Bic.eq(transaction.getBic()))
                .and(BankTransaction.Amount.eq(transaction.getAmount()))
                .and(BankTransaction.CurrencyId.eq(currencyWrapper.getId()))
                .and(BankTransaction.CreditDebitIndId.eq(boCreditDebitIndicator.getId()))
                .and(BankTransaction.BookingDate.eq(transaction.getBookingDate()))
                .and(BankTransaction.ValueDate.eq(transaction.getValueDate()))
                .and(BankTransaction.EndToEndId.eq(transaction.getEndToEndId()))
                .and(BankTransaction.AccountServiceReference.eq(transaction.getAccountServiceReference()))
                .and(BankTransaction.NameCounterparty.eq(transaction.getNameCounterparty()))
                .and(BankTransaction.IbanCounterparty.eq(transaction.getIbanCounterparty()))
                .and(BankTransaction.BicCounterparty.eq(transaction.getBicCounterparty()))
                .and(BankTransaction.RemittanceInformation.eq(transaction.getRemittanceInformation()));
        } else {        
            qryGetExistingBankTransactions.where(BankTransaction.MessageId.eq(transaction.getMessageId()))
                .and(BankTransaction.MessageDate.eq(transaction.getMessageDate()))
                .and(BankTransaction.MessageRecipient.eq(transaction.getMessageRecipient())) 
                .and(BankTransaction.NotificationId.eq(transaction.getNotificationId()))
                .and(BankTransaction.ElectronicSequenceNumber.eq(transaction.getElectronicSequenceNumber()))
                .and(BankTransaction.EntryStatusId.eq(boEntryStatus.getId()))
                .and(BankTransaction.Initiator.eq(transaction.getInitiator()))
                .and(BankTransaction.FinancialInstitution.eq(transaction.getFinancialInstitution()))
                .and(BankTransaction.Iban.eq(transaction.getIban()))
                .and(BankTransaction.Bic.eq(transaction.getBic()))
                .and(BankTransaction.Amount.eq(transaction.getAmount()))
                .and(BankTransaction.CurrencyId.eq(currencyWrapper.getId()))
                .and(BankTransaction.CreditDebitIndId.eq(boCreditDebitIndicator.getId()))
                .and(BankTransaction.BookingDate.eq(transaction.getBookingDate()))
                .and(BankTransaction.ValueDate.eq(transaction.getValueDate()))
                .and(BankTransaction.EndToEndId.eq(transaction.getEndToEndId()))
                .and(BankTransaction.AccountServiceReference.eq(transaction.getAccountServiceReference()))
                .and(BankTransaction.NameCounterparty.eq(transaction.getNameCounterparty()))
                .and(BankTransaction.IbanCounterparty.eq(transaction.getIbanCounterparty()))
                .and(BankTransaction.BicCounterparty.eq(transaction.getBicCounterparty()))
                .and(BankTransaction.RemittanceInformation.eq(transaction.getRemittanceInformation()));
        }
                                                                                                                       
        final List<BankTransaction> lstBankTransactions = QueryProvider.execute(qryGetExistingBankTransactions);               
        
        return (lstBankTransactions != null && lstBankTransactions.size() > 0);        
    }