Global change of currency codes to standard ISO codes

• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
For reasons that made sense at the time, we used non ISO standard currency codes during our implementation. We would like to try and use the standard codes now in preparation for setting up EDI.

Is it possible to use SQL to globally change the currency code?

Resolution:
I assume that what you mean here is *just* a change to the code and that the new code represents the same currency, just a different name.

Yes, this should be possible.

The following commands:

asm copy
grep CURRENCY Z*

show that these columns are involved:

Z1007_CURRENCY,
Z41_E_CURRENCY, Z41-S-CURRENCY, Z41_PATRON_CURRENCY, Z41_COPYRIGHT_CURRENCY, Z46_CURRENCY, Z46_COPYRIGHT_CURRENCY,
Z601_CURRENCY, Z68_E_CURRENCY,
Z70_CURRENCY_1, Z70_CURRENCY_2, Z70_CURRENCY_3, Z70_CURRENCY_4,
Z76_CURRENCY, Z77_I_CURRENCY, Z82_CURRENCY_NAME, Z83_CURRENCY_NAME

All of these are in the xxx50 ADM library -- if existing in your installation. The Z41 and Z46 are present only if you are using ILL.

You probably also do not have the Z1007, but you should check.

You should be sure to back up these tables (with p_file_03) before making such a change.