Currency Rates
In ScopeTechnical: CURRENCY_RATES | ID: OR-ITM-CURRENCY_RATES-CURRENCY_RATES
Stores the exchange rates for every currency used in the system. A currency can have multiple exchange rates based on a combination of different exchange types and effective dates.
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- CURRENCY_RATES
Field Definitions(7)
Rules & Considerations(14)
Sample Load Data(4)
| _scenario | CREATE_IDR | CURRENCY_CODERPK | EXCHANGE_RATER | EXCHANGE_TYPER | EFFECTIVE_DATER | CREATE_DATETIMER | FROM_CURRENCY_CODERPK |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAM | 1.0000000000 | S | 2026-01-01 | 2026-01-01 | SAM |
Example values from field definitions
- CREATE_IDR
- SAMPLE
- CURRENCY_CODERPK
- SAM
- EXCHANGE_RATER
- 1.0000000000
- EXCHANGE_TYPER
- S
- EFFECTIVE_DATER
- 2026-01-01
- CREATE_DATETIMER
- 2026-01-01
- FROM_CURRENCY_CODERPK
- SAM
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 14