6.10 Exchange Rate File Upload
This topics describes the information to perform Exchange Rate maintenance in common core.
File Type Supported - CSV
File Naming Convention - CmcCurrencyExchangeRate_<UniqueName>.csv
Note:
Replace the <UniqueName> for each file upload.Note:
The fields marked as Required are mandatory.Table 6-15 Exchange Rate File Upload - Master Records
| Sequence | Field Name | Type | Size | Description |
|---|---|---|---|---|
| 1 | Discriminator* | String | 1 | Denotes master record type. Default value is always “P� |
| 2 | Action* | String | 10 | Denotes file operation type. Allowed values are new/modify |
| 3 | Branch Code* | String | 3 | Branch for which exchange rate is applicable |
| 4 | Currency1* | String | 3 | From currency pair |
| 5 | Currency2* | String | 3 | To currency pair |
Table 6-16 Exchange Rate File Upload - Child Records
| Sequence | Field Name | Type | Size | Description |
|---|---|---|---|---|
| 1 | Discriminator* | String | 1 | Denotes child record type. Default value is always “C� |
| 2 | Branch Code* | String | 3 | Branch for which exchange rate is applicable |
| 3 | Currency1* | String | 3 | From currency pair |
| 4 | Currency2* | String | 3 | To currency pair |
| 5 | Rate Type* | Number | 8 | Denotes rate type defined in the system |
| 6 | Mid Rate* | Number | 25 | Mid rate applicable for the current pair |
| 7 | Buy Spread* | Number | 40 | Buy spread applicable for the currency |
| 8 | Sale Spread* | Number | 40 | Sell spread applicable for the currency |
| 9 | Buy Rate* | Number | 25 | Buy rate applicable for the currency |
| 10 | Sale Rate* | Number | 25 | Sell rate applicable for the currency |
| 11 | Rate Date* | String | 35 | Effective date applicable for the rate |
Parent topic: File Upload