Table, Description, To Currency, From Currency, Method, Historical, Beg Balance, Year, Period, Average, Ending
Table 39. Exchange Rate Dimension Properties
| Column Header in .CSV Load File | Planning Property | Value | Default | Required |
|---|---|---|---|---|
| Table | fxTblId | Name of the exchange rates table | None | Yes |
| Description | Description | Description of the exchange rates table | None | No |
| To Currency | toCur | Currency defined in the application, to which the conversion will be applied | None | Yes |
| From Currency | fromCur | Currency defined in the application, from which the conversion will be computed | None | Yes |
| Operation | N/A | update (delete operations are not supported: delete level 0, delete idescendants, delete descendants) | update | No |
| Method | method | multiply; divide | multiply | No |
| Historical | historicalRate | numeric value | 0 | No |
| Beg Balance | begBalanceRate | numeric value | 0 | No |
| Year | yearId | A year defined in the application, such as FY08 | None | Yes, if Average or Ending is specified |
| Period | tpId | A base time period defined in the application, such as Jan | None | Yes, if Average or Ending is specified |
| Average | avgVal | numeric value | None | No |
| Ending | endVal | numeric value | None | No |