Hi Community,
I have a requirement to add a Currency Code field to a custom table. The field only needs to store the ISO 4217 alphabetic currency code, for example:
USD
EUR
GBP
LKR
I know ServiceNow has the Currency [fx_currency] table, which contains currency-related information, including currency codes. Standard currency fields also use three-letter ISO currency codes.
My question is:
Is there a standard/best-practice way to populate a custom field with the ISO 4217 currency codes available in ServiceNow?
For example, would it be better to:
Create a Choice field and manually maintain the ISO currency codes, or
Create a Reference field pointing to the Currency [fx_currency] table, or
Use another standard ServiceNow mechanism/API?
The goal is to avoid manually maintaining the complete list of ISO currency codes if ServiceNow already provides a standard way to reuse them.
Any recommendations or best practices would be appreciated.
Thanks!
