Having this data accessible in one location will reduce the cost of query resolution and enable actions like refunds to happen in an automated fashion.

For this to be effective, the data model must be extensive i.e. if the currency has been converted or the transaction rejected because of a fraud rule, all this information must be available in one single source, with the ability to search, find and report using meaningful references – e.g. order references.

Once your data model is right not only will the reporting be better but also your ability to automate fraud rules will be enhanced as the more information you collect and have, the better your fraud rules will become.