National Securities Clearing Corporation Limited

DOWNLOAD REFERENCE NO: NSE/CMPT/6478
NSCCL/SEC/2005/660
August 5, 2005

To
All Members/Custodians,

Sub: - Change in delivery reports

Currently the following reports are available to members providing details about settlement in ‘.lis’ format:
1) DFDS (Demat Final Delivery Statement)
2) DFRS (Demat Final Receipt Statement)
3) CADT (Direct Client Pay Out Report)
4) DWTH (Memberwise Withheld Securities Statement)

As a step towards enabling faster processing of data, the aforesaid reports will be provided in .csv formats. The revised formats of the aforesaid reports are as per Annexure A. In order to ensure smooth transition the reports will be provided in both the lis and csv formats upto August 31, 2005. The reports will be available only in csv formats w.e.f. September 01, 2005.

All members and custodians are requested to take note of the above.

Yours faithfully,
For National Securities Clearing Corporation Ltd.

Rana Usman
Manager

Annexure A
1. Memberwise Withheld Securities Statement

Header Record

Record type, File Type, Member type, Member Code, Date, Number of records, Total Qty
Record Type = 01
File Type = DWTH
Date = The date in the file naming convention of the file with format YYYYMMDD
Number of Records = Total Number of detail records
Total Qty = Total of Withheld qty appeared in the report

Detailed Record

Record Type, Sett Type,Sett No,Del Type,Symbol,Series,ISIN,Depository,Withheld qty,Released qty,Balance qty
Record Type =10

2. SecurityWise Demat Delivery Statement

Header Record

Record type, File Type, Member type, Member Code, Date,Number of records, Total Qty
Record Type = 01
File Type = DFDS
Date = The input date (Payin Date) of the report with format YYYYMMDD
Number of Records = Total Number of detail records
Total Qty = Total of quantities across all securities appeared in the report

Detailed Record

Record Type,Sett Type,Sett No,Del Type,Symbol,Series,ISIN,Quantity Delivered,Depository,Transaction No
Record Type =10

3.  SecurityWise Demat Receipt Statement

Header Record

Record type, File Type, Member type, Member Code, Date,Number of records, Total Qty
Record Type = 01
File Type = DFRS
Date = The input date (Payin Date) of the report with format YYYYMMDD
Number of Records = Total Number of detail records
Total Qty = Total of quantities across all securities appeared in the report

Detailed Record

Record Type,Sett Type,Sett No,Del Type,Symbol,Series,ISIN,Quantity Received,Depository,Transaction No
Record Type =10

4. Direct Client Payout Report.

Header Record.

Record type, File Type, Member type, Member Code, Date,Number of records, Total Qty
Record Type = 01
File Type = CADT
Date = The input date (Payin Date) of the report with format YYYYMMDD
Number of Records = Total Number of detail records
Total Qty = Total Qty received to the member

Detailed Record 1 (Securitywise client level allocation)

Record Type,Sett Type,Sett No,Del Type,Symbol,Series,ISIN,Qty Recd, Depository, Transaction No, Qty Credit to CM Pool A/c / Clearing A/c, Qty Credit to Beneficiary A/c
Record Type =10

Detailed Record 2 (Details of Direct Payout to Beneficiary Account)

Record Type,Sett Type,Sett No,Del Type,Symbol,Series,ISIN,Depository, Beneficiary Account No, Qty Reqd to be in Beneficiary A/c, Qty actually credited in Beneficiary A/c, Transaction No
Record Type =20

The file naming conventions shall remain same.