We did a simple data extract which seems to have met client requirements.
An interface which runs daily. Records are extracted from the payments file (F0413)if check date OR Void Date are equal to run date AND check is not a wire transfer (RMPYIT <> 'T')
Table used F0030, F0413
OutputFile JDE Mapping
PCACCT - Bank Account F0030.AYCBNK
PCCHKN - Check Number F0413.RMDOCM
PCAMT - Amount F0413.RMPAAP
PCCDAT - Check Date F0413.RMDMTJ
PCPGM - Job Program Name Text Variable
PCPDAT - Job Run Date Extraction Date Variable
PCPTIM
PCUSR
PCTDAT
PCFIL1
PCVCOD - Void Code 'V' if RMVDGL = Extraction Date
PCVCD2
This created a flat file which they then uploaded to the bank.
Hope this helps a little.
Sean
XE SP17.1_H1, AIX, Oracle8.1.7, JAS(17.1_H1) AIX, WebSphere3.5