Transcription
Trade file format – Equity SegmentFormat of Trade file to Clearing Member:FileEOD Provision Trade fileEOD Final Trade fileOnline Trade FileSr.No1Field NameMember ID2Trader ID3Scrip Code4Scrip Id5Rate67QtyTrade status8CM code9Trade Time101112Trade DateClient IDOrder IDNamePBR DDMMYY CM. Clearing Code BR DDMMYY CM. Clearing Code EQ ITR CM clg.no YYYYMMDD .csvTypeCSVCSVCSVDescriptionData typeMember Code of the tradingmember as assigned by BSEThis will contain BSE TradingMember ID will be received fromRTRMS.ID of the trader who has executedthe trade at BSE.Applicable only for BSE trades. Forother Exchange trades it will beblank.Numeric identifier assigned to asecurity, as available in the scripmaster file.Symbol of the security, as availablein the scrip master file.Price at which the trade has beenexecuted (Rate will be in paise)Traded quantityStatus of the trade; possible valuesare 11 Original Trade12 Modified Trade13 Cancelled Trade17 Approved Trade18 Rejected TradeNumeric (9)This field data will be received tothe CLASS from the RTRMS.Clearing member code of thetrading member executing thetrade.In case of confirmed trade ofcustodial participant (CP), this fieldwill reflect code of custodianTrade Timestamp in terms ofHH:MM:SSTrade date in YYYY/MM/DD formatUnique Client code of the clientOrder numberBSE - INTERNALNumeric (9)Numeric (9)Char (11)Numeric (10)Numeric (9)Numeric (9)Numeric (9)Char (8)Char (10)Char (11)Numeric (20)
Trade file format – Equity Segment13TransactionType/Order Type141516Buy/SellTrade IDClient Type17ISIN18Group Name19SettNo20OrdTimestamp21AO/PO Flag22Location ID23TradeModificationTime24Session IDPossible values in this field:L – Limit orderG – Market orderO– Odd-lot orderK – Block Deal orderB Buy /S SellTrade numberPossible values in this field: CLIENT INST OWN SPLCLIISIN code for the security, asavailable in the scrip master file.The Settlement group of theSecurity, as available in the scripmaster file.Group name as provided in scripmaster against scrip codeSettlement Number applicable forthe trade date, as assigned by ICCLIn nnn/yyyyyyyy formatOrder Time stamp in terms ofhh:mm:ss0 – AO (Active Orders) flag1 – PO (Passive Orders) flagApplicable only for BSE trades. Forother Exchange trades it will beblank.Location ID of the traderApplicable only for BSE trades. Forother Exchange trades it will beblank.This field will provide trademodification time. If no trademodification has been done, thisfield shall reflect the original tradetime.Session ID corresponding to thetrader ID, which is used forconnecting to BSE’s trading system.This field data will be received tothe CLASS from the RTRMS.Applicable only for BSE trades. Forother Exchange trades it will beblank.BSE - INTERNALChar (1)Char (1)Numeric (10)Char (15)Char (12)Char(2)Char (12)Char (8)Numeric (1)Numeric (16)Char (8) (hh:mm:ss)Numeric (10)
Trade file format – Equity Segment25CP code26CP codeconfirmation(Y/N)Custodial Participant code of clientsettling through custodian(This field data will be received tothe CLASS from the RTRMS)Value “Y” or “N” indicating tradeconfirmed / not confirmed bycustodianChar (15)Char (1)(This field data will be receivedto the CLASS from the RTRMS)27Old CustodialParticipantIn case of a change in CustodialParticipant (CP) code, this field willcontain the old CP CodeChar (15)(This field data will be receivedto the CLASS from the RTRMS)28Old CustodialCodeIn case of a change in CustodialParticipant (CP) code, this field willcontain the old custodian code.Numeric (9)(This field data will be receivedto the CLASS from the RTRMS).2930Exchange FlagScrip id/SymbolThis will contain identifier of theExchange where trade is executedby trading member. Possible values- BSE, NSE, MSEI(This identifier shall be providedfield data will be received to theCLASS from the RTRMS.)This will contain Symbol of thesecurity as defined by the Exchangewhere the trade is executed.Char (7)Char (11)(1. For BSE trade scrip ID/ symbol tobe taken from scrip master file)31Series(2. For NSE & MSEI trade based ontoken number received in trade andusing mapping file CALSS to find outsymbol in respective Exchange)This will contain series identifier asdefined by the Exchange where thetrade is executed.e.g. EQ, BE, etc(1. For BSE trade this will be blank)(2. For NSE & MSEI trade based ontoken number received in trade andBSE - INTERNALChar (2)
Trade file format – Equity Segment32TM code of otherExchangeusing mapping file CALSS to find outseries in respective Exchange)Code of the trading member asassigned by the Exchange wherethe trade is executed.Varchar (9)(CLASS to find this informationusing MM file which shall beprovided for Interop)Format of Trade file to Trading Member:FileProvision Trade fileFinal Trade fileOnline Trade file for TMNamePBR DDMMYY . xxx (where xxx Member Code)BR DDMMYY . xxx (where xxx Member Code)EQ ITR xxx YYYYMMDD .csv (where xxx Member Code)TypePipe separated ( )Pipe separated ( )CSVSr.No12345Field NameDescriptionData typeMember IDTrader IDScrip CodeScrip IdRateMember idTrader IdScrip CodeScrip IDRate67QtyTrade status8CM code910111213TimeDateClient IDOrder IDTrn Typ/OrderType14Buy/SellQuantity11- Original trade12- Modified trade13 Cancelled Trade17 Approved Trade18 Rejected TradeClearing member code of thetrading member executing thetrade.In case of confirmed trade ofcustodial participant (CP), this fieldwill reflect code of custodianTrade TimeTrade dateClient IdOrder IDPossible values in this field:L – Limit OrderG – Market OrderO– Oddlot orderK – Block DealsB Buy /S 10)- (rate will be inpaise)Numeric(9)Numeric(9)BSE - INTERNALNumeric(9)Char(8) (hh:mm:ss)Char(10) (yyyy/mm/dd)Char(11)Numeric(20)Char(1)Char(1)
Trade file format – Equity Segment1516Trade IDClient Type28Old CustodialCode293031FillerFillerFillerTrade IDPossible values in this field: CLIENT INST OWN SPLCLIISIN code for the securityGroup under which the scrip istradedSettlement NumberOrder Time stamp0 – AO (Active Orders) flag1 – PO (Passive Orders) flagLocation Id of the traderThis field will provide trademodification time. If no trademodification has been done, thisfield shall reflect the original tradetime.Session ID corresponding to thetrader ID, which is used forconnecting to BSE’s trading system.Custodial Participant code of clientsettling through custodianValue “Y” or “N” indicating tradeconfirmed / not confirmed bycustodianIn case of a change in CustodialParticipant (CP) code, this field willcontain the old CP CodeIn case of a change in CustodialParticipant (CP) code, this field willcontain the old custodian code.Default value as 0Default value as 0Default value as 01718ISINScrip Group192021SettNoOrdTimestampAO/PO Flag2223LocationIdTrademodification Time24Session ID25CP code26CP codeconfirmation(Y/N)Old CustodialParticipant32FillerDefault value as 027BSE - INTERNALNumeric(10)Char(15)Varchar (9)Char(12)Char(2)Char(12) (nnn/yyyyyyyy)Char(8) (hh:mm:ss)Numeric(1)Numeric(16)Char (8) (hh:mm:ss)Numeric (10)Char (15)Char (1)Char (15)Numeric (9)Char (7)Char (11)Char (2)
7 Trade status Status of the trade; possible values are - 11 Original Trade 12 Modified Trade 13 Cancelled Trade 17 Approved Trade 18 Rejected Trade This field data will be received to the CLASS from the RTRMS. Numeric (9) 8 CM code Clearing member code of the trading member executing the trade. In case of confirmed trade of
