JDE Archiving Methodology

DSauve

DSauve

Legendary Poster
Attached is a Word document describing one methodology for archiving of Work Orders, Sales Orders, Purchase Orders and Cardex information in OneWorld. I've also included SQL scripts to accomplish the SO and PO archiving (used for an Oracle database). Finally, I've included a copy of the JDE2DATE function we use to convert JDE dates to Oracle dates -- this function is used in the SQL scripts.

Please use caution with this and all archive/purge programs: TEST, TEST and TEST again before running against any production data.
 

Attachments

  • 63161-OneWorld Archiving.doc
    62.5 KB · Views: 2,226
Back
Top