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