%VARIABLE% Definitions
Written by Jarrad Sonnenberg
Updated at September 12th, 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
When setting up a payment template, Pronto needs to automatically source key data from within the ERP. To do so dynamically, there are %VARIABLES% set up. These variables will pull this data into the XML file automatically.
| Section | Variable Name | Field | Description |
| Header | %VARIABLE1% | zxbp-atch-ref | Batch Reference |
| Header | %VARIABLE2% | System-Date-Time | Create Date/Time YYYY-MM-DDTHH:MM:SS |
| Header | %VARIABLE3% | Transaction/Payment Count | The qty of transactions being sent in the file. Counted at the time of processing the file. |
| Header | %VARIABLE4% | System-Create-Date |
Create Date YYYY-MM-DD |
| Header | %VARIABLE5% | zxbp-our-bank-account-no | Bank Account Number |
| Header | %VARIABLE6% | zxbp-our-bank-routing-no | Bank Account Routing Number |
| Header | %VARIABLE14% | zxbp-bsb-code | Routing Code |
| Header | %VARIABLE15% | System Date | File Create Date in format YYMMDD |
| Header | %VARIABLE16% | System Time | File Create Time in format HHMM local time |
| Header | %VARIABLE17% | Daily Alpha Unique Sequence | Starts with the letter “A” and each file created increments it to the next letter in sequence and resets back to “A” daily |
| Header | %VARIABLE18% | zxbp-date | Bank Rec Transaction Date in YYMMDD format |
| Detail | %VARIABLE1% | zxbp-atch-ref | Batch Reference |
| Detail | %VARIABLE5% | zxbp-our-bank-account-no | Bank Account Number |
| Detail | %VARIABLE6% | zxbp-our-bank-routing-no | Bank Account Routing Number |
| Detail | %VARIABLE7% | “CAD” or the foreign currency code on the transaction (zxbp-trans-curr-code) | Currency Code |
| Detail | %VARIABLE8% | zxbp-local-amount or zxbp-foreign-amount if not CAD currency | Local or foreign amount depending on currency |
| Detail | %VARIABLE9% | zxbp-bank-name | Bank Name |
| Detail | %VARIABLE10% | zxbp-swift-code | Swift Code |
| Detail | %VARIABLE11% | zxbp-bank-account | Bank Account |
| Detail | %VARIABLE12% | zxbp-payment-purpose | Payment Purpose |
| Detail | %VARIABLE13% | zxbp-document-no | Document Number |
| Detail | %VARIABLE14% | zxbp-bsb-code | Routing Code |
| Detail | %VARIABLE15% | Na-name | Customer Name |
| Detail | %VARIABLE16% | Na-suburb | Suburb |
| Detail | %VARIABLE17% | Na-country | Country |
| Detail | %VARIABLE18% | Na-address-6 | Address Line 6 |
| Detail | %VARIABLE19% | Na-address-7 | Address Line 7 |
| Detail | %VARIABLE20% | Postcode | Post Code |
| Detail | %VARIABLE21% | zxbp-bsb-code | Calculated 9th digit |
| Detail | %VARIABLE22% | zxbp-account-type | DA = 22 SG = 32 SPACES = 22 |
| Detail | %VARIABLE23% | zxbp-document-no | 7 digit zero padded |
| Detail | %REMITTANCEINFO% | Remittance Information | |
| Remittance | %VARIABLE1% | cr-tr-curr-code or sys-local-currency-code when blank | Transaction Currency |
| Remittance | %VARIABLE2% | cr-tr-overseas-amount | Overseas Amount |
| Remittance | %VARIABLE3% | cr-tr-amount | Transaction Amount |
| Remittance | %VARIABLE4% | cr-tr-reference | Transaction Reference |
| Footer | %VARIABLE1% | Transaction Count (calc) | 6 digit zero padded |
| Footer | %VARIABLE2% | Entry Hash (calc) | Sum the first 6 character of all the BSB codes in the file ten digits zero padded |
| Footer | %VARIABLE3% | Total Transaction Value | No decimal 12 digits zero padded |
| Footer | %VARIABLE4% | Block Count | (Trans count + 12) / 10 – 6 digits zero padded (rounded) |
