Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Batch Files for Import of ISO Codes for Country and Currency Codes

The directory FXCDE-LKZ_ISO-Codes contains data for the definition of country codes (ISO 3166) and currency codes (ISO 4217).

These data are provided in the Excel file WKZ_LKZ.xlsm with references for IDL.XLSLINK. The data are splitted into two sheets of the Excel file WKZ_LKZ.xlsm:

  • FXCDE - currency code
  • CNTCDE - country code

The first sheet of the file is titled "General" and contains some central specifications on which the formulae of the following sheets refer. These are:

  • the name of the database (default name is "IDLDB")
  • the keys of the languages of descriptions (for the time being only German)
  • a unique valid-from period for all master data (default is "12.2012")

Please replace the specifications for database and valid-from period by the values applying for you or desired by you, respectively. The language keys are fixed since descriptions are provided only in German for the time being.

Since only some of the delivered country codes and currency codes are required, it is suggested to select and export only the required codes. Otherwise the selection of these codes in IDL Konsis becomes unmanageable.
Published:

Batch Files for Import of ISO Codes for Country and Currency Codes

The directory FXCDE-LKZ_ISO-Codes contains data for the definition of country codes (ISO 3166) and currency codes (ISO 4217).

These data are provided in the Excel file WKZ_LKZ.xlsm with references for IDL.XLSLINK. The data are splitted into two sheets of the Excel file WKZ_LKZ.xlsm:

  • FXCDE - currency code
  • CNTCDE - country code

The first sheet of the file is titled "General" and contains some central specifications on which the formulae of the following sheets refer. These are:

  • the name of the database (default name is "IDLDB")
  • the keys of the languages of descriptions (for the time being only German)
  • a unique valid-from period for all master data (default is "12.2012")

Please replace the specifications for database and valid-from period by the values applying for you or desired by you, respectively. The language keys are fixed since descriptions are provided only in German for the time being.

Since only some of the delivered country codes and currency codes are required, it is suggested to select and export only the required codes. Otherwise the selection of these codes in IDL Konsis becomes unmanageable.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk