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 |
Parent topic: File Upload