Defining a file format by bank
How to set up each bank account to have a different file format
-
Requisition Approval Processing Suite (RAPS)
RAPS Setup RAPS Utilities RAPS Requisition Entry RAPS Requisition Approval RAPS Convert Approved Reqs RAPS Purchase Order Cancel RAPS Delegation Maintenance RAPS Contract Module RAPS Expediting Module RAPS Pre-Revision Quotation Module RAPS - ATC Process (Approval to Commit) RAPS Enquiry by PSA Air Department RAPS Cost Controllers RAPS Unbudgeted/Budgeted
- AP - Automated Invoice Workflow
- AP - Payment Approval Management
- Global Upload Program (GUP)
- Document Register (DocReg)
- Rotables / Component Changeout
- Standard Pronto Modules
- PSA HelpDesk
The first step is to evaluate the bank setup in SYS.M054 Bank Master Maintenance. Each payment method should have its own bank account. The template is set to the bank code, so it is not possible to pay checks and ACH and EFT out of the same pronto bank code, even though it may be the same actual bank account.

The recommended solution is to take the bank account that is being set up for XML bank payments to have a final character referring to the payment type;
- A - ACH
- E - EFT
- W - Wire
- C - Distributed Check
So CHAS bank above would be CHASW for wires from this account.
Once these banks have been set up, it is possible to create a file format for the bank. It is recommended that after the bank accounts above are set up, a 1 dollar payment is made out of each account and cancelled, so that the bank account will show up in the ZUIT.M022 Bank Payment Register. The reason is that this screen only shows accounts that have had payments run through them.

Once a payment has been made and cancelled, it is possible to select the bank that is being set up and press on the TEMPLATES mode.

This allows the user to select an element of the file, and then set up the XML structure of the file. These file formats will be documented within this wiki as they evolve in the XML Payments Management page. Each section of the XML file, can have its content set up within a word pad, containing the XML.
It is important to note that fields called %VARIABLE*% are used to automatically pull from Pronto data fields where the data is dynamic. These will also be documented in the XML Payments Management page.

After setting up a header, details and footer template, it is now possible to test the bank file format.