ConsolidatedExchangeRate
Provides consolidated exchange rates for financial reporting, supporting period-based currency conversion in NetSuite.
Columns
| Name | Type | Description |
| Period_InternalId | String | The internal identifier for the financial period associated with this exchange rate, ensuring accurate consolidation of financial data. |
| FromSubsidiary_InternalId | String | The internal identifier of the subsidiary from which the exchange rate originates, representing the source entity in financial consolidation. |
| ToSubsidiary_InternalId | String | The internal identifier of the subsidiary to which the exchange rate applies, ensuring proper currency conversion in multi-entity financial reports. |
| CurrentRate | Double | The most recent exchange rate applied between the subsidiaries for financial consolidation, based on real-time or latest transactions. |
| AverageRate | Double | The calculated average exchange rate over the specified financial period, used for smoothing currency fluctuations in reports. |
| HistoricalRate | Double | The historical exchange rate recorded for the given period, providing a reference point for financial analysis and comparison. |
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 | The internal identifier for the parent record, allowing relational queries to track consolidation structures and dependencies. |
| PeriodName | String | The name of the financial period associated with this exchange rate, such as 'Q1 2024' or 'January 2025,' ensuring clarity in reporting. |