SECURITIES AND EXCHANGE BOARD OF INDIA
MUTUAL FUND DEPARTMENT
Mittal Court, A Wing, Gr. Floor,
224, Nariman Point, Mumbai 400 021

To:

All Mutual Funds registered with SEBI/
Unit Trust of India

Dear Sir,

Re. : Reporting of Transactions by Mutual Funds

With a view to monitor the trends of investments by mutual funds, all mutual funds are hereby advised to submit details of transactions in secondary market on daily basis effective from 23^rd December, 1999. You are, therefore, advised to ensure to make necessary arrangements with your custodians for the submission of reports on daily basis. The details of format as well as the specifications of the report are enclosed herewith. The report is to be submitted in both hard as well as soft copy in a floppy.

It must be ensured by the compliance officers of the custodians as well as that of mutual funds that the information submitted is correct and reaches Shri J.B. Ram, Officer, Mutual Funds Department , SEBI, 1^st Floor, Mittal Court, ‘B’ Wing, Nariman Point, Mumbai 400 021, by 3.00 p.m. on the following working day (T+1). The name, designation, office address, email address (if any), telephone and fax numbers of the concerned personnel of the mutual fund as well as the custodian may be communicated to SEBI within three days of the receipt of this letter.

Please acknowledge receipt.

Yours faithfully,

P.K. Nagpal
DIVISION CHIEF
MUTUAL FUNDS DEPARTMENT

Encl. : Annexures

Format and Specification of the Daily Transaction Report

Operational notes on Reporting of transactions by registered Mutual Funds

DAILY REPORTS

1. The format of DTR, explanation of codes, field widths etc are enclosed in

Annexure "A".

1. The data as per DTR would be submitted in "TEXT" format with fields separated by "|" (ie a pipe).
2. All transaction will have a unique transaction identification number which would be given by the AMCs/custodians at their end.
3. In case of any change in transaction already reported to SEBI, such change can be reported as amendment transaction with the following characteristics

1. Transaction type is to be reported as "A’
2. Transaction ID shall be the same as that of earlier reported transaction.
3. Correct details .

In other words the system will cancel the earlier reported transaction and will only consider the amended transaction for processing.

REPORTING TYPE - R_TYPE

N - New Transaction .
A - Amendment in earlier transaction.
D - Deletion of earlier reported transaction.

General Aspects:

1. The date format to be used all the reports submitted to SEBI would be DD-MON-YYYY.
2. All Transaction values are In CRORES.
3. The file names to be used for submitting the report in soft copies are

DTR : D<ddmm><3 char of Custodian code No>.txt

For eg. Custodian code No : 001 for the date Dec 02

The file name would be D0212001.TXT
 

Annexure "A"

DTR (List and field description of codes in DTR).

(1) NUMBER (12,2) -- Number with 10 integer and 2 decimal digits.

(2) All transaction values to be reported in crores.

Annexure " B"

Format of the text file :

File Name : D0212001
 

A B C D E F

001|MF/001/93/1|ID01|02-DEC-1999|02-DEC-1999|N|2.25|5.23|20.55|66.12|39.1|2.3|

Amendment :

For eg .

Original Record is

001|MF/001/93/1|ID01|02-DEC-1999|02-DEC-1999|N|2.25|5.23|20.55|66.12|39.1|2.3|

Suppose Tot_Pur_Eq to be changed from 2.25 to 25.5 then the amended

record would be

001|MF/001/93/1|ID01|02-DEC-1999|04-DEC-1999|A|25.5|5.23|20.55|66.12|39.1|2.3|

and reported on 4^th December, 1999.

A : TOT_PUR_EQ

B : TOT_SAL_EQ

C : TOT_PUR_DEBT

D : TOT_SAL_DEBT

E : TOT_PUR_EQ_BSE (Sensitive Index out of A)

F : TOT_SAL_EQ_BSE (Sensitive Index out of B)