Input File (ERP "D FILE")

Elobration of the above data:
0000000000001011pigmy028002985000002100290Ikar Yogesha Ramakrishan                          0000000000.0000100.0029/03/202500000000000606929/03/202529/03/2025000000000000000
0000000000001011pigmy028002985000003100291Naik Manjunatha  Gonvida                          0000000000.0000100.0029/03/202500000000000606929/03/202529/03/2025000000000000000


Sequence No	Field name		Type of Data	Length of data		Remarks
1		Branch Id		Numeric			15		000000000000101	
2		Category Code		Numeric			1		1
3		Scheme Code		AlphaNumeric		5		pigmy	
4		Account No.		AlphNumeric		15		028002985000002	
5		Customer Id		Numeric			6		100290			
6		Customer Name		Text			50		Ikar Yogesha Ramakrishan                          	
7		Closing Balance		Decimal			13		0000000000.00
8		Agreed Amount		Decimal			8		00100.00
9		Closing Balance Date	Date Format		10		29/03/2025
10		Agent ID		AlphaNumeric		15		000000000006069	
11		Account Opening Date 	Date Format		10		29/03/2025
12		Last Transaction Date	Date Format		10		29/03/2025
13		Society Deposite No.	AlphaNumeric		15		000000000000000



                                                             Input file to Output File Conversion


Example of Converted data First Line : 

000000,000002,000200          ,000000,29.03.25,00000000 

MEANING OF FIRST LINE AS FOLLOWS
Field No.	Field name				Length of field
1	 	Agent’s last account no.		 6 ( 000000 - The Agent’s last account no. Should be "0's"..The Length Should be "6")
2		Total No. of Receipts		         6 (The Count of the Input file number of record value should be in Total No. of Receipts .The Length Should be "6")
3		Total collection amount			16 (Eg: 000020 - The Total collection amount.Starting 6 digits are Should be "Sum Amount".Remaining "10" was filled with spaces)
4		Bank and Agent’s Code			6  ( 000000 - Bank and Agent’s Code Should be "0's")
5		collection date (current date)		8  (29.03.25 - Need to pick from Closing Balance Date field(9) in Input File of ERP "D FILE" and the date comes with "." only)
6		Password				8  ( 00000000 - The Password Should be "0's")

Example of Converted data Second Line : 


000002,000000,Ikar Yogesha Ram,000100,29.03.25,000000
000003,000000,Naik Manjunatha ,000100,29.03.25,000000

MEANING OF 2ND LINE AS FOLLOWS
Field No.	Field name				Length of field/Process
1		Account No.				 6  (000002 - We need to pick last 6 digits from Account No(4) in Input File)
2		collection			         6  ( 000000 - The Collection Amount Should be "0's".The Length Should be "6")
3		customer name		                 16 ( Ikar Yogesha Ram - We need to pick Fist 16 Charaters including spaces from Customer Name Field(6) in Input file .The length should maintain "16")
4		balance after collection		 6  (000100 - Need to pick from Agreed Amount(8) Field in Input File and the length should be "6" to maintain)
5		collection date		                 8  (29.03.25 - Need to pick from Closing Balance Date(9) field in Input File and the date comes with "." only)
6		collection amount of one day             6  (000000 - The Collection Amount of one day Should be "0's".The Length Should maintain "6")