minor unit calculations for amounts in stripe__main_transactions

[bhavikvadhia]

In the model - tripe__main_transactions.sql , the amount values are divided by 100 to get correct amount which is not at paise level.

However, some currencies like JPY - do not have any minor currency unit, and hence the amount value should be as is while reporting rather than diving by 100.

currency codes and minor units

Possible solution:
We can use this csv as a seed file to our project and can use currency literal value from stripe data and join it with this file to get how much decimals should we use for dividing in order to get to a major currency level.

[bhavikvadhia]

actual csv containing currency related details