All Trading Member and Custodian registered with the Exchange are hereby informed that the Exchange would make available the OFFER FOR SALE platform on iBBS (Internet Based Book Building) platform with effect from 24th February 2012 as per SEBI circular CIR/MRD/DP/ 05/2012 dated February 1, 2012
Enclosed please find detailed operational instructions and guidelines for participation in OFS segment at BSE.
The guidelines also contain the requirements at the seller or promoter(s) end to be complied with when they intend to select the Exchange as Designated Exchange for any offer of sale of their shareholding. Members and Custodians are also required to refer to the above SEBI circular for further details.
For any further clarifications, Trading Members/Custodians and intending seller i.e. promoter(s) are advised to contact following Exchange officials –
For and on behalf of BSE Limited
Girish Joshi
General Manager
Contents
1. General Instructions. 3
1.1. Offer for Sale (Segment) 3
1.2. System configuration / requirements. 3
1.3. Information on any OFS at BSE. 4
1.4. Bid time and duration. 4
2. Requirements of Seller / Promoter(s) 4
2.1. Definition of seller / promoter(s) 4
2.2. Dos and Don’ts for seller(s) / promoter(s) 4
2.3. Undertaking and documents submission. 5
3. Trading Parameters: 5
3.1. Trading Calendar and Trading Hours. 5
3.1.1. Market Timings and Trading Hours. 5
3.2. Member(s) Eligibility and Contract Note Specifications. 6
3.2.1. Member(s) Margin Requirement 6
3.2.2. Contract Note Structure. 6
3.3. OFS Bid Entry. 6
3.3.1. Bid Entry Process Flow. 6
3.3.2. Manual Bid Entry. 7
3.3.3. Bulk Upload of OFS bids. 7
3.3.4. Modification and Cancellation of OFS bids. 8
3.3.5. Download of Bid book and Allocation File. 8
3.4. Transaction Charges, Securities Transaction Tax (STT) and other levies. 8
3.5. Clearing and Settlement 8
3.5.1. Deposit of shares. 8
3.5.2. Deposit of cash collateral 8
3.5.3. Settlement Process. 9
4. EOD Files (Trade Files & Other Files) 9
5. Annexure 1. 10
5.1.1. Bulk Upload File Formats in iBBS OFS Module: 10
6. Annexure 2. 13
7. Annexure 3. 15
8. Annexure 4 (EOD Files) 17
In accordance with SEBI Circular CIR/MRD/DP/05/2012 dated February 1, 2012, the Exchange has now enabled Offer for Sale (Segment) to all Trading Members of the Exchange on iBBS (Internet Based Book Building System) of the Exchange. All Trading Members are allowed to access this module. No separate registration or payment of any charges is required currently to access the OFS segment on iBBS.
This separate window would facilitate promoters to dilute/offload their holding in listed companies in a transparent manner wider participation.
The OFS module on iBBS module can be accessed from internet. Internet explorer version IE above 6 is most preferred mode to access OFS.
The url is : https://ibbs.bseindia.com/
Trading Members can also accessed the OFS module through leasedline
https://10.1.101.254/index.aspx
One of the core requirements in OFS module is to ensure cent percent (100%) cash collateral and a bid is validated against the cash deposited. Members have to use Real Time Risk Management System (RTRMS) for cash collateral management in OFS. The url for RTRMS system is as under:
Internet Users:
http://rtrms.bseindia.com/
Leased Line Users:
http://10.1.101.99/stocks/jsp/rms/index/html
The Exchange would issue notice at least one trading day prior to any offer for sale by promoters on its website. (Refer example below). The notice would details name of the company, number of shares being offered, bid time, allocation methodology etc.
Example: If a seller wants to have offer opens say on March 2, 2012 Friday, the Exchange must issue notice on March 1, 2012 before market hours i.e. 9.00 AM. The seller / promoter(s) must submit application to the Exchange on Feb 29, 2012 end of business hours.
The duration of the OFS shall not exceed one trading day and placing of bids by Trading Members shall take place during trading hours.
i. All promoter(s)/ promoter group entities of such companies that are eligible for trading and are required to increase public shareholding to meet the minimum public shareholding requirements in terms Rule 19(2)(b) and 19A of Securities Contracts (Regulation) Rules, 1957 (SCRR), read with clause 40A (ii) (c) of Listing Agreement.
ii. All promoter(s)/ promoter group entities of top 100 companies based on average market capitalization of the last completed quarter.
For (i) and (ii) above, the promoter/promoter group entities should not have purchased and/or sold the shares of the company in the 12 weeks period prior to the offer and they Securities and Exchange Board of India should undertake not to purchase and/or sell shares of the company in the 12 weeks period after the offer.
1. Seller / promoter/ promoter group entities should not have been in the list of debarred entities as notified by SEBI.
2. The promoter/promoter group entities should not have purchased and/or sold the shares of the company (whose shares are offered in OFS) in the 12 weeks period prior to the offer and they should under not to purchase and/or sell shares of the company in the 12 weeks period after the offer.
3. Seller must inform the Exchange name of selling member broker at least one day prior to opening of the offer.
4. In case the seller(s) chooses not to publicly disclose the floor price, the seller(s) shall give the floor price in a sealed envelope to the Exchange (if BSE is designated stock exchange) before opening of the offer.
5. Seller(s) must ensure transfer of shares to selling members at least one day prior to the opening of the offer.
6. Seller(s) must ensure collection of funds from selling member brokers appointed by it.
7. Seller(s) must disclose upfront in its application to the Exchange conditions if any for withdrawal or cancellation of the offer.
8. Seller(s) can not extend or reduce bidding period once notice is issued by the Exchange on schedule of bidding.
The seller(s) / promoter(s) would be required to make application to the Exchange on its letter head as per the prescribed format as per Annexure 2. If there are more than one seller each one would be required to give the application separately.
The seller(s)/promoter(s) would have to execute an undertaking as per prescribed format as per Annexure 3 at the time of submitting application to the Exchange.
In pursuance of the trading regulations of the Exchange, following operating parameters are available for trading in Offer For Sale (OFS) segment –
The duration of the offer for sale will not exceed one trading day. The placing of orders by Trading Member(s) will take place during normal trading hours i.e. from 9:15 am to 3:30 pm. The seller as defined in 2.1 can decide the bidding period which can by any time during normal trading hours and subject to SEBI circular of February 1, 2012 on OFS through Stock Exchange Mechanism.
3.1.2. In case of market closure due to the incidence of breach of ‘market wide index based circuit filter’, the offer for shall be halted.
Every bid/order should be backed by 100% cash margin.
Member(s) shall issue contract notes as per the same structure and specifications as in the equity market segment.
The bidding process for OFS segment will be available through iBBS module, under the OFS segment. The OFS segment supports manual as well as upload bid entry facility.
At the order/bid entry level, for every order/bid 100% of the value of the offer/bid amount will be adjusted upfront on an on-line basis from the cash collateral deposited by the members with the Exchange/ICCL w.e.f. February 25, 2012, refer the Exchange’s Notice No.20120221-25 dated February 21, 2012.
In respect of institutional investors, Trading Members can either ensure availability of funds or margins of these customers at their end or give up such bids/orders to custodians.
There are two ways to give up bids in the bid entry module
On-line real time give-up:
Members will also have a facility for on-line real-time give-up of bids to the Custodians for their confirmation. In such case, on confirmation by the Custodians, the cash collateral of the Custodians will be directly adjusted upfront on an on-line real-time basis without adjusting the bidding member’s cash collateral. For this purpose, the bid entry screen would enable the member to give up bids to Custodians at the time of bidding. However, such bids will be treated as incomplete bids and will be given temporary bid ids till confirmation by the Custodians. Once these bids are accepted by custodians via RTRMS, the bids will be treated as confirmed bids and would be considered for the display for indicative or weighted average price on the Exchange site. If the on-line given-up bids are either rejected by the Custodians or not confirmed by the Custodians till end of the bid session on T day, then such bids will be treated as cancelled and will accordingly lapse.
Offline Give up:
In case of an off-line give up facility, the members must not enter the Custodian Clearing code while bidding in OFS iBBS module. Hence, initially at the time of order/bid entry the member’s cash collateral will be adjusted on-line upfront as mentioned above. Such bids will be considered normal i.e. valid bids. Members can give up such bids via RTRMS after the bids session on T day till 11.00 am on T+1 day. The Custodians can confirm such valid bids by 11.00 a.m on T+1 day, accordingly Custodian shall be required to do settlement of such bids with the Clearing Corporation.
The bid entry screen will require the following data to be provided by the users (Trading Members)
Field Name
|
Requirement
|
Action
|
OFS Symbol
|
Mandatory
|
Dropdown Menu
|
Category
|
Mandatory
|
MF / IC / OTHS
|
Application / Ref No.
|
Non Mandatory
|
Alpha Numeric
|
UCC
|
Mandatory
|
Alpha Numeric
|
Custodian Code / ID*
|
Non Mandatory
|
Numeric only Required for Give Up Bids
|
Qty
|
Mandatory
|
Numeric
|
Price
|
Mandatory
|
Numeric
|
Value
|
Mandatory
|
Auto Generated
|
* Members please note that only custodian code which is numeric is to be entered in the field of Custodian Code/ID. CP Codes are not to be entered in this field.
A bulk upload facility will be available within the OFS module. Upto 500 records can be uploaded by members in a single comma or pipe separated .csv or .txt file. Submitting the file will lead to blocking of margin in RTMS against the said member’s cash 100% collateral deposited with the Exchange. The bids successfully accepted will be allotted a bid id or order no. For file format refer Annexure 1.
Note: The bids having a Custodian code / id once submitted will be allotted a temporary bid id (order no). Once the bid is accepted or approved by the Custodian it shall be treated as a confirmed bid. For bids wherein margin is blocked against cash collateral of members, members can be given up to Custodian on T+1 day.
Successful bids would be available for modification and cancellation. Bids can be modified or cancelled manually and via bulk upload facility. Modification and cancellation will not be allowed in the last 30 minutes before the closure of the issue.
Bid Status
|
Modification
|
Cancellation
|
Before Give Up
|
Allowed
|
Allowed
|
After Give Up till approved by Custodian
|
Allowed
|
Allowed
|
After Give Up, after approval by Custodian
|
Not Allowed
|
Allowed
|
The bid book download will be available in the OFS module in real time basis. The provisional allocation file shall be available within the same screen on T day. PAN number of the client/buyer shall be considered for allocation, therefore PAN number in the UCC details given to the Exchange is mandatory for a bid to be reckoned as valid order.
Transaction Charges, STT and other levies currently collected in the equity segment would be applicable for OFS segment.
Selling members would be provided trade file for collection of required charges and levies.
Selling members would be required to deposit shares with the Exchange for OFS in advance before 11.00 am on T – 1 day where T is day for offer for sale.
Buyer Members/Custodian Members will be required to upfront deposit cash collateral for bidding on OFS Segment. The process of depositing cash collateral is the same as that of Equity Cash Segment. However, while instructing the Clearing Banks for the same, the members should specify the segment. W.e.f February 25, 2012, inter alia, the collateral is to be deposited in favour of Indian Clearing Corporation Ltd, for all the segments of BSE. For details, members are advised to refer to the BSE Notice No.20120221-25 dated February 21, 2012, in this regard.
Provisional obligations for settlement will be downloaded to the members at end of T day and final obligations for settlement will be down loaded to the members on T + 1 day.
The net funds pay-in obligation of members pertaining to the OFS segment shall be adjusted against the cash collateral deposited by the concerned members for the respective settlement and the balance on account of other dues shall be recovered on the pay-in day through the pay-in process from settlement accounts of the members maintained with designated clearing banks. The pay-in and pay-out of funds and securities for OFS segment is to be done through the designated clearing bank accounts and securities pool accounts currently used by members of BSE in Equity Cash Segment respectively.
The market types for giving instructions to the Depositories for securities pay-in pertaining to Offer for Sale segment would be “OFS”.
A typical settlement cycle for OFS Segment shall be as under:
Activities
|
Timings
|
T Day :
|
|
Provisional Settlement obligations download.
|
By 6.00 pm (approx)
|
T+1 Day :
|
|
Confirmation of give-up bids by Custodians
|
By 11.00 am
|
Final Settlement obligations download
|
By 12.30 pm (approx)
|
T+2 day
|
|
Processing of pay-in of funds and securities.
|
10:00 am.
|
Pay- out of securities/funds
|
12:30 pm.
|
All end of day files will be available on extranet. Provisional trade file will be available to members on T day after end of session. Final trade file will be available to members on T+1 day. The file formats will be same as equity segment. Refer Annexure 4 for file formats.
Extranet Url: https://member.bseindia.com
UPLOAD_FILE_FORMAT FOR MEMBER
|
Field Name
|
Mandatory / non-Mandatory
|
Alpha / Numeric
|
Length
|
Remark
|
OFS Symbol
|
Mandatory
|
Alphanumeric
|
10
|
Symbol of the Company/IPO
|
Category
|
Mandatory
|
Alphanumeric
|
5
|
Client Status master values would remain constant over all the scrips i.e.IC.MF and OTH
|
Application/ Reference No
|
Non Mandatory
|
Alphanumeric
|
16
|
Application number of the Form
|
UCC
|
Mandatory
|
Alphanumeric
|
12
|
UCC registered with the Exchange for equity trading
|
Custodian clearing code
|
Non Mandatory
|
Alphanumeric
|
12
|
Custodial clearing codes
|
Qty
|
Mandatory
|
Numeric
|
11
|
Quantity should always be in multiple of market lot
|
Price
|
Mandatory
|
Numeric
|
6.2
|
Bid price which should be more or equal to the floor price
|
Bid Id
|
Mandatory
|
Numeric
|
16
|
Bid Id is auto generated by the exchange. In case of generation of error file, values will be 0(zero) only if action code is N. For modification/deletion the Bid value has to be populated by Bid Id.
|
Action Code
|
Mandatory
|
Alphanumeric
|
1
|
Action code, i.e., “N” for new record, “M” for to be modified record and “D” for to deletion records.
|
SUCCESS_FILE_FORMAT FOR MEMBER
|
Field Name
|
Mandatory / non-Mandatory
|
Alpha / Numeric
|
Length
|
Remark
|
OFS Symbol
|
Mandatory
|
Alphanumeric
|
10
|
Symbol of the Company/IPO
|
Category
|
Mandatory
|
Alphanumeric
|
5
|
Client Status master values would remain constant over all the scrips i.e.IC.MF and OTH
|
Application/ Reference No
|
Non Mandatory
|
Alphanumeric
|
16
|
Application number of the Form
|
UCC
|
Mandatory
|
Alphanumeric
|
12
|
UCC registered with the Exchange for equity trading
|
Custodian clearing code
|
Non Mandatory
|
Alphanumeric
|
12
|
Custodial clearing codes
|
Qty
|
Mandatory
|
Numeric
|
11
|
Quantity should always be in multiple of market lot
|
Price
|
Mandatory
|
Numeric
|
6.2
|
Bid price which should be more or equal to the floor price
|
Bid Id
|
Mandatory
|
Numeric
|
16
|
Bid Id is auto generated by the exchange of generation of response filet will be 0(zero) only of action code is N
|
Action Code
|
Mandatory
|
Alphanumeric
|
1
|
Action code, i.e., “N” for new record, “M” for to be modified record and “D” for to delete records.
|
REJECTION_FILE_FORMAT FOR MEMBER
|
Field Name
|
Mandatory / non-Mandatory
|
Alpha / Numeric
|
Length
|
Remark
|
OFS Symbol
|
Mandatory
|
Alphanumeric
|
10
|
Symbol of the Company/IPO
|
Category
|
Mandatory
|
Alphanumeric
|
5
|
Client Status master values would remain constant over all the scrips i.e.IC.MF and OTH
|
Application/ Reference No
|
Non Mandatory
|
Alphanumeric
|
16
|
Application number of the Form
|
UCC
|
Mandatory
|
Alphanumeric
|
12
|
UCC registered with the Exchange for equity trading
|
Custodian clearing code
|
Non Mandatory
|
Alphanumeric
|
12
|
Custodial clearing codes
|
Qty
|
Mandatory
|
Numeric
|
11
|
Quantity should always be in multiple of market lot
|
Price
|
Mandatory
|
Numeric
|
6.2
|
Bid price which should be more or equal to the floor price
|
Bid Id
|
Mandatory
|
Numeric
|
16
|
Bid Id is auto generated by the exchange of generation of response filet will be 0(zero) only of action code is N
|
Action Code
|
Mandatory
|
Alphanumeric
|
1
|
Action code, i.e., “N” for new record, “M” for to be modified record and “D” for to delete records.
|
Error text
|
Mandatory
|
Alphanumeric
|
40
|
Gives detailed description of the error encountered during upload
|
BD File for OFS Issues (Member Bid Book)
|
Field Name
|
Data Type
|
Length
|
Remarks
|
OFS Symbol
|
Alphanumeric
|
10
|
Symbol of the Company/IPO
|
Category
|
Alphanumeric
|
5
|
Client Status master values would remain constant over all the scrips i.e.IC.MF and OTH
|
Application/ Reference No
|
Alphanumeric
|
16
|
Application number of the Form
|
UCC
|
Alphanumeric
|
12
|
UCC registered with the Exchange for equity trading
|
Custodian clearing code
|
Alphanumeric
|
12
|
Custodial clearing codes
|
Qty
|
Numeric
|
11
|
Quantity should always be in multiple of market lot
|
Price
|
Numeric
|
6.2
|
Bid price which should be more or equal to the floor price
|
Bid Id
|
Numeric
|
16
|
Bid Id is auto generated by the exchange. In case of generation of error file, values will be 0(zero) only if action code is N. For modification/deletion the Bid value has to be populated by Bid Id.
|
Action Code
|
Alphanumeric
|
1
|
Action code, i.e., “N” for new record, “M” for to be modified record and “D” for to deletion records.
|
DP ID
|
Alphanumeric
|
8
|
If CDSL then 0 has to be inserted into the column. If NSDL Min(8) and Max(8)
|
BD File for OFS Issues (Allocation File)
|
Field Name
|
Data Type
|
Length
|
Remarks
|
OFS Symbol
|
Alphanumeric
|
10
|
Symbol of the Company/IPO
|
Category
|
Alphanumeric
|
5
|
Client Status master values would remain constant over all the scrips i.e.IC.MF and OTH
|
Application/ Reference No
|
Alphanumeric
|
16
|
Application number of the Form
|
UCC
|
Alphanumeric
|
12
|
UCC registered with the Exchange for equity trading
|
Custodian clearing code
|
Alphanumeric
|
12
|
Custodial clearing codes
|
Qty
|
Numeric
|
11
|
Quantity should always be in multiple of market lot
|
Price
|
Numeric
|
6.2
|
Bid price which should be more or equal to the floor price
|
Bid Id
|
Numeric
|
16
|
Bid Id is auto generated by the exchange. In case of generation of error file, values will be 0(zero) only if action code is N. For modification/deletion the Bid value has to be populated by Bid Id.
|
Action Code
|
Alphanumeric
|
1
|
Action code, i.e., “N” for new record, “M” for to be modified record and “D” for to deletion records.
|
DP ID
|
Alphanumeric
|
8
|
If CDSL then 0 has to be inserted into the column. If NSDL Min(8) and Max(8)
|
To be forwarded by the selling promoter(s)/ promoter group entities with a covering letter:
DRAFT OF LETTER TO BE WRITTEN FOR OBTAINING CONSENT FOR USING OFFER FOR SALE SOFTWARE
Date:
The Managing Director
Bombay Stock Exchange Limited
PJ Towers,
Mumbai - 400 001
Sub: Usage of the electronic facilities and software of the Exchange for Offer for Sale (OFS) of (name of the co.)
Dear Sir,
I/ We (Promoters/ Promoter group entities) (“Offerers”) of (Name of the Company) are intending to make an Offer for Sale (OFS) of approximately (quantity) equity shares (‘Shares”) of the face value of Rs. (amount) each, through the Stock Exchange mechanism in accordance with SEBI circular no. SEBI/ MRD/ DP/ 05/ 2012 dated February 1, 2012.
I/ We request the Exchange to allow all the Trading Members of the Exchange to participate in the OFS process through the online OFS platform of the Exchange, subject to such terms and conditions as may be set by the Exchange in this regard including signing of any undertakings etc.
1. Provisions of facilities and Infrastructure.
BSE will make available the software for OFS
It is to be distinctly understood that the permission given by BSE to use their network and software of the Online OFS platform should not in any way be deemed or construed that the compliance with various statutory approved by BSE; nor does it in any manner warrant, certify or endorse the correctness or completeness of any of the compliance with the statutory and other requirements nor does it take any responsibility for the financial or other soundness of the offerers.
It is also to be distinctly understood that the approval given by BSE is only to use the software for participating in OFS process
2. Terms of Operations for the electronic facilities and software for OFS will cover the following:
a. A complete and continuous back up maintained by BSE, of the data being entered into the OFS system by Trading Members.
b. BSE to keep open on-line OFS facilities during those hours and dates as are finalized by BSE in consultation with Offerers and allowed as per the aforesaid SEBI circular.
3. The Exchange shall provide its services on a best effort basis. However, the Exchange shall not be liable for failure of the system or for any loss, damage, or other costs arising in any way out of:
a. Telecom network or system failures including failure of ancillary or associated systems or fluctuation or power or other environmental conditions, or
b. Accident, transportation, neglect, misuse, errors, frauds of the trading members or its authorized persons or the agents or any third party including other stock exchange
c. Any fault in any attachments or associated equipment (either supplied by the Exchange or approved by the Exchange) which forms or does not form part of the trading workstation installation or OFS system including any system issue or fault at other stock exchange
d. Act of God, fire, flood, war act of violence, or any other similar occurrence, or
e. Any accidental special or consequential damages including without limitation of loss of profit.
4. Charges of BSE
For availing the abovementioned services, I / We shall pay the fees as per the schedule of BSE.
We request you to kindly sign and return the duplicate copy of this letter.
Thanking you,
Yours sincerely,
Name(s) of the Selling Promoters/ Promoter group entities and Signature
Approval granted on the above-mentioned terms
For Bombay Stock Exchange Limited
Authorised Signatory
Confirmation cum Undertaking to be given by the selling promoter(s)/ promoter group entities
Date:
The Managing Director
Bombay Stock Exchange Limited
PJ Towers
Mumbai - 400 001
Sub: Offer for Sale (OFS) of (name of the co.)
Dear Sir,
I/ We (Promoters/ Promoter group entities) (“Offerers”) of (Name of the Company) are intending to make an Offer for Sale (OFS) of approximately (quantity) equity shares (‘Shares”) of the face value of Rs. (amount) each, through the Stock Exchange mechanism in accordance with SEBI circular no. CIR/ MRD/ DP/ 05/ 2012 dated February 1, 2012.
In this regard, I/ we confirm the following:
a) I/ We am/ are the promoter(s)/ promoter group entities of (Name of the Company)
b) I/ We am/ are the promoter(s)/ promoter group entities are not barred by SEBI or any other regulatory authority to carry out the Offer for Sale
c) (Name of the Company) is required to maintain a minimum public shareholding of 25% in terms of rule 19(2)(b)/ 19A of Securities Contracts (Regulation) Rules, 1957 and the OFS has been undertaken by us to comply with the said rule.
d) The shares offered are all listed on the Exchange and are in dematerialized mode
e) None of the promoter/ promoter group entities have bought or sold shares during the 12 week period prior to the date of Offer for Sale
f) The shares being offered for sale are free from all encumbrances and there is no regulatory prohibition on the said shares
g) I/We are aware BSE can change and amend requirements, guidelines and give further instructions to me/us and we shall bound by such regulatory requirements as intimated by BSE.
h) I/We shall provide all information as required for OFS as specified by the Exchange from time to time.
Further, I/ we wish to undertake that:
i. I/ We shall make an announcement of OFS, atleast one trading day prior to the commencement of OFS alongwith the necessary details as given in para 5(b) of the aforesaid circular
ii. I/ We shall be depositing the shares with the designated stock exchange through the trading member appointed as per (iii) below atleast 1 trading day prior to the opening of the offer
iii. I/ We shall appoint trading member(s) of BSE to undertake the transaction and shall inform the same to BSE
iv. I/ We shall bear all the expenses relating to the OFS
v. I/ We shall not buy/ sell shares or securities of the company for a period of 12 weeks from the closure of OFS as prescribed by SEBI in its aforesaid circular
vi. I/ We shall disclose the floor price to BSE (in case BSE is the designated stock exchange) in a sealed envelope where the same is not declared to the market. In such a case, I/ We shall not disclose the floor price to anybody including the trading member(s) appointed to undertake the OFS
vii. In case of withdrawal of offer for sale prior to its proposed opening, I/ We shall not make an OFS within a period of 10 trading days from the date of such withdrawal
viii. I/ We shall not cancel the OFS during the bidding period
ix. I/ We shall co-operate with BSE for completion of the allocation and settlement process in a timely manner as prescribed in the aforesaid SEBI circular
Thanking you,
Yours sincerely,
Name(s) of the Selling Promoters/ Promoter group entities and Signature
Provisional Money Statement File (Fixed Length) Msddmmyyp.<Member Code>/Final Money Statement (Fixed Length) Msddmmyyf.<Member Code>
|
Serial No.
|
Field Name
|
Field Type
|
Field Length
|
1
|
ScripCd
|
Numeric
|
6
|
2
|
BuyQty
|
Numeric
|
9
|
3
|
BuyVal
|
Numeric
|
11
|
4
|
SellQty
|
Numeric
|
9
|
5
|
SellVal
|
Numeric
|
11
|
6
|
Sign
|
Char
|
1
|
7
|
NetQty
|
Numeric
|
9
|
8
|
Sign
|
Char
|
1
|
9
|
NetVal
|
Numeric
|
11
|
10
|
Standard Rate
|
Numeric
|
10 digit with assumed decimal Eg: 00013457.95
|
11
|
Sign
|
Char
|
1
|
12
|
NetValue@ Standard Rate
|
Numeric
|
11
|
13
|
Sign
|
Char
|
1
|
14
|
StandardRate@ Difference
|
Numeric
|
11
|
15
|
Sign
|
Char
|
1
|
16
|
NetAmount
|
Numeric
|
11
|
17
|
Sign
|
Char
|
1
|
18
|
OutstandingQty
|
Numeric
|
9
|
19
|
CallDivFlag
|
Char
|
1
|
20
|
CallDivAmount
|
Numeric
|
4 digit with assumed decimal Eg: 24.75
|
21
|
Sign
|
Char
|
1
|
22
|
BankQty
|
Numeric
|
9
|
STT File(Clientwise)(Pipe Separated) CLNTSTT<ddmmyy>.(MemberCode )
|
Serial No.
|
Field Name
|
Field Type
|
Field Length
|
|
1
|
Date
|
Char
|
8
|
|
2
|
MemberCd
|
Numeric
|
4
|
|
3
|
ScripCd
|
Numeric
|
6
|
|
4
|
GroupCd
|
Char
|
2
|
|
5
|
ClientCd
|
Char
|
11
|
|
6
|
MapinNo
|
Char
|
9
|
|
7
|
PanNo
|
Char
|
10
|
|
8
|
TranType
|
Char
|
1
|
|
9
|
TranSettlNo
|
Char
|
2
|
|
10
|
WAP Rate
|
Numeric
|
9
|
|
11
|
Delv. Pur Qty
|
Numeric
|
9
|
|
12
|
Delv. Pur Value
|
Numeric
|
13
|
|
13
|
Delv. Sell Qty
|
Numeric
|
9
|
|
14
|
Delv. Sell Value
|
Numeric
|
13
|
|
15
|
No Delv. Qty
|
Numeric
|
9
|
|
16
|
No Delv. Value
|
Numeric
|
13
|
|
17
|
Delv. Purchase STT
|
Numeric
|
11
|
|
18
|
Delv. Sell STT
|
Numeric
|
11
|
|
19
|
No Delv. STT
|
Numeric
|
11
|
|
STT File(Memberwise)(Pipe Separated)MBRSTT<ddmmyy>.(Member Code)
|
Serial No.
|
Field Name
|
Field Type
|
Field Length
|
1
|
Date
|
Char
|
8
|
2
|
MemberCd
|
Numeric
|
4
|
3
|
Member STT
|
Numeric
|
12
|
4
|
Space
|
Char
|
105
|
5
|
MemberCd
|
Numeric
|
4
|
6
|
Date
|
Char
|
8
|
7
|
ClientCd
|
Numeric
|
11
|
8
|
Client STT
|
Numeric
|
12
|
9
|
Space
|
Char
|
98
|
10
|
MemberCd
|
Numeric
|
4
|
AN020212.807 (Pipe Separated) Anddmmyy.<Member Code>
|
Serial No.
|
Field Name
|
Field Length
|
Field Description
|
1
|
Mem Id
|
3
|
Member Id
|
2
|
TdrId
|
3
|
Trader Id
|
3
|
SCd
|
6
|
Scrip Code
|
4
|
ScId
|
5
|
Scrip Id
|
5
|
Rt
|
4
|
Rate
|
6
|
Qty
|
4
|
Quantity
|
7
|
OppMId
|
|
Opposite Member Id
|
8
|
OppTrId
|
|
Opposite Trader Id
|
9
|
Time
|
8
|
Time
|
10
|
Date
|
10
|
Date
|
11
|
ClId
|
|
Client Id
|
12
|
TrnId
|
|
Transaction Id
|
13
|
Trn Typ
|
|
Transaction Type
|
14
|
Buy/Sell
|
|
Buy or Sell
|
15
|
Trade Id
|
|
Trade Id
|
16
|
Inst Id
|
3
|
Institutional Id
|
17
|
ISINCd
|
12
|
ISIN Code
|
18
|
ScrGrp
|
|
Scrip Group
|
19
|
SettNo
|
7
|
Settlement Number
|
20
|
OrdTimestamp
|
8
|
Order Time stamp
|
21
|
AO/PO Flag
|
1
|
AO or PO flag *
|
22
|
LocationId
|
1
|
Location Id
|
23
|
Filler1*
|
|
|
STT Report
|
|
|
|
|
|
This is a REPORT file. Sample report file given below.
|
|
|
Hope this will be in the same format.
|
|
|
|
Bombay Stock Exchange Ltd. CLIENTWISE SCRIPWISE SECURITIES TRANSACTION TAX RUN DATE - dd/mm/yyyy PAGE NO.-
|
OFS SEGMENT TRADING DATE - dd/mm/yyyy
|
CLEARING NO. - xx NAME - xx
|
* CLIENT TOTAL ** CLIENT TOTAL ROUNDED OFF
|
|
|
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
|
|
|
|
ClientCd MapinNo/ ScripCd TranSettlNo Bid PurQty SellQty NonDelvQty PurSTT SellSTT NonDelSTT
|
PanNo ScripNm TrnTyp Price PurVal SellVal NonDelvVal Rs.Ps Rs.Ps Rs.Ps
|
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
ADWA049 532351 101/20062007 61.69 500 0 0 38.56 0.00 0.00
|
AKSHOPTFBR OFS 30845 0 0
|
|
* 38.56 0.00 0.00
|
** 39
|
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
TOTAL S.T.T. PAYABLE (Purchase + Sell + Non-Deliverable S.T.T) --- > Rs. 319115
|
|
|
|
|
|
|
Purchase,Sell STT @Rate - 0.125% ,Non-Deliverable STT @Rate - 0.025%
|
|
|
|
|
|
|
TranType --> OFS
|
|
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|