Previous Next JavaScript must be enabled to correctly display this content

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

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

Parent topic: File Upload