NATIONAL SECURITIES CLEARING
CORPORATION LTD
Download Ref. No:
NSE/CMPT/9764
Circular. No: NSCC/F&O/C&S/760 Date: November 14, 2007
To
All Members,
Sub: Modification
in order / trade number field length
Pursuant to Circular Ref No. NSE/FAOP/9762 dated November 14, 2007, members are
requested to note that in respect of all reports including the following, where
order / trade number are used, the field length shall
stand revised from 15 digits to 16 digits.
|
Sr. No. |
Type
of report |
Nomenclature |
Changed Field size |
Field
description |
|
1. |
Trades report for trading
member |
F_TR01_<Member
code>_DDMMYYYY.CSV |
Num(16) |
Trade Number , Buy / sell Order
Number |
|
2. |
Trades report for Clearing
member |
F_TR02_<Member
code>_DDMMYYYY.CSV |
Num(16) |
Trade Number , Buy / sell Order
Number |
Further,
for upload and download of data for the purpose of give-up in NOTIS@FO using CONNECT2NSE,
members are requested to note that the order and trade number field length
shall stand revised from 15 to 16 digit and 7 to 8 digit respectively. The revised
formats are provided in Annexure 1.
Members
are requested to note that when opening .csv files in
excel, the sixteenth digit will get rounded off. Due care,
therefore, needs to be taken when reading and saving these files in excel.
Further, in case of excel macro or other tools, the data-type for handling
order / trade number should be suitably defined.
The circular
shall be effective from December 17, 2007.
Yours
faithfully,
For National Securities
Clearing Corporation Ltd.
Rana Usman
Manager
Annexure 1
1. Trade.txt File Format:
|
Field
Name |
Current
field size |
Revised
field size |
|
Trade
No |
Num(7) |
Num(8) |
|
Trade
Status |
Num(2) |
Num(2) |
|
Instrument
Type |
Char(6) |
Char(6) |
|
Symbol |
Char (10) |
Char (10) |
|
Expiry
Date |
(DDMMMYYYY) |
(DDMMMYYYY) |
|
Strike
Price |
Num (7.2) |
Num (7.2) |
|
Option
type |
Char (2) |
Char (2) |
|
Security
name |
Char (25) |
Char (25) |
|
Book Type |
Num (2) |
Num (2) |
|
Book Type
Name |
Char(3) |
Char(3) |
|
Market
Type |
Char(2) |
Char(2) |
|
User Id |
Num (5) |
Num (5) |
|
Branch No |
Num (3) |
Num (3) |
|
Buy/Sell
Indicator |
Num (1) |
Num (1) |
|
Trade Qty |
Num (9) |
Num (9) |
|
Trade
Price |
Num (7.4) |
Num (7.4) |
|
Pro/Client |
Num (1) |
Num (1) |
|
Account No |
Char (10) |
Char (10) |
|
Participant |
Char (12) |
Char (12) |
|
Open/Close
Flag |
Char (5) |
Char (5) |
|
Cover/Uncover
Flag |
Char(7) |
Char(7) |
|
Activity
time |
(DD MMM
YYYY HH:MM:SS) |
(DD MMM
YYYY HH:MM:SS) |
|
Last
Modified Time |
(DD MMM
YYYY HH:MM:SS) |
(DD MMM
YYYY HH:MM:SS) |
|
Order Number |
Num
(15) |
Num
(16) |
|
Opposite
Broker Id |
Char(5) |
Char(5) |
|
Order
Entry Date Time |
(DD MMM
YYYY HH:MM:SS) |
(DD MMM
YYYY HH:MM:SS) |
2. Giveup.txt File Format:
|
Field
Name |
Current
field size |
Revised
field size |
|
Trade
No |
Num(7) |
Num(8) |
|
Buy/Sell
Indicator |
Char(2) |
Char(2) |
|
Broker Id |
Char(6) |
Char(6) |
|
Participant |
Char (12) |
Char (12) |
|
Instrument
Type |
Char(7) |
Char(7) |
|
Symbol |
Char(10) |
Char(10) |
|
Expiry
Date |
Char(11)(DD
MMM YYYY) |
Char(11)(DD
MMM YYYY) |
|
Strike
Price |
Char(9) |
Char(9) |
|
Option
type |
Char(2) |
Char(2) |
|
Volume |
Char(9) |
Char(9) |
|
Fill
Price |
Char(9) |
Char(9) |
|
Status |
Char(2) |
Char(2) |
|
Open/Close
Flag |
Char(2) |
Char(2) |
|
Cover/Uncover
Flag |
Char(2) |
Char(2) |
|
Order
Number |
Char(15) |
Char(16) |
|
Last
Modified Date Time |
Char(20) |
Char(20) |
|
Error
Code |
Char(10) |
Char(10) |