1. Administrator's Guide
  2. Managing Metadata
  3. Defining Currencies

Defining Currencies

Currencies store translated values for entities. Every application must include a Currency dimension. The Currency dimension must include a currency for each default currency assigned to an entity in the Entity dimension. Each currency added to the Currency dimension is displayed as a system-generated member in the Value dimension. You can select a currency from the Value dimension to view data values translated to the currency.

You define currencies for an application by creating a dimension with the Currency dimension type, and by using the attributes in the Currency Attributes table. You create members in the Currency dimension for each currency needed in your application.

Table 4-9 Currency Attributes

Attribute Description

Currency

Specifies the name for the currency. This attribute is required. The name must be unique and can contain up to 80 characters, including spaces.

Do not use these characters in the currency name:

  • Asterisk (*)

  • At sign (@)

  • Comma (,)

  • Curly brackets ({})

  • Double quotation marks ""

  • Minus sign (-)

  • Number sign (#)

  • Period (.)

  • Plus sign (+)

  • Semicolon (;)

  • Slash mark (/)

Description

Specifies the currency description. The description can contain up to 80 characters, including spaces.

DisplayInICT

Specifies whether currencies display in the drop-down list in the Intercompany Transactions module. Specify Y to display currencies or N to not display currencies. The default is Y.

Scale

Specifies the unit in which amounts are displayed and stored for the currency by identifying where the decimal point is placed. This attribute is required.

Also determines how the exchange rate must be entered. For example, if data is scaled to thousands, a value of 1 entered on a data form is stored as 1,000 in the database. Scale is a currency attribute, not an entity attribute. Specify one of these values for this attribute:

  • Blank = None

  • 0 = Units

  • 1 = Tens

  • 2 = Hundreds

  • 3 = Thousands

  • 4 = Ten thousands

  • 5 = Hundred thousands

  • 6 = Millions

  • 7 = Ten millions

  • 8 = Hundred millions

  • 9 = Billions

TranslationOperator

If you are using intercompany transactions, specifies whether to multiply or divide the local currency by the exchange rate. The default is blank. Specify one of these values:

  • D to calculate the local currency by dividing the transaction currency by the rate

  • M to calculate the local currency by multiplying the transaction currency by the rate

  • Blank to default the value to D

The [Currencies] system member list is available for the From Currency and To Currency dimensions. Currencies that you add to the application are added to the [Currencies] member list. The [Currencies] list enables you to enter currency translation rates for pairs of currencies and filter out non-currency members.