DOWNLOAD REFERENCE NO: NSE/CMPT/6478

NSCCL/SEC/2005/660 August 5, 2005

NATIONAL SECURITIES CLEARING CORPORATION LIMITED

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.