Is there a sql query to determine if a loaded credit card transaction has already been entered manua
We are implementing MasterCard CDF3 Transaction loads to R12.1.3 iExpense. Up until this time, users have been entering transactions manually into their expense reports. Is there a sql query to determine if a loaded MasterCard transaction has already been entered manually on a report? We don't want to allow duplicate entries and so would want to deactivate transactions that have already been entered manually.
I have looked into using the Credit Card Historical Transactions Management program. This is used to deactivate transactions that have not been used. I am looking for a way to identify transactions that have already been used through manual entry. Is there a query or report available to show these?