Loading the Payment Return File

The Load Payments Return File program uploads the debit advice file to the F007101 and F007111 tables, and then calls the Debit Advice Payment Driver program (R74W211), which calls a debit advice format program. The debit advice format program writes the debit advice information to the following tables:

• F74W001

• F74W201

• F74W202

• F74W203

• F74W204

The Debit Advice - Format program, DNB (R74O212), is currently available.

Note: If the debit advice file has already been loaded in the F007101 and F007111 tables, you can set up the Load Payments Return File program (R74W210) to call the Debit Advice Payment Driver program (R74W211) without first loading the debit advice file. For this action, leave the Path to the Bank File processing option on the Load Payments Return File program blank.

You use a processing option on the Debit Advice Payment Driver program (R74W211) to specify whether the program should automatically update or reset the payments. If the program does not automatically update or reset the payments, you can review the debit advice information in the Work with Debit Advice program (P74W200), and then update or reset the payments.

If you specify in processing option 1 that the program should automatically update or reset the payments, the program uses the status of the file and the value in processing option 2 (individual update) to determine whether to update, reset, or take no action for each payment group as described in this table:

File Status	Value in Processing Option 2	Action
0 - Debit Advice no errors	1	Update
	0	Update
1 - Notice of Delivery no errors	1	None
	0	None
2 - Debit Advice with errors	1	Update passed groups, reset the others
	0	Reset all groups
3 - Server Error	1	None
	0	None
4 - Notice of Delivery with errors	1	Reset
	0	Reset