XML File Overview
What is an XML file and how do we create it
Written by Jarrad Sonnenberg
Updated at September 8th, 2022
-
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
Most banks accept a file format called XML.pain.001 v3. This is the standard format PSA has based its integration engine on.
XML is tagged like the below example;
<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <CstmrCdtTrfInitn>
<GrpHdr>
<MsgId>%VARIABLE1%</MsgId>
<CreDtTm>%VARIABLE2%</CreDtTm>
<NbOfTxs>%VARIABLE3%</NbOfTxs>
<InitgPty>
<Nm>PSAInc</Nm>
<Id>
<OrgId>
<Othr>
<Id>CIBCCATT</Id>
</Othr>
</OrgId>
</Id>
These XML files transmit the details of each payment to the bank. Each bank may have slightly different file formats when generating a payment file, but for the most part the structure is consistent, it may just be a tag or two that changes.
It is important to note that each method of sending a payment, Wire, EFT, Check, ACH has a slightly different file format. Therefore a bank account should be set up in SYS.M054 Bank Master Maintenance for each file format.
As an example using the same bank code with a W/E/A/C on the end, and the same GL code will still allow bank reconciliations to function properly, but it will allow the payment format to be appropriate for each payment run.
