The file shall be in CSV format.
Naming convention:
CLNTEPF_N_XXXXXXX_YYYYMMDD.Ynn
where,
N - Settlement type (Should be N for normal segment and W for trade for trade segment)
XXXXXXX - Settlement number (e.g “2010001”)
YYYYMMDD - Date in YYYYMMDD format
Y - The file indicator (T in this case for upload)
nn - The batch number of file to be uploaded.
Control Record
| Sr. No. |
Field |
Length |
Mandatory/
Option |
Description |
| 1 |
Record Type |
Char (2) |
Mandatory |
Value = 01 |
| 2 |
File Type |
Char(7) |
Mandatory |
Value = CLNTEPF |
| 3 |
Member Code |
Char (5) |
Mandatory |
Member code for which file generated/received |
| 4 |
Batch Date |
Char (8) |
Mandatory |
Format : YYYYMMDD
Should be same as that in the file name. |
| 5 |
Batch Number |
Numeric (2) |
Mandatory |
The batch number of the file sent. |
| 6 |
Settlement Type |
Char (1) |
Mandatory |
Settlement type for which EPI is made. Should be N for normal segment and W for trade for trade segment |
| 7 |
Settlement No. |
Char(7) |
Mandatory |
Settlement number (e.g “2010001”) |
| 8 |
Number of Records |
Number (7) |
Mandatory |
Total number of records in the file |
| 9 |
Total value of EPI |
Number (15,2) |
Mandatory |
Total amount of early pay-in across all clients |
| Sr. No. |
Field |
Length |
Mandatory/
Option |
Description |
| 1 |
Record Type |
Char (2) |
Mandatory |
Value = 20 |
| 2 |
Client Code |
Char(12) |
Mandatory |
|
| 3 |
Amount of funds early pay-in (in Rs.) |
Number (15,2) |
Mandatory |
|
| 4 |
Symbol |
CHAR(10) |
Optional |
|
| 5 |
Series |
CHAR(2) |
Optional (Series is Mandatory where Symbol is specified) |
|
In case the file uploaded by the member gets rejected, then the file extension ‘Tnn’ will get replaced with ‘Rnn’ and the return file will be available under menu ‘Funds EPI -File upload- Files failed in processing’ in ‘Collateral Interface for Members (CIM).The control record in the file will have R appended.
The naming convention for return files will be:
<XXXXX>_CLNTEPF_N_XXXXXXXX_YYYYMMDD.Rnn
In case the file is accepted (success) then the file extension ‘Tnn’ will get replaced with ‘Snn’ and the return file will be available under menu ‘Funds EPI -File upload –Files successfully processed’ in ‘Collateral Interface for Members (CIM).
The return file with extension ‘Snn’ will have S appended for successful records and R appended for rejected records.
The naming convention for return files will be:
<XXXXX>_CLNTEPF_ N_XXXXXXXX_YYYYMMDD.Snn
Note :-
-
File upload facility and the screen based allocation is a request for allocation only and a separate Funds EPI request has to be put for Bank confirmation for availing margin benefit If member wants to change the EPI once allocated to a client a screen based modify request can be given or a revised file may be uploaded. If member wants to remove the EPI benefit given earlier to a client, a record needs to be sent in the subsequent file with the revised amount as zero or the record can be deleted through the screen.
-
Where the member has to provide EPI for his proprietary position, he has to specify client code as his member code.
-
Specific client level EPI should be given only for all open settlements
-
Members are requested to verify the successful uploading of the file from the return file.