6.11 Interest Rate File Upload
This topics describes the information to perform the bulk upload for the interest rate maintenance in common core.
File Type Supported - CSV, Separator | to be used
File Naming Convention - CmcIntRate<UniqueName>.csv
Note:
Replace the <UniqueName> for each file upload.Note:
The fields marked as Required are mandatory.Format specifications :
Table 6-17 Header Record
| Sequence | Field name | Type | Size | Mandatory | Description |
|---|---|---|---|---|---|
| 1 | Header | String | 6 | Yes | Hardcoded value HEADER to be used. This denotes the row as Header. Only one row to be used. |
| 2 | Product Processor | String | 7 | Yes | Hardcoded value CMNCORE to be used. |
Table 6-18 RATE Code Record
| Sequence | Field name | Type | Size | Mandatory | Description |
|---|---|---|---|---|---|
| 1 | Record Type | String | 12 | Yes | Hardcoded value RATE to be used. This denotes the row as Rate Code row Record. Only one row to be used. |
| 2 | Action/Operation Type | String | 6 | Yes | Value NEW denotes the creating a new maintenance, MODIFY denotes the modification. |
| 3 | Branch Code | String | 3 | Yes | Field to input the branch code |
| 4 | Propagate Rate to Branches | String | 1 | Yes | If this is checked then the rate code is propagated to all the other branches from head office branch. Value Y or N to be used. Y denotes the propagation is required, N denotes the propagation is not required |
| 5 | Quote Basis for Loans | Number | 1 | Yes | quote basis , Allowed value are 1 to 4, refer the field value details
|
| 6 | Rate Code | String | 10 | Yes | Denotes the rate code |
| 7 | Description | String | 120 | Yes | Denotes Rate description |
| 8 | Type | String | 8 | Yes | Denotes the Rate Code is of FIXED or FLOATING in the usage perspective. Value to be used FIXED OR FLOATING. |
Table 6-19 RATECCY Record
| Sequence | Field name | Type | Size | Mandatory | Description |
|---|---|---|---|---|---|
| 1 | Record Type | String | 12 | Yes | Hardcoded value RATECCY to be used. This denotes the row as Rate Currency row Record. Multiple rows are allowed as per different currency |
| 2 | Branch Code | String | 3 | Yes | Denotes the branch code |
| 3 | Currency Code | String | 3 | Yes | Denotes the Currency Code |
| 4 | ID NO | String | No | Internal Field to be kept blank, system will populate this field value on successful processing | |
| 5 | Rate Code | String | 10 | Yes | Denotes the rate code. The same rate code used in RATE Code Record to be used to show the linkage. |
| 6 | Rate ID | String | No | Internal Field to be kept blank, system will populate this field value on successful processing |
Table 6-20 Float Rate Master
| Sequence | Field name | Type | Size | Mandatory | Description |
|---|---|---|---|---|---|
| 1 | Record Type | String | 12 | Yes | Hardcoded value FLOATRATEMAS to be used. This denotes the row as Rate Master row Record. Multiple rows are allowed with combinations. |
| 2 | Amount Slab | Number | 22,3 | Yes | Denotes the Amount Slab |
| 3 | Borrow Lend Indicator | CHAR | 1 | Yes | Denotes Borrow Lend Indicator |
| 4 | Branch Code | String | 3 | Yes | Denotes the branch code |
| 5 | Currency Code | String | 3 | Yes | Denotes the Currency Code |
| 6 | Effective Date | DATE | 10 | Yes | Denotes the Effective Date ( format YYYY-MM-DD) |
| 7 | ID NO | String | No | Internal Field to be kept blank, system will populate this field value on successful processing | |
| 8 | Next Effective Date | String | 10 | No | Future Effective Date (format YYYY-MM-DD) |
| 9 | Previous Amount Slab | String | 22,3 | No | This value to be Zero for the first row, subsequent row should carry the amount slab of previous row |
| 10 | Rate CCY ID | String | 3 | No | Internal Field to be kept blank, system will populate this field value on successful processing |
| 11 | Rate Code | String | 10 | Yes | Denotes the rate code. The same rate code used in RATE Code Record to be used to show the linkage. |
| 12 | Rate Record Status | String | 1 | No | Optional Field , A - Active, C - Closed |
Table 6-21 Float Rate Detail
| Sequence | Field name | Type | Size | Mandatory | Description |
|---|---|---|---|---|---|
| 1 | Record Type | String | 12 | Yes | Hardcoded value FLOATRATEDET to be used. This denotes the row as Rate Details row Record. Multiple rows are allowed with combinations. |
| 2 | Amount Slab | Number | 22,3 | Yes | Denotes the Amount Slab |
| 3 | Borrow Lend Indicator | CHAR | 1 | Yes | Denotes Borrow Lend Indicator |
| 4 | Branch Code | String | 3 | Yes | Field to Input branch code |
| 5 | Currency Code | String | 3 | Yes | Denotes the Currency Code |
| 6 | Effective Date | DATE | 10 | Yes | Denotes the Effective Date (format YYYY-MM-DD) |
| 7 | ID NO | String | No | Internal Field to be kept blank, system will populate this field value on successful processing | |
| 8 | Interest Rate | Number | 13,8 | Yes | Denotes the Interest Rate |
| 9 | Pickedup Rate Code | String | No | Internal Field to be kept blank | |
| 10 | Rate Code | String | 10 | Yes | Denotes the rate code. The same rate code used in RATE Code Record to be used to show the linkage. |
| 11 | Rate Master ID | String | No | Internal Field to be kept blank, system will populate this field value on successful processing | |
| 12 | Tenor From | Number | 5 | Yes | Denotes Tenor From |
| 13 | Tenor To | Number | 5 | Yes | Denotes Tenor To |
| 14 | Units | String | 1 | Yes | Denotes Tenor Units |
For a sample Interest Rate File Upload file, refer to the following link : Interest Rate File Upload
Parent topic: File Upload