|
|
|
|
|
Input File:
|
|
|
|
00540,000974,197890 ,000001,16-04-24,12345678
|
|
01807,002500,GEETA G MAGI ,002600,15-04-24,000200
|
|
|
|
The Above file is a input file for the pigmy uploading process:
|
|
1.Here,the first line Defines:
|
|
|
|
00540,000974,197890 ,000001,16-04-24,12345678
|
|
|
|
MEANING OF FIRST LINE AS FOLLOWS
|
|
Field No. Field name Length of field
|
|
1 Agent’s account no. 6
|
|
2 Total No. of Receipts 6
|
|
3 Total collection amount 16(6 zero appointed)
|
|
4 Bank and Agent’s Code 6 (first 3 for bank and 3 for agent)
|
|
5 collection date (current date) 8 (DD.MM.YY)
|
|
6 Password 8 (first 4 AGENT & next 4 MANAGER)
|
|
|
|
|
|
2.Second line,Defines:
|
|
|
|
01807,002500,GEETA G MAGI ,002600,15-04-24,000200
|
|
|
|
MEANING OF 2ND LINE AS FOLLOWS
|
|
Field No. Field name Length of field
|
|
1 Account No. 6
|
|
2 1 day collection 6
|
|
3 customer name 16
|
|
4 Closing Balance 6
|
|
5 opening date 8
|
|
6 collection amount 6
|
|
|
|
|
|
Output File:The below mentioned figure is output file :
|
|
|
|
Sequence No Field name Type of Data Length of data
|
|
1 Branch Id Numeric 15
|
|
2 Category Code Numeric 1
|
|
3 Scheme Code Char 5
|
|
4 Account No. AlphNumeric 15
|
|
5 Customer Id Numeric 6
|
|
6 Customer Name Text 50
|
|
7 Closing Balance Decimal 13
|
|
8 Agreed Amount Decimal 8
|
|
9 Closing Balance Date Date Format 10
|
|
10 Agent ID AlphaNumeric 15
|
|
11 Amount Collected Decimal 10 0000500.00
|
|
12 Date of Collection Date format 10
|
|
13 Blank Space Null 1
|
|
14 Time of collection Time 5
|
|
15 Transaction No. Numeric 4
|
|
16 Sequence Numeric 4
|
|
17 Blank Space Null 16
|
|
|
|
Defining the format:
|
|
|
|
1.Branch Id :Here, By Default we are giving =000000000000101 (Need textbox entry in screen for Branch Id)
|
|
|
|
2.Category Code: Here, By Default we are giving =1
|
|
3.Scheme Code :Here, By Default we are giving =PIGMY
|
|
|
|
4.Account No :They have given only 5 digit account number :01807 so,based on the given structure format they have defined length as "15" so
|
|
in this case in prefix we need to adjust '0's :000000000001807 ( Account No. field from 2nd line of input file)
|
|
|
|
5.Customer Id: In progress..
|
|
|
|
6.Customer Name: For the customer name in input file they have give as:GEETA G MAGI ,the length given in input file was "17".So, based on
|
|
the given output structure file length should be "50" :GEETA G MAGI ( Customer Name: field from 2nd line of input file)
|
|
|
|
7.Closing Balance: Given closing balance was : 002600 .Based on the given struture format length defined as "13" :0000002600.00(Here,we are adding perfix to
|
|
adjust the length and also adding decimal to indicating that as an amount)-(Closing Balance: field from 2nd line of input file)
|
|
|
|
8.Agreed Amount: Here, By Default we are giving =0000000.00
|
|
|
|
9.Closing Balance Date :By Default we are giving =31-03-2024
|
|
|
|
10.Agent ID : In Input fist line they given as :00540 .Here, the structure length should be "15".So here, we adding perfix :000000000000540.( Agent’s account
|
|
no: field from 1st line of input file)
|
|
|
|
11.Amount Collected:Given amount collected was :000200.Based on the given struture format length defined as "10" :0000200.00(Here,we are adding perfix to
|
|
adjust the length and also adding decimal to indicating that as an amount) and (collection amount: field from 2nd line of input file)
|
|
|
|
12.Date of Collection:we need take the date of collection in First line of the input file :16-04-2024 (collection date: field from 1st line of input file)
|
|
|
|
13.Blank Space: One Blank space
|
|
|
|
14.Time of collection: By Default we are giving = 00:00
|
|
|
|
15.Transaction No:By Default we are giving =0000
|
|
|
|
16.Sequence:By Default we are giving =0000
|
|
|
|
17.Blank Space:We need to maintain "16" Blank space on the given structure.
|
|
|
|
|
|
Final Output should be:
|
|
|
|
0000000000001011PIGMY000000000001807000000GEETA G MAGI 0000002600.000000000.0031-03-20240000000000005400000200.0016-04-202400:0000000000
|