1. Administering Planning
  2. Editing Dimensions in the Simplified Dimension Editor
  3. Dimension Overview
  4. About Accounts
  5. Data Type and Exchange Rate Type

Data Type and Exchange Rate Type

Data type and exchange rate type determine how values are stored in account members, and the exchange rates used to calculate values.

Available data types for account members’ values:

  • Currency: Stores and displays in the default currency.

  • Non-currency: Stores and displays as a numeric value.

  • Percentage: Stores a numeric value and displays as a percent.

  • Date: Displays as a date.

  • Text: Displays as text.

In a multiple currency application, for accounts with the Currency data type, available Exchange Rate types (valid for any time period):

  • Average: Average exchange rate

  • Ending: Ending exchange rate

  • Historical: Exchange rate in effect when, for example, earnings for a Retained Earnings account were earned or assets for a Fixed Assets account were purchased.

In a Simplified multiple currency application, for accounts with the Currency data type, available Exchange Rate types (valid for any time period):

  • FX Rates - Average

  • FX Rates - Ending