How to customize Disbursement Payment File Format
Summary:
How to customize Disbursement Payment File Format
Content (please ensure you mask any confidential information):
We are looking to implement a new electronic payment method in Fusion Payables. As part of the new file format we need to populate fields (Payee) Phone number and Payee Email address into the payment file to be sent to PNC bank. We envisioned loading this information as part of our FBDI Payment Request Import. In the FBDI import there are columns for Phone and Payee E-mail address:
If we populate the Phone and email address information into these fields how do we then include this in the Disbursement Payment File Format Template/Data Model? The existing query in the DM (TransactionDocumentExtractDm) has the following SQL query: