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.