Currency

Table 34. Member Properties in the Currency Dimension

Property Label

Value Description

Property Name
Alias

Member description (maximum of 80 characters)

To use the Alias property, you create an Alias dimension, define properties, and associate the Alias dimension with another dimension. For example, you can create an Alias dimension with the values English, French, and Italian and then associate the Alias dimension with the Currency dimension.

Alias

Display In ICT

Specifies if currencies display in the drop-down list in the intercompany transactions module.

Specify Y to display currencies or N to not display currencies.

DisplayInICT

Name

Name for the currency (required)

Names can contain up to 80 characters, including spaces, and cannot start with a space or contain these characters:

  • Ampersand ( & )

  • Asterisk ( * )

  • At sign ( @ )

  • Comma ( , )

  • Curly brackets ( { } )

  • Double quote ( “ )

  • Minus sign ( - )

  • Number sign ( # )

  • Period ( . )

  • Plus sign ( + )

  • Semicolon ( ; )

  • Slash mark ( / )

Name

Scale

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

A value for this property is required.

Determines how the exchange rate must be entered. Specify one of these values for this property:

  • 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

Scale

Translation Operator

Specifies the conversion calculation for intercompany transactions.

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

TranslationOperator

The system member list [Currencies] is available for the Custom1 and Custom2 dimensions. Currencies that you add to the application are added to the [Currencies] member list. The [Currencies] list enables the entry of currency translation rates for pairs of currencies and provides a way of filtering out non-currency members.