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