Currency Code (ISO 4217 numeric) generator

The Currency Code (ISO 4217 numeric) generator creates currency codes based on the ISO 4217 standard using the numeric format. This format consists of three-digit numeric codes that represent different currencies used around the world, for example, 840 for the United States Dollar, 392 for the Japanese Yen. The generator produces realistic numeric currency code values for testing, development, or data simulation purposes, ensuring that the generated data aligns with the international currency standards and is suitable for financial systems, transactions, or analytics.

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
Currency Code Num	978, 840, 392, …	character varying character text smallint integer bigint decimal	Default

Matching rules

The generator can be assigned to a column that matches any of the following rules:

• The column name is ‘Code’, and it belongs to a table whose name is ‘Currency’.
• The column name is ‘Currency’, regardless of the table name.
• The column name starts with ‘Currency’ and ends with ‘Code’, with any or no characters in between, regardless of the table name.

Configure additional options

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

The Text box allows you to set a path to the .csv file with the list of default country codes. The default path to the file is C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\CountryCodes.csv.

Preview of the column data generated by the Currency Code (ISO 4217 numeric) generator