consolidatedexchangerate
Stores consolidated exchange rate information for multiple currencies, helping facilitate global financial reporting.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for the record. | |
| accountingbook | String | The accounting book associated with the transaction or record. | |
| averagerate | Decimal | The average exchange rate used during the specified period. | |
| currentrate | Decimal | The current exchange rate for currency conversion. | |
| externalid | String | A unique external identifier for referencing the record in external systems. | |
| fromcurrency | String | The source currency for the transaction or exchange. | |
| fromsubsidiary | String | The subsidiary from which the transaction or exchange originates. | |
| historicalrate | Decimal | The historical exchange rate used for past transactions or comparisons. | |
| postingperiod | String | The accounting period during which the transaction or exchange is recorded. | |
| tocurrency | String | The target currency for the conversion or exchange. |