How to use FLT file :-
Client Account Transfer From DPM Trxn.>> (A) Import from NSDL (B)
Import from CDSL
1. NSDL Flt / CDSL Flt (Unformatted Transaction File) or DPC9
Flt file format :-
01IN3017582005020320050203200502041245110000042570000000000000000
02000000001000000100000060120050203INE029A0101110C00000000045000020411 00 F00
IN0000260000000001205160000000 20050203163804
000000000000000012024800000001080000000000000
02000000002000000100000060120050203INE029A0101110C00000000087600004411IN001019050405215F00
IN3017580000000022222829580999 20050203164058IN6518870000000000000000
0000000000000
02000000003000000100000060120050203INE029A0101110D00000000132600004112IN001002132005021B00
IN3017580000000021511110000000 20050203164100IN5583100000000000000000
0000000000000
DPC9 file format :-
01~24800~1202480000002152~18-03-2005~18-03-2005
02~INE064C01014~ABHISHEK INDUSTRIES
03~18-03-2005~Opening Balance~~~0.000
04~18-03-2005~NSCCL-CR IN001002 12 118052005C05 SETT W2005051N~C~900.000~900.000
05~18-03-2005~Closing Balance~~~900.000
| Import from Nsdl transaction file :- |
| 1. Click on Pool A/c |
| 2. Enter the Pool A/c number |
| 3. Give the path and file name with extn. |
| 4. If at the time of importing trade file you are ticking BE merging in EQ then tick here also |
| 5. For ignore some of client then give Dp ID & Client Id in Skrip Dp/Client Id |
| 6. Tick on Credit & Debit |
| 7. Select the Exchange NSE or BSE |
| 8. Click on Proceed. |
| In Cdsl click Ignore Clearing House Trxn if Own Dp
is "No" in system file maintenance.
|
| Ques:- How to delete the wrong imported flt file ? |
| Solu:- If we tick on Initialize UnTransfered Transactions and just click on proceed. It will delete all the un-transferred files. |
| # On error "Single Row Sub Query Return More Than One Value" go to Utilities > Query Analyzer then type the query:- |
| SELECT NSESETTNO FROM SETTFILE WHERE SETTNO LIKE 'NN%' GROUP BY NSESETTNO HAVING COUNT(*) >1 (you have to run same query for 'NA','NW','BR','BO','BA') and press F5 if you find duplicate then remove it, or if you don't find run the following query:- |
| select settno,nsesettno from settfile where nsesettno is not null and substr(settno,1,2)||nsesettno in ( select substr( settno,1,2 )||nsesettno from settfile group by substr( settno,1,2 )||nsesettno having count(*)>1) order by nsesettno and click on F5 if it shows duplicate settlement no. then remove it . |
