Using the Currency Rule Editor

Procedure

  1. Choose Start > Programs > IBM InfoSphere Information Server > IBM InfoSphere Information Server Pack for JD Edwards EnterpriseOne > Currency Rule Editor.
  2. The Attach to Project dialog box opens. Specify your connection details and select an IBM® InfoSphere® DataStage® project to continue. The Currency Rule Editor opens. Each row in the grid represents a currency decimal placement rule. The currency rule file can contain up to 1000 rules.
  3. To specify a rule, do the following:
    1. In the Table Name box, type the name of the table that the rule applies to.
    2. In the Currency Code Column Name box, type the name of the currency code column. Currency code columns in JD Edwards EnterpriseOne usually end in CRCD and contain currency codes such as JPY or USD. The same currency code column can be associated with more than one currency column. If NONE appears in this field, the currency code in the company table will be used at runtime.
    3. In the Currency Column Name box, type the name of the column that contains currency values. Currency values are stored in JD Edwards EnterpriseOne as whole numbers. The value of the currency code (such as JPY or USD) is used to look up the number of decimal positions to apply to the currency value. There must be a rule for each currency column in a table.
    4. Press ENTER to add the rule to the table.
  4. Repeat this process for each new rule you need to create.
  5. When you are finished, save the file and close the Currency Rule Editor.

Results

Once you have created the currency conversion rules, use the Currency Decimal Position Rules tab to select the currency rule file to apply.
Parent topic: Specifying currency decimal position rules