ConsolidatedExchangeRate
Gets the consolidated exchange rate, by default for each month of the actual year . You can also filter the result by PeriodName (ex. WHERE PeriodName = 'Q2 2008') or by Period_InternalId (ex. WHERE Period_InternalId = '166') .
Columns
| Name | Type | Description |
| Period_InternalId | String | |
| FromSubsidiary_InternalId | String | |
| ToSubsidiary_InternalId | String | |
| CurrentRate | Double | Current actual exchange rate |
| AverageRate | Double | Average actual exchange rate |
| HistoricalRate | Double | Historical actual exchange rate |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Parent_InternalId | String | |
| PeriodName | String |