Are you familiar with the story of transaction enrichment in the system? Have you dealt with it?

Enrichment of deals in the system is the process of adding additional information to the basic deal data to increase their value and facilitate further processing. For example, data about the counterparty, currency exchange rates, taxes, statuses, etc., can be added to a deal.

In my practice, deal enrichment was usually implemented as a stage of the ETL process or within business logic, where data from other systems or directories was pulled based on deal identifiers, and an extended deal object was formed.

For example, when loading a deal from an external system, we could add fields with the current exchange rate on the deal date, which allowed for accurate calculation of financial indicators.

This approach helps to standardize data and makes analysis and reporting easier.