Understanding the Program Used to Reformat Bank Tapes

After you convert the bank tape to the F095051 flat file, run the Custom Reformat UBE program to convert the information to the F09505 workfile.

For the Custom Reformat UBE program to convert the data to the F09505 workfile, the data must be in these positions in the F095051 workfile:

Positions

Information

Specifications

Positions 1–8

Account ID

Enter the ID with or without leading zeros, right or left justified.

Positions 9–16

Payment number

Enter the payment number right justified with leading zeros.

Positions 17–46

Explanation

Enter the explanation for the payment.

Positions 47–61

Amount

If you are working with a decimal currency, enter the decimal or the whole monetary amount. For example, enter 200.00 CAD as either 200 or 200.00. If you enter the amount as 200000, the program tries to match the amount as 200000.00.

Positions 62–67

Payment date

Gregorian format

If data in the F095051 workfile is not in the positions specified, you must create a new custom reformat program. Use the Custom Reformat UBE program as a template for creating your custom program.