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