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
| 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 |