So I’ve mentioned this back as something that strikes me a bit odd and I think a correction of it could be both simple, quick and something that makes sense.
At least for me it does.
Not IETF but Requesting for Comments to this request I’ve made on the SuiteCRM-Core
repo.
opened 02:27PM - 05 Dec 23 UTC
## Context and Request
We've come across the realisation that there are curre… ntly 40 fields on the database named `_usdollar`.
I understand this makes a relation to what should be the US dollar currency, which logically for an American company would make sense as their base currency.
![Screenshot 2023-12-05 at 14 20 53](https://github.com/salesagility/SuiteCRM-Core/assets/149193091/45f3586a-d160-416c-9b36-2a68b4a316b5)
However on a global world, where I believe many current users, developers and SalesAgility itself are from Europe, but they could be from anywhere really, I don't think keeping a reference to `_usdollar` is correct.
Instead all fields and code could benefit from a simple update replacing the `_usdollar` with `_base` or `_basecur` or whatever, which is currency agnostic, and serves all purposes for what its intended. Even with `sed` it could be quickly and easily done.
Also, during an update a script could take care of the database,
```
ALTER TABLE table_name;
RENAME COLUMN oldColumn TO newColumn;
```