Back

Format of files to be uploaded by the members/custodians giving allocation details of early pay-in of funds.

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

Field Name Length Mandatory / Optional Description
Record Type Char (2) Mandatory Value = 01
File Type Char(7) Mandatory Value = CLNTEPF
Member Code Char (5) Mandatory Member code for which file generated/received
Batch Date Char (8) Mandatory Format : YYYYMMDD Should be same as that in the file name.
Batch Number Numeric (2) Mandatory The batch number of the file sent.
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
Settlement No. Char(7) Mandatory Settlement number (e.g “2010001”)
Number of Records Number (7) Mandatory Total number of records in the file
Total value of EPI Number (15,2) Mandatory Total amount of early pay-in across all clients

Detail Record

Field Name Length Mandatory / Optional Description
Record Type Char (2) Mandatory Value = 20
Client Code Char(12) Mandatory  
Amount of funds early pay-in (in Rs.) Number (15,2) Mandatory  
Symbol CHAR(10) Optional  
Series CHAR(2) Optional (Series is Mandatory where Symbol is specified)  

Return files:

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.

Related Links

Watch the market live!
Get real-time market analyses!
More about our Risk Management practices

You may also be
interested in:

Did You Know

The higher the Percent of Deliverable Quantity to Traded Quantity the better - it indicates that most buyers are expecting the price of the share to go up.

More investment concepts