I need help with this assignment (please use lots of //comments to help me understand):

 

Your accounts receivable department needs to set up a monthly EMT (Electronic Monthly Transfer) to collect insurance fees from your customers. In order to accomplish this, your bank needs a formatted EMT file (emt_out.txt) with your customer information. Unfortunately, your customer management system can only provide you a comma delimited file(data_records.txt).

 

The file vitals are as follows:

Customer Name

Customer’s Bank Routing Number (9-digits)

Customer’s Bank Account Number (10-12 digits)

Customer’s Monthly Rate

Customer_ID

 

Use the data in the data_record.txt file to generate an EMT file (emt_out.txt) for your bank. Your bank requires your EMT file to match a specific format in order to process your clients insurance payments. The EMT file will be used by your bank to deduct payments from your client's checking accounts and place the total amount collected into your company's checking account.

The EMT file description is as follows:

Line1 contains the Job Header (a unique job name):

JOB $$$NAME = 194238456-01

Line2 contains your Bank's Header (your banks information):

101 10272016000019423845601WELLS FARGO Los Angeles

 

Line 3 contains your Company's Header (Your company's name, checking account, and deduction description):

1250APLHA CORP000019423845601INSURANCE PAYMENT

 

Line4 - LineN The EMT Detail lines begin with 627 and contain the customer's bank info, payment amount, ID, and name:

[627(3)][Routing Number(9)][Account Number(10-12)]   {30}[Payment(10)][Customer ID(13)] {55}[Name(25)]

Last Line begins with 1250 and is used for Error Checking:

[1250][Record Count(6)][Sum of Routing Numbers(16)][Sum of Payments(12)][000000121250]

• 1496992229-emt_out.txt
• 1496992233-data_records.txt

SuperTutor

(15)

Status NEW Posted 09 Jun 2017 07:06 AM My Price 20.00

-----------

Attachments

file 1496992237-Solutions file.docx preview (51 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer