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(5)
Rules & Considerations(18)
validation
constraint
Sample Load Data(4)
| _scenario | CREATE_IDR | CURRENCY_CODERPK | EXCHANGE_RATER | EXCHANGE_TYPERPK | EFFECTIVE_DATERPK | CREATE_DATETIME | FROM_CURRENCY_CODE |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAM | 1.0000000000 | S | 2026-01-01 | 2026-01-01 | SAM |
| default | C LIENT_INFO | ALT | 12.5000000000 | C | 2026-01-03 | 2026-01-03 | ALT |
| default | USE RENV | EDG | 14.0000000000 | C | 2026-01-05 | 2026-01-05 | EDG |
Example values from field definitions
- CREATE_IDR
- SAMPLE
- CURRENCY_CODERPK
- SAM
- EXCHANGE_RATER
- 1.0000000000
- EXCHANGE_TYPERPK
- S
- EFFECTIVE_DATERPK
- 2026-01-01
- CREATE_DATETIME
- 2026-01-01
- FROM_CURRENCY_CODE
- SAM
default
- CREATE_IDR
- C LIENT_INFO
- CURRENCY_CODERPK
- ALT
- EXCHANGE_RATER
- 12.5000000000
- EXCHANGE_TYPERPK
- C
- EFFECTIVE_DATERPK
- 2026-01-03
- CREATE_DATETIME
- 2026-01-03
- FROM_CURRENCY_CODE
- ALT
default
- CREATE_IDR
- USE RENV
- CURRENCY_CODERPK
- EDG
- EXCHANGE_RATER
- 14.0000000000
- EXCHANGE_TYPERPK
- C
- EFFECTIVE_DATERPK
- 2026-01-05
- CREATE_DATETIME
- 2026-01-05
- FROM_CURRENCY_CODE
- EDG
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 18