6.4 Currency Definition File Upload

This topics describes the information to perform Currency Definition maintenance in common core.

File Type Supported - CSV

File Naming Convention - CmcCurrencyMaint_<UniqueName>.csv

Note:

Replace the <UniqueName> for each file upload.

Note:

The fields marked as Required are mandatory.

Table 6-6 Currency Definition 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	Currency Code*	String	3	Denotes Currency Code
4	Currency Name*	String	105	Name of the currency
5	Country*	String	3	Currency Country
6	Currency Decimals*	Number	1	Currency Decimals
7	Currency Round Rule*	String	1	Denotes Currency Round Rule
8	Currency Round Unit*	Number	7	Denotes Currency Round Unit
9	Currency Format Mask	String	1	Denotes Currency Format Mask
10	Currency Spot Days*	Number	3	Number of spot working days applicable for the currency
11	Currency Int Method*	Number	1	Currency Interest Method
12	Position Gl	String	9	Position GL
13	Position Eqvgl	String	9	Position Equivalent GL
14	Currency Eur Type*	String	1	Currency Euro Type
15	Currency Tol Limit	Number	7	Currency Tolerance Limit
16	Settlement Msg Days*	Number	3	Settlement Message Days
17	Index Flag*	String	1	Derives index rate of the currency
18	Index Base Currency	String	3	Index Base Currency
19	Cut Off Hr*	Number	2	Hour of the day for the cut off
20	Cut Off Min*	Number	2	Minute of the hour for the cut of
21	Alt Currency Code*	String	10	Code of the alternate currency
22	Eur Conversion Reqd*	String	1	Euro Conversion Required
23	Cut Off Days*	Number	2	Cut Off Days for the payment transaction involving the currency
24	Cr Auto Ex Rate Lmt	Number	22	Credit Auto Exchange Rate Limit
25	Dr Auto Ex Rate Lmt	Number	22	Debit Auto Exchange Rate Limit
26	Currency Type	String	3	Denotes Currency Type
27	Gen 103p*	String	1	Generate outgoing MT 103 messages in the MT 103 + format
28	Cls Currency*	String	1	CLS Currency
29	Fx Netting Days*	Number	3	Foreign Exchange Netting Days
30	Iso Num Currency Code	String	3	International Standardization Organization numerical currency code
31	Gen Cust Cov*	String	1	New Cover Message Format Required
32	Validate 50f*	String	1	Validate Tag-50F
33	Maintenance Country*	String	3	Maintenance Country
34	Commodity Code*	String	1	Denotes Commodity Code

Table 6-7 Currency Definition File Upload – Child Records

Sequence	Field name	Type	Size	Description
1	Discriminator*	String	1	Denotes child record type. Default value is always “C”
2	Maintenance Country*	String	3	Maintenance Country
3	Country Code*	String	3	Denotes Country Code
4	Country Desc*	String	105	Name of the Country
5	Currency Code*	String	3	Denotes Currency Code