Micheal,
I'm in the process of completing a conversion/import that might do 'similar' to what you are requesting.
I find it frustrating that Oracle hasn't provided us a Z-File process, but... then... in dealing with some of their recent Z-File Processors ~ Maybe it is just cleaner that we build our own! Giving us import files, then randomly ignoring many of those columns is damned frustrating.
Here's a basic list of the functions necessary to streamline the process. The code is proprietary (the client is paying for it), so I can't just cut/paste....
Batch Open - Batch Control Processing
F0012 Get AAI Account Numbers
Header
F0413 Begin Doc
F0411 Update Voucher with Payment Info
Detail
F0413 Edit Line
Footer
F0413 End Doc
F0011 Update Transaction Commitment
F0011 Update on Exit
I did a real quick scan of code/logic ~ I think I caught the basis logic.
In a nutshell, that's the crux of the process. Now, the trick is actually identifying the necessary values for each function (Oracle is NOT your friend).
(db)