Defining Currencies

You define currencies for an application by using the attributes in Table 14.

Table 14. 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:

  • Period ( . )

  • Plus sign ( + )

  • Minus sign ( - )

  • Asterisk ( * )

  • Slash mark ( / )

  • Number sign ( # )

  • Comma ( , )

  • Semicolon ( ; )

  • At sign ( @ )

  • Double quote ( “ )

  • Curly brackets ( { } )

Description

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

DisplayInICT

Specifies if currencies display in the drop-down list in the intercompany transactions module. Specify Y to display currencies and 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.

Determines how the exchange rate must be entered. 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

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

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.