|
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")
|