Rate

The Rate dimension contains the members used to specify the translation method for a schedule line. Currency exchange rate factors are specified for each rate member.

Property or Attribute Required Required by the Import Wizard when Adding Members Required by the Import Wizard when Updating Members Notes Default set by Import Wizard if value is missing from import file
ID Required Optional Required (if Name not provided) All applications, even single currency applications, must have at least one rate. The ID is automatically generated if not included.
Name Required Required Required (if ID not provided) The name can have up to 40 characters. Must be unique within the dimension. No default. User must supply.
Description Optional Optional Optional The description can have up to 255 characters. If not specified, defaults to the name.
Translation Type Required Optional Optional Specifies the translation method to use with this rate. These are the valid values:
  • P: Period end rate
  • Y: Year-to-date @ current month
  • N: No translation
  • H: Historical Balance Forward
No translation

This is the minimum format to add members to this dimension:

  • Name
  • Historical Rate
  • Period End Rate
  • Average Rate
  • NA