Currencies

Internal Table Name: Currencies

Use the Currencies table to set up currencies to be used in the model. You control the default currency in Model Settings > Default Units and Currency.

Coupa provides a set of benchmark Currency conversion values. If conversion rates change, you can update the USD Per Unit value to reflect the required conversions.

You cannot control values in columns in the Currencies table using Scenario Items. When the scenario is run, the currencies are evaluated prior to applying the Scenario Items.

Name

Technology: All

Table: Currencies

Internal Name: Name

Type: Short Text (100)

Enter the name for the currency definition, such as US Dollar or Japanese Yen.

Symbol

Technology: All

Table: Currencies

Internal Name: Symbol

Type: Short Text (3)

This is the symbol used to represent the currency, such as $ or ¥.

Code

Technology: All

Table: Currencies

Internal Name: Code

Type: Short Text (5)

This is the 3-character code used to identify the currency, such as USD or JPY.

Symbol Default

Technology: All

Table: Currencies

Internal Name: IsBaseCurrencyForSymbol

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

Indicate whether or not this currency is the base to be used for those currencies represented by Currency Symbol. For example, when the same Currency Symbol is associated with multiple currencies (such as $ for US Dollar, Canadian Dollar and Australian Dollar), set this value to Yes if the currency in this record is the base for the symbol.

USD Per Unit

Technology: All

Table: Currencies

Internal Name: USDPerUnit

Type: Number (Float)

Enter the ratio of the currency to the US Dollar. Coupa provides a set of benchmark Currency conversion values. If conversion rates change, you can update the USD Per Unit value to reflect the required conversions.

Last modified: Wednesday May 15, 2024

Is this useful?