Defining SCV Currency Conversion

To define Currency Conversion:

  1. Select Configuration > SCV > Currency Conversions. The list of Currency Conversions that are already defined is displayed.
  2. Click New.
  3. Click the Details tab.
  4. Specify this information:
    Name
    A unique name of the Currency Conversion.
    Description
    The description of the Currency Conversion.
    Note: You can modify this field if the System option is disabled.
    Table
    The data table name that contains the values in columns for conversion. You can select the table name from the SCV Tables list.
    Note: You can modify this field if System option is disabled.
    Enabled
    Indicates the status of the Currency Conversion. Possible values:
    • By default, the field is set to On.
    • The Active Currency Conversion definitions are only used by the Transform Currency Conversion program.
    System
    Indicates if the currency conversion definition is standard or user defined.
    Note: This option is enabled for the standard currency conversion.
  5. Click the Currency Column tab.
  6. Click '+' to add a Currency Column.
  7. Specify this information in the Details tab:
    Converted Column
    The name of the column that stores the converted amount in common currency.
    Note: 
    • This field contains the list of existing columns in the specified table.
    • You can modify this field if the System option is disabled.
    Original Column
    The name of the column that stores the amount in original currency.
  8. Specify this information in the Currency ID/ From Currency/ To Currency tab:
    Type
    The type of the Currency ID. Possible values:
    • Constant
    • Parameter
    • Column
    • Expression
    • Accounting Entity Column
    Note: You can modify this value if the System option is disabled.
    Table Level
    The level used to classify the data in the specified table. Possible values:
    • CURRENT
    • PARENT: This option is displayed only if the parent reference is set to ‘YES’ in SCV for the selected Table.
    Note: 
    • You can modify this field only if the System option is disabled.
    • This field is enabled only if the Type field is set as Column, Expression or Accounting Entity Column.
    Value
    The value of this field is based on the Type specified. Possible scenarios:
    • Constant: A constant textual value. For Currency Date, YYYYMMDD or YYYYMMDD HH:MI:SS format used.
    • Parameter: A valid SCV Configuration parameter name.
    • Column: The column in the current table or parent table. This value is based on the Table Level specified.
    • Accounting Entity Column: The name of the column in the current table or parent table that stores the accounting entity ID. This value is based on the Table Level specified.
    • Expression: A valid SQL expression specified in the current table or parent table that provides the required value. You must verify the specified expression using the Verify option.
    • Keyword: Possible options are CURRENT_DATE and CURRENT TIME.
      Note: You can modify this field only if the System option is disabled.
  9. Click Update. A new row is added to the Currency Column table.
  10. Click Add and repeat the steps 5, 6, 7 & 8 to add rows to the Currency Column table.
  11. Click Submit. The Currency Conversion data is updated after successful validation of the specified information.
    Note: You can use the Currency Conversions page to:
    • Create a duplicate of the existing Currency Conversion and modify the parameters as required using the Duplicate option.
    • Delete Currency Conversion using the Delete option.