Hi
this hsbc out put format given by hsbc bank people:
i cann't understand this output format...
anybody making payment through hsbc in india could you explain me ??
IFH<HD>,IFILE<HD>,CSV<HD>,ABC65385001<HSBC Connect ID>,INHBAPGIN115020513<HSBCnet Customer ID>,UBS140720070001<Unique File Reference>,2007/07/14<File Date>,12:10:01<Generation Time>,P<Authorisation type>,1.0<hardcoded>,69<Total number of lines>
BATHDR<HD>,COS<Payment type-PAPER>,1<HD>,UBS12345614072007<Batch refr>,,,,,,@1ST@<HD>,,041222222001<HSBC Bank Account No>,INR<hd>,94582.00<Instrument amount>,,,IN<HD>,HBAP<HD>,INR<HD>,,UBS ltd<HD>,,123456<Cheque number>,,,,UBS12345614072007<Batch refr>
COS<Payment type>,I<HD>,ACC<COS Type-CHEQUE>,IN<HD>,HBAP<HD>,041222222001<HSBC Bank Account No>,,,INR<HD>,94582.00<Instrument amt>,,,IN<HD>,123456<UNIQUE REFERNCE NUMBER>,,,,,,C,Y,N,1<HD>,,,,,,,,IN<HD>,,,,,,,,,,,Chennai<Printing location>
COS-BEN<HD>,I<HD>,,,GANESH STORES<BENE NAME>,RAMACHANDRAN<ADD 1>,6/38B MAIN ROAD<ADD 2>,VEERAKERALAMPUDUR<ADD 3>,VEERAKERALAMPUDUR<ADD 4>,VEERAKERALAMPUDUR<ADD 5>,627861<ADD 6>,IN<HD>,,,,,,,,,,,W<HD FOR CHEQUE>,,,,,,,,,C<HD>
COS-TXT,I,N<HD FOR CHEQUE ADVISING - MAXIMUM 90 CHAR PER LINE>,Note: Please find the payment details
COS-TXT,I,N,BILL NO DATE AMOUNT TDS STDS NET
COS-TXT,I,N,==========================================================================================
COS-TXT,I,N,4305011007 20050625 1000.00 0.00 0.00 1000.00
ADV,,R ,,,,,2 ,1 ,GANESH STORES ,,,,,,,F,Y,1 , ramachandran@ganeshstores.com ,,IN
ADV,,R,,,,,2,2,Suguna,,,,,,,F,Y,1,manager@suguna.com,,IN
ADV-FREETXT<HD ADVISNG RECORD - FREE TEXT>,1<LINE NUMBER>,,,,Note: Please find the payment details<MAX 90 CHAR PER LINE>
ADV-TBLTXT<HD FOR TABULAR FORMAT HEADER>,6<MAX 6 COLUMN>,15<COLUMN WIDTH>,L<JUSTIFICATION(L OR r)>,BILL NO<COLUMN HEADER>,10,L,DATE,15,R,AMOUNT,10,R,TDS,10,R,STDS,15,R,NET
ADV-TBLBDY<HD FOR TABLE BODY>,4305011007<ENTRY DETAIL>,15<COLUMN WIDTH>,20050625,10,1000.00,15,0.00,10,0.00,10,1000.00,15
ADV-TBLBDY,Total,15,,10,,15,,10,,10,1000.00,15
BATHDR,COS,1,TNROUDTDD1234140707
COS,I,IDD<COS TYPE - DEMAND DRAFT>,IN,HBAP,041117433001,,,INR,9570.00,,,IN,,,,,,,C,Y,N,1,,,,,,,,IN,,,,,,,,,,,CHENNAI<PRINT LOCATION>,,MADURAI<PAYABLE LOCATION>
COS-BEN,I,,,ANNAMALAI,ANNAMALAI,Madurai,,,,600001,IN,,,,,,,,,,,S<HD FOR IDD/ICO/DDP>,,,,,,,,,C
COS-TXT,I,N,Note: Please find the payment details
COS-TXT,I,N,BILL NO DATE AMOUNT TDS STDS NET
COS-TXT,I,N,==========================================================================================
COS-TXT,I,N,4305011007 20050625 1000.00 0.00 0.00 1000.00
ADV,,R,,,,,2,1,GANESH STORES,,,,,,,F,Y,1,ramachandran@ganeshstores.com,,IN
ADV,,R,,,,,2,2,Suguna,,,,,,,F,Y,1,manager@suguna.com,,IN
ADV-FREETXT,1,,,,Note: Please find the payment details
ADV-TBLTXT,6,15,L,BILL NO,10,L,DATE,15,R,AMOUNT,10,R,TDS,10,R,STDS,15,R,NET
ADV-TBLBDY,4305011007,15,20050625,10,1000.00,15,0.00,10,0.00,10,1000.00,15
ADV-TBLBDY,Total,15,,10,,15,,10,,10,1000.00,15
BATHDR,COS,1,TNROUDTICO1234140707
COS,I,ICO<COS TYPE - CASHIER ORDER>,IN,HBAP,041117433001,,,INR,18940.00,,,IN,,,,,,,C,Y,N,1,,,,,,,,IN,,,,,,,,,,,Coimbatore
COS-BEN,I,,,BALAMURUGAN,BALAMURUGAN,COIMBATORE,,,,600001,IN,,,,,,,,,,,S<HD FOR IDD/ICO/DDP>,,,,,,,,,C
COS-TXT,I,N,Note: Please find the payment details
COS-TXT,I,N,BILL NO DATE AMOUNT TDS STDS NET
COS-TXT,I,N,==========================================================================================
COS-TXT,I,N,4305011007 20050625 1000.00 0.00 0.00 1000.00
ADV,,R,,,,,2,1,GANESH STORES,,,,,,,F,Y,1,ramachandran@ganeshstores.com,,IN
ADV,,R,,,,,2,2,Suguna,,,,,,,F,Y,1,manager@suguna.com,,IN
ADV-FREETXT,1,,,,Note: Please find the payment details
ADV-TBLTXT,6,15,L,BILL NO,10,L,DATE,15,R,AMOUNT,10,R,TDS,10,R,STDS,15,R,NET
ADV-TBLBDY,4305011007,15,20050625,10,1000.00,15,0.00,10,0.00,10,1000.00,15
ADV-TBLBDY,Total,15,,10,,15,,10,,10,1000.00,15
BATHDR,COS,1,TNROUDTDDP1234140707
COS,I,DDP<COS TYPE - DEMAND DRAFT PURCHASE>,IN,HBAP,041117433001,,,INR,22140.00,,,IN,,,,,,,C,Y,N,1,,,,,,,,IN,,,,,,,,,,,Coimbatore,,KOVILPATTI
COS-BEN,I,,,KANNAN,KANNAN,KOVILPATTI,,,,345455,IN,,,,,,,,,,,S,,,,,,,,,C
COS-TXT,I,N,Note: Please find the payment details
COS-TXT,I,N,BILL NO DATE AMOUNT TDS STDS NET
COS-TXT,I,N,==========================================================================================
COS-TXT,I,N,4305011007 20050625 1000.00 0.00 0.00 1000.00
ADV,,R,,,,,2,1,GANESH STORES,,,,,,,F,Y,1,ramachandran@ganeshstores.com,,IN
ADV,,R,,,,,2,2,Suguna,,,,,,,F,Y,1,manager@suguna.com,,IN
ADV-FREETXT,1,,,,Note: Please find the payment details
ADV-TBLTXT,6,15,L,BILL NO,10,L,DATE,15,R,AMOUNT,10,R,TDS,10,R,STDS,15,R,NET
ADV-TBLBDY,4305011007,15,20050625,10,1000.00,15,0.00,10,0.00,10,1000.00,15
ADV-TBLBDY,Total,15,,10,,15,,10,,10,1000.00,15
BATHDR,LTR<PAYMENT TYPE - ELECTRONIC>,1,TNROUDTNEFT134140707,,,,,,@1ST@,20070716<VALUE DATE>,115121139001,INR,500.00,,,IN,HBAP,INR,,ABC (PVT) LTD (OU),,,,,,TNROUDTNEFT134140707
SECPTY<HD FOR LTR>,60000001111<BENE AC NUMBER>,Ganesh Stores (PVT) LIMITED<BENE NAME>,,,,,500.00<AMOUNT>,20070716<VALUE DATE>,1110<UNIQUE REFERENCE>,,,,,Y,N<HD>,,,,,,@HVP@<HD>,1110<UNIQUE REFERNCE>,INR<HD>,,,,,,,,,,,BCD<HD>,IBKL0000006<IFSC CODE 11 DIGITS>,IDBI BANK LTD<BENE BANK NAME>,,,,,IN<HD>,,,,,,OUR<HD>,,,,,,,/ACC/NEFT<FOR NEFT>
ADV,,R,,,,,2,1,GANESH STORES,,,,,,,F,Y,1,ramachandran@ganeshstores.com,,IN
ADV,,R,,,,,2,2,Suguna,,,,,,,F,Y,1,manager@suguna.com,,IN
ADV-FREETXT,1,,,,Note: Please find the payment details
ADV-TBLTXT,6,15,L,BILL NO,10,L,DATE,15,R,AMOUNT,10,R,TDS,10,R,STDS,15,R,NET
ADV-TBLBDY,4305011007,15,20050625,10,1000.00,15,0.00,10,0.00,10,1000.00,15
ADV-TBLBDY,Total,15,,10,,15,,10,,10,1000.00,15
BATHDR,LTR,1,TNROUDTRTGS1234140707,,,,,,@1ST@,20070716,115121139001,INR,500000.00,,,IN,HBAP,INR,,ABC (PVT) LTD (OU),,,,,,TNROUDTNEFT134140707
SECPTY,60000001111,Ganesh Stores (PVT) LIMITED,,,,,500000.00,20070716,1110,8/116-C?, ATHIPALAYAM ROAD,CHINNAVEDAMPATTI?,,Ramachandran,,Y,N,,,,,,@HVP@,1110,INR,,,,,,,,,,,BCD,IBKL0000006,IDBI BANK LTD,,,,,IN,,,,,,OUR,,,,,,,/ACC/<FOR RTGS>
ADV,,R,,,,,2,1,GANESH STORES,,,,,,,F,Y,1,ramachandran@ganeshstores.com,,IN
ADV,,R,,,,,2,2,Suguna,,,,,,,F,Y,1,manager@suguna.com,,IN
ADV-FREETXT,1,,,,Note: Please find the payment details
ADV-TBLTXT,6,15,L,BILL NO,10,L,DATE,15,R,AMOUNT,10,R,TDS,10,R,STDS,15,R,NET
ADV-TBLBDY,4305011007,15,20050625,10,1000.00,15,0.00,10,0.00,10,1000.00,15
ADV-TBLBDY,Total,15,,10,,15,,10,,10,1000.00,15