Previous Next JavaScript must be enabled to correctly display this content

## 4.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, which are marked with an asterisk, are mandatory.

Table 4-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 4-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