How to separate amount and currency from a combined balance field (example: 500.00 EUR)?

Summary:

Hello Everyone,

I’m looking for ideas and expert opinions on handling a combined amount + currency field that is displayed in the following format:

SourceSystemBalance(Functional)
500.00 EUR
-2,026.80 EUR
132,788.54 USD

Requirement

The requirement is to separate this displayed value into two columns:

Amount	Currency
500.00	EUR
-2026.80	EUR
132,788.54	USD

This separation is mainly needed for reporting / visibility / downstream consumption, not for recalculating or changing the balance itself.

Key Question

From a system or data-design perspective:

• What are the possible ways to extract or expose the amount and currency separately when they appear together in a single displayed field?
• Are there common or recommended approaches to handle this kind of scenario?