# DW_NS_consolidatedExchangeRate_G

This table contains consolidated exchange rates which translates between the base currency of a subsidiary and the base currency of its parent or grandparent subsidiary, for a specified accounting period. Consolidated exchange rates include three different rate types per period and subsidiary pair: Current, Average, and Historical.

## Details

Module:

## Key Columns

id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
id | NUMBER | 38 | 0 | True |  |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. |  |
accountingbook | NUMBER | 38 | 0 |  |  |  |
averagerate | NUMBER |  |  |  |  |  |
currentrate | NUMBER |  |  |  |  |  |
externalid | VARCHAR2 | 512 |  |  |  |  |
fromcurrency | NUMBER | 38 | 0 |  |  |  |
fromsubsidiary | NUMBER | 38 | 0 |  |  |  |
historicalrate | NUMBER |  |  |  |  |  |
postingperiod | NUMBER | 38 | 0 |  |  |  |
tocurrency | NUMBER | 38 | 0 |  |  |  |
tosubsidiary | NUMBER | 38 | 0 |  |  |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.