Format of files to be uploaded by the clearing member giving client wise details
The file shall be in CSV format.
Naming convention: CMPYYYYMMDD.Tnn
where: is the current date
and 'nn' is the batch number of the file
The files are required to be uploaded in the following path on the CIM -Home Page> Cross Margin> File upload
Control Record
| Sr. No. | Field Name | Length | Description |
|---|---|---|---|
| 1 | Record Type | Char (2) | Value is 10 |
| 2 | File Type | Char(3) | Value = CMP |
| 3 | Member Code | Char (5) | Primary Member code of the clearing member |
| 4 | Batch Date | Char (8) | Format : YYYYMMDD Should be same as that in the file name |
| 5 | Number Records | Numeric (7) | Total number of records in the file |
Detail Record
| Sr. No. | Field Name | Length | Description |
|---|---|---|---|
| 1 | Record Type | Char (2) | Value : 10 for proprietary code 20 for retail client code 30 for Custodial Participant code |
| 2 | Code | Char(12) | Value : For proprietary code it shall be PRO_TMCODE For retail client code it shall be client code allotted to the client and used during order execution For Custodial Participant code it shall be 12 digit alphanumeric code allotted by NSE Clearing for such custodial participant |
Return files:
The files uploaded by the member are processed and return files downloaded in CIM. Members can check the return files at Home Page> Cross Margin> File download
In case the file uploaded by the member gets rejected, then the file extension 'Tnn' will get replaced with 'Rnn'
The naming convention for return files will be:
<XXXXX>_CMPYYYYMMDD.Rnn
Where XXXXX shall be the Primary member code
<YYYYMMDD> is the trade date
and 'nn' is the batch number of the file.
In case the file is accepted (success) then the file extension 'Tnn' will get replaced with 'Snn' and the return file will be downloaded to the members on CIM. The return file with extension 'Snn' will have S appended for successful records and F appended for rejected records.
The naming convention for return files will be: <XXXXX>_CMPYYYYMMDD.Snn
Where XXXXX shall be the Primary member code
<YYYYMMDD> is the trade date
and 'nn' is the batch number of the file
Members are required to take note of following whilst uploading the client codes eligible for cross margining-
- Members shall upload all eligible client codes in a single file only.
- If any modification or deletion is required in the file then the member will upload new file with all records.
The latest file uploaded by the member shall be considered as final
Updated on: 18/05/2019
