Service Desk

Input File1:(PCRX File 17-04-2024.dat)

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 PCRX File:

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

Download File in ERP Details Input 2:(PigmyDownload File.txt)

0000000000001011pigmy001023385000107100620Magi Geeta 0000000100.0000010.0031/03/202401023384000001 30/09/202331/03/2024000000000001807

Sequence No Field name Type of Data Length of data Reference

1 Branch Id Numeric 15 000000000000101

2 Category Code Numeric 1 1

3 Scheme Code AlphaNumeric 5 pigmy

4 Account No. AlphNumeric 15 001023385000107

5 Customer Id Numeric 6 00620

6 Customer Name Text 50 Magi Geeta

7 Closing Balance Decimal 13 0000000100.00

8 Agreed Amount Decimal 8 00010.00

9 Closing Balance Date 10 31/03/2024

10 Agent ID AlphaNumeric 15 01023384000001

11 Account Opening Date Date Format 10 30/09/2023

12 Last Transaction Date Date Format 10 31/03/2024

13 Society Account No Numeric 15 000000000001807

->Here, we have to Merge Second line of PCRX File Account No.( 01807) and Pigmy Downloaded File in ERP Society Account No (000000000001807) .

->We have to consider some of the fields from Pigmy Downloaded File in ERP: Below Mentioned fields are needed

1.Branch Id

2.Category Code

3.Category Code

4.Account No

5.Customer Id

6.Customer Name

7.Closing Balance

8.Agreed Amount

9.Closing Balance Date

10.Agent ID

->We have to consider some of the fields from PCRX File :Below Mentioned fields are needed

1.Date of Collection

2.Collection amount

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 :These details we have to fetch from PigmyDownloaded data in ERP. In case, if the pigmy Downloaded file has branch Id with 14 digits, we need to add prefix "0" to maintain the structure length "15".

2.Category Code: These details we have to fetch from PigmyDownloaded data in ERP.

3.Scheme Code :These details we have to fetch from PigmyDownloaded data in ERP. It should be Upper case [Eg:PIGMY]

4.Account No :These details we have to fetch from PigmyDownloaded data in ERP.

Case 1:Based on the given structure format they have defined length as "15" so in this case the less than "15" digit's we need to add prefix to '0's.

Case 2:In case

Example:Input: 023001485000029

Output: 003001485000029

In Some of the case the Account number occur like Input(023001485000029) for this the 2nd digit should be replaced with"0"

5.Customer Id: These details we have to fetch from PigmyDownloaded data in ERP. Based on the given structure format they have defined length as "6" so in this case the less than "6" digit's we need to add prefix to '0's.

6.Customer Name: The given output structure file length should be "50" :GEETA G MAGI ( Customer Name: These details we have to fetch from PigmyDownloaded data in ERP)

7.Closing Balance: These details we have to fetch from PigmyDownloaded data in ERP.

8.Agreed Amount: These details we have to fetch from PigmyDownloaded data in ERP

9.Closing Balance Date :These details we have to fetch from PigmyDownloaded data in ERP

10.Agent ID :These details we have to fetch from PigmyDownloaded data in ERP.

Case 1:Based on the given structure format they have defined length as "15" so in this case the less than "15" digit's we need to add prefix to '0's.

Case 2:In case

Example: Input: 23001484000001

Output: 003001484000001

In Some of the case the Agent number occur like Input(23001484000001) for this the length of input given '14' for this we need to add prefix 0 and for the 2nd digit should be replaced with"0"

11.Amount Collected: Given amount collected was :000200.Based on the given structure 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 consider 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 required format is as below (00014771704u-New output file.txt):

0000000000001011PIGMY000000000001807000000GEETA G MAGI 0000002600.000000000.0031-03-20240000000000005400000200.0016-04-202400:0000000000