Return Files

A return file is generated for all client margin reporting files uploaded by members. No return files are generated for the following files:

• File with wrong naming convention: If the member has provided a file with naming convention different from that specified above, such files are not picked up by Clearing Corporation. This is treated as non reporting of client margin.
• ile with "0" bytes : If a file size is "0" bytes, it is not picked up for processing. This is treated as non- reporting of client margin.

In the CIM the return file can be viewed in Client margin Reporting>File download. The return file for Clearing members/ Trading members is placed in the directory FAOFTP/F<CODE>/COLAT/DNLD. The file naming convention and structure are detailed below:

Return files for Members:

In case of files uploaded through the CIM as well as the extranet, the return file is provided on the same day within an hour of file upload. In case of any errors in the file, the member can correct the same and upload on the CIM or the extranet server with incremental batch number anytime prior to Trade Date+5 days.

Two types of return files are generated for the members

• Rejected Files - where the whole file has been rejected
• Processed File Records - some or all records in the file have been rejected

Rejected Files

File Naming convention for trading members
:F_MRG_TMF_TMCODE_<DDMMYYYY>_nn.CSV

File Naming convention for clearing members
:F_MRG_CMF_CMCODE_<DDMMYYYY>_nn.CSV.

• File loaded after the sign off date - Members are allowed to load the margin reporting file up to T+5 days. Accordingly, if a member does not upload the margin reporting file till the T+5 date, the same is treated as non reporting of client margin and such files are rejected with the reason "File is not being processed as file upload date is greater than sign off date".
• File loaded for future date - If the member uploads the file for a future date, then the return file indicates the rejection reason as File is not being processed as file date is greater than system current date'. This is treated as non reporting of client margin
• Member uploads file for an invalid day - If a member is not required to report the client margin file for a day (say Saturday, Sunday, holiday etc.) and he still uploads the same, then the return file is rejected with the message File is not being processed as the member code is invalid for the file date'. This is treated as non reporting of client margin
• Member uses non-serial batch number in file name - If the batch number provided by the member for a trade date is not in sequence, for example if the member has uploaded two files for the trade date with file names F_MRG_TM_ddmmyyyy_01.CSV and F_MRG_TM_ddmmyyyy_03.CSV, the second file will be rejected with error message File is not being processed as file batch number is not proper. Last successful batch no for the day was 01'. This is treated as non reporting of client margin
• File in wrong format - If the member has provided a file which cannot be read by the system for example. a non csv file, then return file is rejected with the message File is not being processed as the file is not in format'. This is treated as non reporting of client margin

Processed File Records

File Naming Convention for trading members:
F_MRG_TMR_TMCODE_<DDMMYYYY>_nn.CSV
File Naming Convention for clearing members:
F_MRG_CMR_CMCODE_<DDMMYYYY>_nn.CSV.

After processing of client margin file, each record has a reason code indicating acceptance/ rejection, as the case may be. The details of reason codes are as follows:

Code	Message description
01	Record size does not match for e.g. extra comma in the record
02	Date in record does not match with file date
03	Record is altered i.e. matching record does not exist in MG-13 file. Possible error in date/ client code/ margin amount.
04	Record pertains to proprietary position for trading member.
05	Record pertains to proprietary position for clearing member.
06	Margin amount collected is negative or non numeric.
07	Insufficient Margin
08	Sufficient Margin

• For reason codes 1 to 6, the difference amount, represented by the difference between the margin reported and the initial margin payable, is not indicated in the return file. However for reason codes 7 and 8, the difference amount is indicated.
• If the record contains multiple errors for e.g. reason code 1 as well as 6, the reason code which is the lowest in number appears against the record i.e. reason code 1.
• If the member uploads the file in a different naming convention than as specified above, the file is not picked up by the Clearing Corporation and is treated as non-reporting of margin by the member and accordingly it invites suitable action as specified from time to time.